| training courses |
Microsoft Office Access Training & Access Tutorials Online 2007
This Microsoft Access 2007 training course is designed to teach users how to use Microsoft Access 2007. It contains a series of online video-based tutorial lessons which are carefully designed to allow users to learn MS Access database quickly. The course not only covers the basics such as creating database tables, forms, queries, it also covers advanced features, including advanced queries, expressions, macros etc...
Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
Register and Start Learning Today
Click the links below to see the video tutorials
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
