|
This class covers basic concepts in Microsoft Access and teaching the foundational skills for designing and building a database. Training Class Goal
Students will come from this class feeling confident in designing a simple Access database or making changes to an existing one.
Prerequisite
Intermediate computer skills and experience with Microsoft Excel and other Microsoft Office programs.
Training Topics Covered
Database Concepts
- Design vs. Datasheet View
- Database wizard
- Creating blank databases
- Creating tables
Working with Fields
- Adding fields
- Identifying primary key fields
- Adding records
- Changing table designs
- Modifying field names
- Deleting and inserting fields
Records
- Finding and editing records
- Sorting and filtering records
- Setting field properties
- Input Masks
- Validation Rules
- Indexes
Queries
- Creating Queries
- Filtering Queries
- Modifying query results
- Operations in Queries
- Using Calculators
- Average and Count functions
- Creating forms to enter data
- Formatting and customizing forms
- Using forms to find, sort, and filter records
- Creating reports through the report wizard
- Field properties
|
Upcoming Classes
Microsoft Access 2007 and 2010 are very similar. Students with either version should be comfortable in this combined class.
Access 2003 is very different from 2007 and 2010. Students with 2003 should take classes taught in that version.
Access 2007 / 2010
- Uses the Ribbon and command icons for navigation.
- Navigation Pane
Access 2003
- Tool Bars and Menus for navigation
Which version do I have?
|
