      |
Access
2007 Introduction
Course
Length
Full day
Prerequisites
Windows
Introduction or equivalent experience
Course
Description
This class introduces
participants to Access, a database management program used to store
different types of information in an organized way so it can be easily
and selectively retrieved. Users will create a new database and work
with an existing database. Participants will learn how to manage and
present the information using tables, queries, forms, and reports.
Course
Topics
Getting Started
- Understand
database types, relational databases, key fields, and relationships
- Plan, open,
and trust a database
- Use the
Ribbon, Quick Access Toolbar, and Access Help
- View, open, &
close database objects
Tables
- Move and
select in a table
- Modify and
save a datasheet layout
- Change row
height and column width
- Move, freeze,
and hide columns
- Modify text,
use Find, Replace, & Undo
- Add a total
row to a table
- View or modify
data in subdatasheets
- Sort and
restore records in a table
- Add, edit, and
delete table records
- Check
spelling, print preview and print
- Delete a
database object
Database Creation
- Create a new
database
- Understand
naming conventions
- Explore field
definitions and data types
- Create tables
and change views
- Modify a table
in design view
- Add, move, and
delete fields
- Change a field
definition and properties
- Work with
input masks
- Assign and
delete a primary key
Forms
- Open a form
and change views
- Navigate in a
form and add records
- Create and
save a form
- Sort, filter,
edit, print, and delete records
- View a form
record source
- Add a caption
Queries
- Run a saved
query and change views
- Create, run,
and save a select query
- Select columns
& rows in the design grid
- Remove fields
from the design grid
- Hide a field
in the query results
- Sort records
in a query
- Rearrange the
order of the fields
- Use criteria,
comparison operators, and wildcard characters
- Create
calculated fields
- Create a
“totals” calculation
- Create
multi-table queries
- Display table
names in the design grid
Reports
- Open a report
and change the view
- Sort and
remove a sort in a report
- Add bound
and unbound controls
- Create and
save reports
- Remove
controls from a layout
- Select, move,
resize, and delete field list controls
- Preview and
print reports
- Change page
setup
Importing and
Exporting
- Import or link
Excel data to Access
- Export Access
data to Excel
What
Participants Receive
Each
participant receives a guide containing step-by-step instructions and
practice exercises.
|
