CAPL 1027 - Microsoft Access

1. Database concepts and terminology
2. Building a relational database
3. Database and table modifications
4. Query a database
5. View/organize/locate information
6. Calculated controls
7. Calculations in a Query
8. Cross tab query
9. Find duplicates and unmatched queries
10. Indexes
11. Integrate information from other applications
12. Join tables
13. Look-up field in table
14. Multi-table Query
15. Mailing labels
16. Action queries
17. Advanced table relationships
18. Automating tasks with macros
19. Create custom forms and reports
20. Create form and reports
21. Sharing, integrating, and analyzing data

1. Create and modify databases, forms, and reports
2. Define table relationships
3. Filter data in a table and form
4. Plan and design custom forms and report
5. Create simple and complex queries
6. Enhance table design
7. Automate tasks with macros
8. Secure a database

Courses and Registration