Microsoft Access Training Course Overviews

Below is a list of the Microsoft Access training courses PTR offer, along with a brief overview of the course contents and subject areas covered to assist with locating the correct course. To view full course outlines simply click on the course title.

Microsoft Access 2010 Level 1

This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

Microsoft Access 2010 Level 2

This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.

Upon successful completion of this course, students will be able to:

streamline data entry and maintain data integrity.
join tables to retrieve data from unrelated tables.
create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
improve forms.
customize reports to organize the displayed information and produce specific print layouts.
share data between Access and other applications.

Microsoft Access 2010 Level 3

This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Upon successful completion of this course, students 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.

Microsoft Office Access 2007: New Features

In this course, you will be introduced to the new features available in Microsoft® Office Access 2007 for improving the management, presentation, and distribution of your databases.

Microsoft Office Access 2007 Level 1

In this course you will create and modify new databases and their various objects, examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access 2007 relational database application. This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

Upon successful completion of this course, students will be able to:

examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
design a simple database.
build a new database with related tables.
manage the data in a table.
query a database using different methods.
design forms.
generate reports.

Microsoft Office Access 2007 Level 2

In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications. You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access 2007 with other applications.This course is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 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. This course is also a prerequisite to taking more advanced courses in Access 2007.

Upon successful completion of this course, students will be able to:

modify the design and field properties of a table to streamline data entry and maintain data integrity.
retrieve data from tables using joins.
create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
enhance the capabilities of a form.
customize reports to organize the displayed information and produce specific print layouts.
share Access data across other applications.

Microsoft Office Access 2007 Level 3

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.

Microsoft Office Access 2007 Level 4

In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases. You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft Office Access 2007 application, and are interested in learning introductory level administrator skill sets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2007.

On completion of the course students will be able to:

share Access data with other applications.
use VBA to automate a business process.
create and modify a database switchboard, and set the startup options.
secure databases.
share a database using a SharePoint site.

Microsoft Access 2003 Level 1

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools.

Microsoft Access 2003 Level 2

As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

Microsoft Access 2003 Level 3

Your training in and use of Microsoft® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

Microsoft Access 2003 Level 4

In previous levels, you were introduced to advanced topics that dealt with local database management. In this course, you will learn remote database management, how to exchange data with XML and other type applications, and how to automate your business processes by using VBA code.

Access 2003: Level 4 is for students who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skillsets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2003.

Upon successful completion of this course, students will be able to:

Develop a data access page.
Develop a data access page, a PivotTable, and a PivotChart.
Import XML data and export Access data.
Use VBA to automate a business process.
Create and modify a database switchboard, and set and modify your startup options.
Distribute a database and add security features to it.

Access 2007 VBA Programming

This course provides delegates with an overview Access VBA. Rather than being a formal "learning to programme" course, this is a hands-on, task-based course which tackles some common problems and shows how they can be overcome with a little knowledge of VBA. It also serves as an excellent grounding in VBA concepts for delegates attending the 4 day "Access 2003 Programming" course.

Access 2003 Programming with VBA

Advanced Development in Microsoft Access

The Course shows you how to move from creating simple applications to creating enterprise-wide, robust applications for multiple users. You’ll learn how to debug and handle errors, how to use ADO to work with data programmatically, how to secure your data with Microsoft Access security, and how to scale up to an Access client/server solution.

PTR Associates Limited 21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035 Email: training@ptr.co.uk

PTR Associates Ltd is a company registered in England and Wales. Company number 2442290.
Registered Office: Grenville Court, Britwell Road, Burnham SL1 8DF. VAT Registration Number: GB 532 1929 56