Access
Microsoft Access 2003 Certification
Live Online Training with Live Tutors
Our Access 2003 gives you powerful new tools for managing your data. Share your database with co-workers over an Intranet, find and retrieve information quickly, and take advantage of automated, pre-packaged solutions to quickly create databases. Our interactive training series will show you how to utilise all of the tools contained within the most versatile and popular database program available!
Learning / Exam module: Access 2003
Course Duration: 20 hours.
Learning Segments:
Introduction
Level 1 - Overview
The Course Scenario
Creating a Database
Creating a Table in Design View
Entering Data into a Table
Using AutoForm
Using AutoReport
Using AutoPage
Summary
Level 2 - Overview
Using the Simple Query Wizard
Creating a Query in Design View
Joining Tables
Using Computed Fields
Using the Crosstab Query Wizard
Creating a Form
Using the Form Wizard
Changing Form Properties
Handling Form Events
Creating a Report
Using the Report Wizard
Creating a Report in Design View
Creating Data Access Pages
Using the Data Access Page Wizard
Summary
Level 3 - Overview
Finding and Updating Records
Creating Update and Delete Queries
Changing Table Structure
Modifying a Datasheet
Using the PivotTable View
Establishing Validation Rules
Setting Default Values
Enforcing Referential Integrity
Defining Relationships
Sorting and Indexing Data
Using Database Utilities
Importing and Exporting Data
Summary
Testimonials
“I’m pleased to tell you that I have passed both A+ exams to day. Your online training and exam prep material did a great job in preparing me to pass!”
Neil Bottomley, Poole, Dorset.
“Great news guys, I passed my ICND part 2 exam. I am now CCNA. You guys have helped to keep me motivated and keep on going even when things were looking really tough.”
Dave Cooper
“15 months ago I was made redundant from a bus company. Now I have a new career as a Microsoft Systems Administrator earning £35,000 a year. I have got LiveTrain Learning to thank for providing me with the learning materials and support to start in an entirely new career direction”
Trevor Linch MCSE, Winchester, Kent
“The quality of the training materials is very impressive and they provide a lot more than just the paper based courseware you would normally get for spending twice as much with other companies. I find the video lectures and demonstrations very informative. Most of all I like the fact that I get lots of hands on practice!”
Irene Vincent, Worthing, Sussex
“We used to send our staff away to learn Microsoft Office at £400 per day; we can now provide each staff member with the same instructor-led style training on site for a fraction of that price”
Sue Herbert, Personnel Manager, Datalink
“This course is very well presented. The instructor is clear and concise, provides a wealth of knowledge and explains the real world applications. The CEH course is definitely for anyone who is serious about Computer Security. I would recommend this course to anyone presently doing programming who wishes to get a better understanding of the different classes of a hacker and the procedures in which a "cracker" (Black Hat Hacker) goes through to gain access into any system. I am enjoying going through this course-- and I am going to complete it ahead of time!”
Paul Turnbull, Manchester