Course Details

By attending this course, students will learn to:

• Create powerful, effective Access Databases
• Enter, edit, update, search, sort and filter Table records
• Set defaults and validate data for more accurate data entry
• Quickly edit, filter and search records in a Form
• Add option controls, command buttons and drop-down lists for faster data entry and accuracy in Forms
• Add custom fields to perform calculations: Sum, Count, Average and more
• Add, sort and filter groups as well as keeping them from splitting across pages in your Reports
• Use criteria in a Query to dramatically refine your search
• View unique records and use Actions Queries to Update, Add and Delete records fast
• Automate data entry and accuracy dramatically by creating Macros