Finding Sorting Filtering Data
Finding Data Table
Sorting Access Records
Filter Records to Display Record Subset
Filter Records Complex Criteria
Creating Access Queries
What are Queries
Query Access Database Window
Simple Query Wizard
Query Design View
Creating Query Design View
Save Query Design
Editing Query Design
Adding Criteria to Queries
Values in Criteria Expressions
Multiple Queries in Access
Specifying Sort Order
Creating Calculated Fields
Creating Access Forms
Access Auto Form
Displaying Records Access Form
Form Design View
Access Resize Controls
Access Form controls
Add Access Bound Controls
Toolbox Buttons Add Controls
Format form Controls Design form
Create Calculated Controls
Design Create Report
MS Access Reports
Navigating Report View
Access Mailing Labels
Report Design View
Header Footer Sections
Navigating Access Report View - Exercise
Create and Navigate Access Report
Create a report with the Report Wizard, and view it in the Report view.
This exercise is worth 5 points. The exercise is auto-scored, which means that all you have to do to receive credit for it is click the
In this exercise, you will get the chance to create a complex report using the Report Wizard. The report will contain project and hours information, with a calculation of the total hours spent on each project.
Start the Report Wizard.
Select the following fields from the Projects table:
Select the following fields from the Hours table:
Group the report by Projects (that is, by the Projects table).
Add Company as an additional grouping level.
Sort the detail records in descending order by Date.
Use the Summary Options dialog box to Sum the values in Hours Worked.
Choose a layout for your report.
Choose a style for your report.
Name the report Hours by Project and preview the report.
Look at different parts of the report. Note how projects are grouped, and the calculations that Access does at the end of each project, company, and at the end of the report.