Microsoft Access 2003 Online Video Course
£56.99 (inc. VAT)

Course Description

Following this course, you will be prepared to pass the Microsoft Office Access 2003 Certification Exam. Access 2003 Specialist certification is intended for students and information workers whose responsibilities include creating or using Access database solutions to organize, access, and share information. Each lesson will cover objectives required for the examination and for increasing your productivity with Microsoft Access 2003, including:

STRUCTURING - Create 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 - Use forms and data access pages

ORGANIZING - Create and modify calculated fields and aggregate functions - Modify form layout - Modify report layout and page setup - Format datasheets - Sort and filter records

MANAGING - 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

Course Length: 4 hours

System Requirements:
A multimedia PC with a 512 Kb/sec or faster Internet connection running Mozilla Firefox, Google Chrome or Microsoft Internet Explorer with Adobe Flash Player. Please note: You can improve performance by re-sizing and lowering the picture quality of the video.

Subscription: 1 year.

Course Contents