Home - Microsoft Office Training Courses - Microsoft Access 2010 Complete
Our Complete Microsoft Access 2010 Training Course combines our Introduction to Microsoft Access 2010 course, our Intermediate Microsoft Access 2010 course, our Advanced Microsoft Access 2010 course and our Expert Microsoft Access 2010 course at a specially discounted price.
Our introduction to Microsoft Access 2010 training course is designed for individuals 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. Our introduction to Microsoft Access 2010 training 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.
Modules included on this course include how to identify the components of the Microsoft Access 2010 environment, how to identify the components of a database and organize data in tables, how to view data in tables, query a database, design forms and generate reports.
In our intermediate Microsoft Access 2010 training course you will learn how to improve and customize tables, queries, forms and reports, and share Access data with other applications. This course is ideal for those who wish to learn intermediate-level operations of the Microsoft Access program including creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces you to the principles of integrating Access data with other applications such as Microsoft Office Word or Excel.
Modules covered in this course include how 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 plus how to share data between Access and other applications.
In our advanced Microsoft Access 2010 training course you will learn how to create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance. 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.
Topics include how to restructure data into appropriate tables to ensure data dependency and minimize redundancy, how to write advanced queries to analyze and summarize data, create and revise Microsoft Access 2010 macros, customize reports by using various Microsoft Access 2010 features and how to maintain your databases using Microsoft Access 2010 tools.
In our expert Microsoft Access 2010 training course you will learn how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases. This course is for those who are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.
Topics covered in this course include how 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 and distribute databases and how to share databases using a SharePoint site.
Please note that the individual courses which comprise this course may be booked for separately - please see below for their individual course outlines.
Duration: 4 days.
Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]
Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.
Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.
Accommodation: Details of local accomodation can be found here.
Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.
COURSE CONTENT
Day #1 - An introduction to Microsoft Access 2010
- Getting Started with Access Databases
- Building the Structure of a Database
- Managing Data in a Table
- Querying a Database
- Designing Forms
- Generating Reports
Click here for more information regarding the Microsoft Access training course (2010 Introduction).
Day #2 - Intermediate Microsoft Access 2010
- Controlling Data Entry
- Joining Tables
- Creating Flexible Queries
- Improving Forms
- Customizing Reports
- Sharing Data Across Applications
Click here for more information regarding the Microsoft Access training course (2010 Intermediate).
Day #3 - Advanced Microsoft Access 2010
- Structuring Existing Data
- Writing Advanced Queries
- Simplifying Tasks with Macros
- Creating Effective Reports
- Maintaining an Access Database
Click here for more information regarding the Microsoft Access training course (2010 Advanced).
Day #4 - Expert Microsoft Access 2010
- Integrating Access into Your Business
- Automating a Business Process with VBA
- Managing Switchboards
- Distributing and Securing Databases
- Sharing Databases Using a SharePoint Site
Click here for more information regarding the Microsoft Access training course (2010 Expert).
5-15% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
