How to Write a Query for Employee Sick Leave in Access Database
- 1). Open your database and go to the navigation pane. Double-click each of the tables in the database until you find the table that contains the field used to track employee sick leave.
- 2). Click "Create" on the ribbon and choose the "Query Wizard" option. Choose the table containing the employee sick leave field and double-click to add it. Click "Close" to close the add table window.
- 3). Double-click each field you want to add to the query. Include the employee sick leave field, as well as the fields showing the name and identifying information for the employee.
- 4). Click the "Save" button on the quick access toolbar and give the query a descriptive name, such as "Employee Sick Time" or "Sick Time Tracking." Go to the navigation pane and double-click the query to open it.
