      |
Access 2010 Intermediate
Course
Length
Full
day
Prerequisites
Access
2010 Introduction or equivalent experience
Course
Topics
Relational Databases
-
Normalize tables
-
Use the Table
Analyzer
-
Identify object
dependencies
-
Set relationships
between tables
-
Print a report
listing table relationships
-
Implement
referential integrity between related tables
Related Tables
-
Use the Lookup
Wizard to create a lookup field and a multi-valued field
-
Modify properties
for a lookup field
-
Use a subdatasheet
to add data to related tables
Complex Queries
-
Create outer join,
inner join, and self-join queries
-
Find non-matching
records and duplicate records
-
Delete tables from
a query
-
Create calculated
fields in a query
-
Use the Expression
Builder
-
Use queries to
view summarized and grouped data from tables
Advanced Form Design
-
Add unbound
controls to a form
-
Change the tab
order of controls
-
Group controls
-
Use controls to
add graphics to a form
-
Use controls to
add calculated fields to a form
-
Add a combo box to
a form
-
Create
multiple-item forms, split forms, datasheet forms, and subforms
Reports and Printing
-
Customize report
headers and footers
-
Set properties for
grouping data in the report
-
Use conditional
formatting
-
Change the
appearance of a report
-
Add calculated
values to a report using functions
-
Print database
objects and a report of database design
-
Create and print
labels
Charts
PivotTables and
PivotCharts
What
Participants Receive
Each
participant receives a guide containing step-by-step instructions and
practice exercises.
|
