Access 2007 microsoft Access trainingAdvanced

Duration: 8 hours Course level:

About the course

Access 2007 is a database management program that makes it easy to store and find information, analyse data and create accurate reports. This course takes you step by step through advanced database tasks using Access 2007. Together with our Access 2007
Introductory-level course, this also supports the background learning for the Microsoft Certified
Specialist Exam (MCAS) 77-605.

You’ll learn how to:

identify, set and modify data types
understand field properties and create input masks
use data validation rules, create field lookups and set default data values create and manage table relationships
create simple and advanced queries work with forms and subforms
create and format reports
import and export data and use external data sources


There are 15 modules in this course:

Data Types Field Properties Table Relationships Queries

Action Queries
Advanced Query Options
Adding Controls Creating Subforms Expressions and Tab Order
Creating Reports in Design View Report Wizard and Page Breaks Using Calculated Controls Creating Macros
Importing and Exporting
Linking to External Data Sources

How this course can help your business:

Make the most of your investment in IT
Use databases to store, manage, sort and analyse information Make sound business decisions based on accurate information Store customer records securely
Improve communication by providing staff with better access to information
Capitalise on and manage the knowledge, experience and information contained within your business

Course code: 104461BT014

If you like this course, you might like:

Access 2007 Introduction, Excel 2007 Introduction, Excel 2007 Intermediate, Excel 2007 Advanced

learndirect Ltd September 2012. All information correct at time of going to press.