Access. Advanced Level

TEACHING UNIT 1. OPTIMIZING INFORMATION IN ACCESS

1. Field data types.
2. Field sizes.
3. Field format.
4. Field input mask.
5. Search fields.
6. Relationships Between Tables.
7. Types of Relationships.
8. Referential integrity.
9. Related records.
10. Modify relationships.
11. View and print reports.
12. Importing data between tables.
13. Import data from Microsoft Excel.
14. Linking data between tables.
15. Link data from a Microsoft Excel spreadsheet.
16. Export data to Microsoft Word.
17. Export data to Microsoft Excel.
18. Merge mailings.
19. Compact and repair a database.

TEACHING UNIT 2. FORMS AND REPORTS

1. Create forms using AutoForm.
2. Create forms using the wizard.
3. Add fields to a form.
4. Customize a form.
5. Add dependent controls.
6. Add standalone text boxes.
7. Add list controls to a form.
8. Sections of a form.
9. Add and remove filters from a form.
10. Create reports using the self-service reporting feature.
11. Create reports using the wizard.
12. Sections of a report.
13. Header and footer of a report.
14. Tags in a report.
15. Add dependent controls.
16. Add standalone text boxes.
17. Group records in a report.
18. Create a subreport.
19. Create a subreport based on an existing one.
20. Link reports and subreports.
21. Properties of a subreport.

TEACHING UNIT 3. QUERIES, MACROS, AND THE INTERNET

1. Create simple selection queries.
2. Create cross-reference table queries.
3. Customize cross-reference table queries.
4. Create a parameter query.
5. Create an action query.
6. Create a delete query.
7. Create an update query.
8. Creating filters based on queries.
9. Create a data access page using AutoPage.
10. Create a data access page using the wizard.
11. Merge a data access page.
12. Group records.
13. Create a static HTML page.
14. Publish a data access page.
15. Forms and reports as pages for accessing data.
16. Modify a data access page.
17. Create a simple macro.
18. Open and edit an existing macro.
19. Group macros.
20. Run a macro.