Access 2007 Essentials
Welcome to the Microsoft Access 2007 Essentials course. Access is the world’s premier database software. You can use Access to create and edit databases -- just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access. Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability.
Course Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.
By the end of this course, 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
Categories
Microsoft Access