Course Content
EXPLORING THE MICROSOFT OFFICE ACCESS
- 2007 ENVIRONMENT
- Examine Database Concepts
- Exploring the User Interface
- Use an Existing Access Database
- Customize the Access Environment
- Obtain Help
DESIGNING A DATABASE
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
- Setting rules to ensure valid relationship
BUILDING A DATABASE
- Create a Database
- Create a Table
- Manage Tables
- Create a Table Relationship, Delete and Apply rules
- Save a Database as a Previous Version
MANAGING DATA IN A TABLE
- Modify Table Data
- Sort Records, Add, Delete Records
- Navigate within table
- Define key, primary key , Indexing
- Creating one to one one to many relations
- Work with Subdatasheets
QUERYING A DATABASE
- Filter Records, Navigate records
- Form headers footers
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
- Use two table querys
- Using operators within queries
- Editing, running and deleting a query
- Savinng and closing a query
DESIGNING FORMS
- View Data Using an Access Form
- Create a Form
- Modify the design of a Form
GENERATING REPORTS
- View an Access Report
- Create a Report
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat Style to a Report
- Prepare a Report for Print