Microsoft Access Training Course 2007

Microsoft Access 2007 is the latest database management program from the Microsoft Office 2007 suite. Microsoft introduces a significant number of new features that make managing, organizing, accessing, and sharing information much more easier and faster than previous versions.

This online training course is designed to teach users how to use Microsoft Access 2007 database. It contains a series of online video-based tutorials designed for users who are either new to databases, or those who want to improve and consolidate their Microsoft Access database skills. The course not only covers the basics of Microsoft Access database such as creating database tables, forms, queries, it also covers advanced features, including advanced queries, expressions etc...

This is an interactive course that utilizes the latest training technologies and allow students to fully engage with the course materials. It is designed in a way to maximize retention by students.

Excercise files can be downloaded by subscribed users who want follow along each tutorials.

Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.

THIS COURSE IS STILL BEING DEVELOPED. ONLY TUTORIALS IN THE COURSE OUTLINE HAVE BEEN COMPLETED.

Training Courses

Microsoft Office 2007 Training

Microsoft Excel 2003 Training

Excel VBA Training

Microsoft Access 2003 Training

Access VBA Training

Dreamweaver 8 Training

PowerPoint 2003 Training

Windows XP Training

Please see below the Microsoft Access 2007 training course outline. All tutorials will be activated immediately when you subscribe. Subscribe now or try a sample tutorial below.

Sample tutorial: Creating table relationships

Training Course Outline

Getting Started with Microsoft Access 2007
Access 2007 interface
Database objects
Creating a blank database
Creating a blank database using templates
The Navigation Pane
The Trust Center
Introduction to Access options

Working with Database Tables
Creating database tables
Editing datasheets
Table design view
Arranging order of fields
Data types
Adding field descriptions
The primary key
Field properties

Managing the Datasheets
Navigating
Sorting
Filtering
Formatting
Re-arranging columns
Hiding columns
Freezing columns

Relational Databases
Introduction to relationships
Primary and foreign keys
Creating relationships
Join types
Referential integrity
Relationship types

Creating Queries
Introduction to queries
Creating a select query
Using the query wizard - select query
Using the query wizard - cross tab query

Creating and Working with Forms
The standard form
The split form
The multiple items form
Using the form wizard
Working in design view
Working with form properties
Form controls I
Form controls II
Calculated form controls
Formatting a form

Creating and Working with Reports
Creating a basic report
Report sections
Using the report wizard
Using the design view
Working in layout view
Publishing reports to Word

Working with External Data
Importing data from MS Excel

	Microsoft Office 2007 Training \| Excel Training \| Microsoft Access Training \| Excel VBA Training \| Access VBA Training
	Dreamweaver Training \| PowerPoint Training \| WindowsXP Training \| Course List