      |
Access 2010 Introduction
Course
Length
Full day
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 a database
- Display
Backstage View
- Identify
window elements
- Trust a
database
- Use the
Ribbon, Quick Access Toolbar, and Access Help
- View, open, &
close database objects
Tables
- Move and
select in a table
-
Change row height
and column width
-
Save the datasheet
layout
-
Move, freeze and
unfreeze fields
-
Hide and unhide
fields
-
Use Find, Replace
and undo
-
Add a Total row
-
View or modify
data in a subdatasheet
-
Sort and restore
records in a table
-
Filter records in
a table
-
Add, edit, and
delete records
-
Check spelling,
print preview and print
-
Delete a database
object
Database Creation
-
Create a new
database
-
Use naming
conventions
-
Explore field
names, data types, and field descriptions
-
Create tables and
change views
-
Open a table in
Design view
-
Add, move, and
delete fields
-
Change a data type
for a field
-
Change field
properties
-
Work with input
masks
-
Assign and delete
a primary key
Forms
-
Open a form and
change form view
-
Navigate in a form
and add records
-
Sort and filter
-
Create and save a
form
-
Edit, print, and
delete records
-
Display the
property sheet
-
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
-
Remove a table
from a query
-
Display/hide table
names in the Design Grid
Reports
-
Open a report and
change the view
-
Display the
property sheet in a report
-
Create and save
reports
-
Add bound and
unbound controls
-
Modify report
sections
-
Remove controls
from a layout
-
Select, move,
resize, and delete field list controls
-
Preview and print
reports
-
Change page setup
Importing and
Exporting
What
Participants Receive
Each
participant receives a guide containing step-by-step instructions and
a laminated reference card.
|
