Microsoft Access Training
Microsoft Access 2000 Training
MS Access offers the tools necessary to create and maintain simple and comprehensive databases. Our training series teaches you the
applications and highlights the features contained within the program.
Level I Tutorial: Level One begins with training on opening a database file and continues to cover the Objects bar, navigation of records in query or table format, and the use of online help. It
concludes with switching between object views, displaying records in a datasheet, and the sorting and searching of records.
Introduction to Access
Sorting & Displaying
Laying the Foundation
One Simulation
Review Questions
Adding Records
Add a Record Simulation in Form View
Add a Record Simulation in Table View
Editing Records &Filtering
Show Sort Simulation
Show Filter Simulation
Show Edit Simulation
Review Questions
Creating a Database
Creating a Manual Table
Datatypes in Access
Creating a Query
Selecting Criteria
Creating Forms
Includes Manual Forms
Creating Reports
Level II Tutorial: Level Two covers training for editing of data records, creation of tables, and how to determine the correct data input and output for a table.
Importing Data in MS Access
Data Relationships
Normalization & Related Tables & Relationships
Table Relationships
Referential Integrity
Table Properties
Advanced Queries
Updating Queries
Building a Summary Query & Cross Tab Queries
Conclusion
Level III Tutorial: The final training Level teaches you how to create and modify a query, select records with specific objectives, how to create and modify a form and how to build and modify a report.
Advanced Forms in Microsoft Access
Subforms
Tab Control
Advanced Reports
Reports Summary
Charts
Conclusion
Now Available Microsoft Office XP, 2003 and 2007
|
All Three MS Access Training CD-ROMS
Beginning/Intermediate/Advanced
|
kyacm2am
|
$99.95
|
|
.
|
