Course Overview
This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.
Course Objectives
Introducing Access 2007, Opening An Existing Database, Creating a New Table Using Datasheet View, Adding Records to a Table, Finding Data, An Overview on Queries, Forms, Reports, Create A New Table In Design View
Agenda
1 - Introduction
2 - Introducing Access 2007
- Starting Access
- Navigating the Main Screen
- Using the Quick Access Toolbar and Ribbon
- Using the Navigation Pane
- Navigating in the Document Window
3 - Opening An Existing Database
- Opening a Table
- Navigating a Table
- Using Quick Search
- Using Quick Filter
4 - Creating a New Table Using Datasheet View
- Adding Fields
- Changing the Data Type
- Adding a Lookup Field
- Deleting a Field
5 - Create A New Table In Design View
- Understanding The Design View
- Setting Input Masks
- Using The Lookup Tab
- Indexing A TableÂ
6 - Adding Records to a Table
- Adding a Record
- Using Zoom Mode
- Using Shortcut Keys
- Filtering Data
7 - Finding Data
- Using the Find Dialog Box
- Using Replace
- Deleting Records
- Changing Table Appearance
8 - An Overview on Queries
- Understanding Query Types
- Using the Query Wizard
- Using the Query Design View
- Using the QBE Grid
- Entering Criteria
- Creating a Query Manually
- Using Logical Operators in Criteria
- Using Wildcards in Criteria
9 - Forms
- Understanding Forms
- Creating a New Form
- Using the Form Design Window
- Selecting, Moving, and Resizing Controls
10 - Reports
- Understanding Report Design Steps
- Creating a Report
- Modifying Controls in a Report
- Basing a Report on a Query
- Adjusting and Printing a Report
11 - Conclusion