Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This one day course teaches participants the skills necessary to create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.


 
Course Outline
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Overview

This one day course teaches participants the skills necessary to create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Objectives

Upon successful completion attendees will be able to:
  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • Write advanced queries to analyze and summarize data.
  • Create and revise Microsoft® Office Access® 2010 macros.
  • Customize reports by using various Microsoft® Office Access® 2010 features.
  • Maintain their databases using Microsoft® Office Access® 2010 tools.
Topics to cover
  • Structure Existing Data: Restructure the Data in a Table, Create a Junction Table, Improve the Table Structure, Write Advanced Queries
  • Create SubQueries: Create Unmatched and Duplicate Queries, Group and Summarize Records Using Criteria, Summarize Data Using a Crosstab Query, Create a PivotTable and a PivotChart
  • Simplify Tasks with Macros: Create a Macro, Attach a Macro, Restrict Records Using a Condition, Validate Data Using a Macro, Automate Data Entry Using a Macro
  • Create Effective Reports: Include a Chart in a Report, Print Data in Columns, Cancel Printing of a Blank Report, Publish Reports as PDF
  • Maintain an Access Database: Link Tables to External Data Sources, Manage a Database, Determine Object Dependency, Document a Database, Analyze the Performance of a Database

Prerequisites & Certificates
Pre-Requisites

Microsoft Access 2010 Intermediate * To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended.

Certificates offered

Certificate of Completion * Participants receive reference materials related to course topics. Follow up support by email or phone, on topics covered, is available to participants for 90 days (4 hour limit).


Cancellation Policy
For training cancelled within 14 business days prior to the course date: 25% of the total training fee.

For training cancelled within 7 business days prior to the course date: 50% of the total training fee.

For training cancelled less than 5 business days prior to the course date: 100% of the total training fee.

Note: Failure to attend a course without notification of cancellation will result in a 100% charge of the total course fee.
Map & Reviews
Front Runner Training
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
Gordon is an excellent and knowledgeable instructor.
Reviewed by 2012
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 240 times.