PTR - People, Training ResultsPeople, Training, Results

Independent Technical IT Computer Training Courses

   

Microsoft Access Course Index & Training Schedule


More Microsoft Access Courses

Microsoft Access 2010 Level 1 CourseMicrosoft Office Access 2007: New Features CourseMicrosoft Access 2010 Level 2 CourseMicrosoft Office Access 2007 Level 1 CourseMicrosoft Access 2010 Level 3 CourseMicrosoft Office Access 2007 Level 2 CourseMicrosoft Office Access 2007 Level 3 CourseMicrosoft Office Access 2007 Level 4 CourseMicrosoft Access 2003 Level 1 CourseMicrosoft Access 2003 Level 2 CourseMicrosoft Access 2003 Level 3 CourseMicrosoft Access 2003 Level 4 Course


Late Availability Courses:

Training Course Subjects:

Applications Training Courses C Programming Courses C# Programming Courses Cisco Courses Citrix Courses CIW Courses CompTia Courses Database Courses Exchange Server Courses Fortran Courses Internet Courses ITIL Service Management Courses Java Courses Linux Courses Microsoft Courses Microsoft .NET Courses Microsoft Access Courses Microsoft Excel Courses Microsoft Outlook Courses Microsoft Powerpoint & Visio Courses Microsoft Project Courses Microsoft Server Products Courses Microsoft Word Courses Networking Courses Oracle Courses Perl Courses Programming Courses Security Courses SQL Courses SQL Server 2005 Courses SQL Server 2008 Courses Unix Courses VBA Courses Visual Basic Courses Visual Basic 2008 Courses Visual Studio Courses Visual Studio 2008 Courses Visual Studio 2010 Courses VMWare Courses Web Design Courses Windows Server 2003 Courses Windows Server 2008 Courses Windows 7 Courses Windows Vista Courses Windows XP Courses XML Courses

Online e-Learning Courses

Scheduled Classroom based Training Courses

Microsoft Office Access 2007 Level 3 Course

Course Description

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.

This course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2007, and it is a prerequisite to take more advanced courses in Microsoft Office Access 2007.

On completion of the course students will be able to:
  • restructure the data into appropriate tables to ensure data dependency and minimize redundancy.
  • write advanced queries to analyze and summarize data.
  • create and revise Access macros.
  • display data more effectively in a form.
  • customize reports by using various Access features, thus making them more effective.
  • maintain your database using tools provided by Access.
£235

1 day course

Scheduled Dates:
18 January 2012
15 February 2012
14 March 2012
11 April 2012
09 May 2012
06 June 2012

Location:
PTR's Training Centre
Wokingham, Berkshire.

Course pre-requisites:

Students should have attended or have equivalent knowledge of the following courses:
  • Microsoft Office Access 2007 Level 1
  • Microsoft Office Access 2007 Level 2
This course is rated as an Advanced Course, suitable for accomplished computer users.


Topics covered on the 1 day Microsoft Office Access 2007 Level 3 course

Structuring Existing Data

  • Analyze Tables
  • Create a Junction Table
  • Improve Table Structure

Writing 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

Simplifying 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

Making Effective Use of Forms

  • Display a Calendar on a Form
  • Organize Information with Tab Pages
  • Display a Summary of Data in a Form

Making Reports More Effective

  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Create a Report Snapshot

Maintaining an Access Database

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Appendix A: Microsoft Office Specialist Program


Course Classification:  Applications Training Course

This is an instructor led training course taught in a classroom based environment.

Course Fee = £235   (excl.VAT)



Scheduled course dates

18 January 2012 to 18 January 2012

15 February 2012 to 15 February 2012

14 March 2012 to 14 March 2012

11 April 2012 to 11 April 2012

09 May 2012 to 09 May 2012

06 June 2012 to 06 June 2012



View full schedule of Microsoft Access courses

View full schedule of Microsoft Access 2007 courses

Print / Download PDF Version of full course schedule

If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Microsoft Access Training and bespoke Microsoft Access courses

Overview of Microsoft Access