Access 2003 Specialist
Category
Database and Collaboration Tools
Vendor
Microsoft More information »
Scheduled Dates
This course is not currently scheduled. Please contact us for more information on course availability.
Course Description
You will learn the following skill sets:
Structuring Databases - Create Microsoft Access databases • Create and modify tables • Define and modify field types • Modify field properties • Create and modify one-to-many relationships • Enforce referential integrity • Create and modify queries • Create forms • Add and modify form controls and properties • Create reports • Add and modify report control properties • Create a data access page
Entering Data - Enter, edit, and delete records • Find and move among records • Import data to Access
Organizing Data - Create and modify calculated fields and aggregate functions • Modify form layout • Modify report layout and page setup • Format datasheets • Sort records • Filter records
Managing Databases - Identify object dependencies • View objects and object data in other views • Print database objects and data • Export data from Access • Back up a database • Compact and repair databases
Cost
$199
Time
8 hours
Prerequisites
High School Diploma or GED