Microsoft Office Access Beginners Course
Prerequisites
This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Access is necessary.
Course Outline
- Introduction to databases
- Introduction to objects
- Getting started in Access
- Managing databases and objects
- Delete database objects
- Working with tables
- Modifying tables
- Hide fields in a table
- Add table descriptions
- Rename tables
- Add validation rules to fields
- Modify field properties
- Sorting and filtering records
- Print and export data
- Working with forms
- Create quick forms
- Create forms by using the forms wizard
- Save forms
- Formatting forms
- Designing a simple query
- Designing a multi-table query
- More query design options
- Save queries
- Modifying queries
- Creating reports
- Format reports