0845 450 6120

Microsoft Access Intermediate (2007, 2010 & 2013)

The Intermediate course is for individuals whose job responsibilities include maintaining data integrity, handling complex queries, forms, and reports, and sharing data between Access and other applications.

Your training and experience using Microsoft Access will give you basic database management skills such as creating tables, designing forms and reports, and building queries.

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customise reports.

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

Reset

Learning Objectives

Delegates will learn how to:

  • Design a relational database
  • Join tables to retrieve data from unrelated tables
  • Streamline data entry and maintain data integrity
  • Share data across applications
  • Customise reports to organise and format the displayed information

Course Content

Advanced File Tasks
• Using Windows Explorer within Access  • Database Management  • Saving Your Files  • Exporting Files  • Linking Files 
Working with Tables
• Customising Tables  • Table Properties: Formatting  • More Table Properties  • Data Validation and Lookup Wizard 
Working with Forms
• Basic Form Controls  • Advanced Form Controls  • Formatting Your Form  • Formatting Controls  • Using Themes 
Working with Reports
• Organizing Report Data  • Formatting Reports  • Common Report Tasks 
Working with Queries
• Basic Queries  • Doing More with Queries  • Creating Advanced Queries  • Creating Management (Action) Queries 
One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include