CATEGORY:
Office 2007 Essentials
Access 2007 Essentials
Course Access: Lifetime
Course Overview
Workshop Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.
By the end of this workshop, participants should be able to:
- Open and close Access
- Create a blank database from a template
- Open, close, and save a database
- Use the Ribbon Interface
- Work with database Objects
- Sort and Filter the View
- Create a blank table from a template, in Datasheet view, and Design View
- Use Lookup columns in a table
- Add information to a table
- Edit, delete and search records
- Create a form with the Wizard and in Layout View
- Modify a form in Design View
- Perform common formatting tasks on forms
- Use Auto Format
- Add or move controls on a form
- Create reports using the Report Wizard
- Understand the Report Design View
- Add a Logo to a report
- Create Queries using the Wizard
- Execute a Query
- Understand the Query Design View
- Understand Access file formats and save a database as another file format
- Print an Object
- Back up the database
- Email the database