Page 162
COMPUTER SKILLS
Page 163
ACCESS 2007 - BASIC
Section 1 - Access Basics
Database Terms
Starting Access
Open/View a Table
What’s New with 2007
Getting Started Screen
Office Button
The Ribbon
Access Options
Quick Access Toolbar
Customizing
Repositioning
Opening a Table
Closing a Table
Home Tab
Design View
Datasheet View
Save
Print Preview
Getting Help
Exit Access
Section 2 - Database Design
Database Design
Objects
Design a Table
Define Fields
Save the Table
Add Data
Modify the Design
AutoForm
Form Layout grid
Align Controls/Tab Order
Close the Form
Section 3 - Editing a Table
Datasheet Edits
Add/Delete Records
Data Entry Shortcuts
Add/Delete Fields
Modify Field Type
Primary Key
Display Options
Change Column Widths
Rearrange Columns
Section 4 - Sorting a Table
Sort Commands
Ascending/Descending Order
Multiple Field Sort
Filters
Filter by Selection
Remove Filter
Filter by Form
Conditional Statement
Section 5 - Customize Tables
Field Properties
Required field
Default value
Define Rules
Test the Rule
Like Expression
Input Masks
Formats
Date Format
Custom Format
Number Formats
Page 164
ACCESS 2007 - INTERMEDIATE
Section 1 - Importing and Exporting
Import an Excel List
Import an Access Object
Export Data to Excel
Section 2 - Creating
Relationships
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Set Relationships
Referential Integrity
Remove Relationships
Preview Relationships Subdatasheet
Section 3 - Advanced Queries
Parameter Queries
Criteria
Between option
Calculations in Queries
Action Queries
Make-Table Query
Append Query
Update Query
Delete Query
Section 4 - Advanced Forms
Calculations in Forms
Calculated Fields
Combo Boxes
Use the Properties Window
Use the Control Wizard
Subforms
Section 5 - Creating Groups and
Totals
Create a Grouped Report
Sort and Group
Page Breaks in Reports
Add a Forc