Microsoft Access Training - Access 2007
Over 8 hours of high quality video training tutorials that enable you to learn MS Access 2007 step by step. The training a practical approach and focuses on real life examples. The tutorials are carefully designed and structured to increase not only your skills but also help you learn MS Access quickly.
Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
Register Now and Activate This MS Access Training Course Instantly
Microsoft Access Training Course Online - Access 2007
Free sample tutorial: Database objects
Course Introduction
Chapter 1 - The Basics of Microsoft Access
What is a database?
Understand database objects
Converting older databases to Access 2007
Chapter 2 - MS Access 2007 Interface
The Getting Started screen
Creating a new database using a template
The Navigation Pane
The Ribbon - Home Tab I
The Ribbon - Home Tab II
The Ribbon - Create Tab
The Ribbon - External Data Tab
The Ribbon - Database Tools Tab
The Office Button
Chapter 3 - Customising Access Interface
The Quick Access Toolbar
Customising the Quick Access Toolbar
Access options
The Message Bar
Creating Trusted Locations
Customising the Object Window
Chapter 4 - Using the Navigation Pane
Object categories
View methods
Search for database objects
Expand and collapse object groups
Create custom groups
Add objects to custom groups
Hide object groups
Chapter 5 - Access Database Tables
Introduction to Access tables
Creating a table by entering data
Creating a table using templates
Planning to build your tables
Creating a table in design view
Choosing data types
Field validation rules
Understanding primary keys
Indexing an Access table
Chapter 6 - Table Relationships
Viewing table relationships
Creating relationships between tables
Chapter 7 - Database Queries
Creating a select query
Calculated fields in queries
Sorting query data
Using criteria in queries
Selecting data from multiple tables
Calculate totals in queries
Chapter 8 - Advanced Database Queries
Using SQL view
Crosstab queries
Delete queries
Update queries
Using the Query Wizard
Chapter 9 - MS Access Forms
Introduction to Access forms
The form interface
Creating a form using the form wizard
Creating from a blank form
Designing a form in layout view
Working with a form in design view
Chapter 10 - Advanced MS Access Forms
Form properties
Form controls
Applying themes using AutoFormats
Working with Subforms
Chapter 11 - MS Access Reports
Introduction to Access reports
Using the report wizard
Various report views
Creating a report from scratch
Conditional formatting for a report
Grouping & sorting a report
Applying AutoFormats to reports
Applying alternating colours to report rows
Chapter 12 - Advanced MS Access Reports
Report properties
Enhancing a report
Working with sub-reports
Report filtering
Creating mail labels with report
Chapter 13 - Using Macros in Microsoft Access
Introduction to Access macros
Assign a macro action
Add macro arguments
Run an AutoExec macro
Embed macros into a database object
