| COURSE
DESCRIPTION
Improve
your skills and marketability with in-depth. Access knowledge. Access
offers you an opportunity
to manage, plan and build a simplified solution for your data. Learn
how to plan a database, build the
structure, control data entry, find and join data, create flexible
queries, improve forms, customize reports, export data and control
data integrity.
PREREQUISITES
Microsoft Access
2003 - Level 1
| CORE
TOPICS |
| Planning
a Database |
|
Customizing
Your Reports |
| Design
a relational database
Identify
database purpose
Review
existing data
Determine
fields
Group
fields
Group
fields into tables
Normalize
the data
Designate
primary and foreign keys |
|
Organize
report information
Set
report control properties
Control
report pagination
Summarize
information
Add
a subreport to an existing report
Create
mailing labels |
| Building
the Structure of a Database |
|
Creating
Flexible Queries |
| Create
a new database
Create
a table using a Wizard
Create
tables in Design View
Create
relationships between tables |
|
Set
select query properties
Create
parameter queries
Create
action queries |
| Controlling
Data Entry |
|
Improving
Your Forms |
| Restrict
data entry with field properties
Create
an input mask
Create
a lookup field |
|
Enhance
the appearance of a form
Restrict
data entry in forms
Add
command buttons
Create
a subform |
| Finding
and Joining Data |
|
Expanding
the Reach of Your Data |
Find
data with filters
Create
query joins
Join unrelated
tables |
|
Publish
Access data as a Word document
Analyze
Access data in Excel
Export
data to a text file
Merge Access
data with a Word document |
|
