Microsoft Access 2010

Are you an office worker who needs to design, implement and maintain basic Access databases? Perhaps you are someone who's been using Excel to store all of your company lists? If this sounds like you, then this is the course for you. Microsoft has really outdone itself with all of the amazing new features to Access 2010, and this training course covers them all. If you are new to databases then Access 2010 training course is where you want to start. Jason Manibog will take you step-by-step through this course; starting with understanding what a Database is and how data relates to each other. Learn the process of planning and implementing a database effectively and then learn to use the tools provided in Access 2010 to design and maintain a basic database.

Session 1
Section A: Introduction
Section B: Access 2010 Tour
Section C: Working with Tables and Forms
Section D: Working with Queries and Reports
Section E: Database Organization Techniques
Section F: Customizing Access
Section G: Understanding Relational Databases
Section H: Planning a Database

Session 2
Section A: Building a Database
Section B: Building Tables
Section C: Table Design Basics
Section D: Adjusting Table Design
Section E: Data Validation and Input Masks
Section F: Lookups
Section G: Table Relationships
Section H: Importing Data

Session 3
Section A: Building Forms Automatically
Section B: Building Forms Manually
Section C: Customizing and Personalizing Forms
Section D: Working with Form Layout
Section E: Working with Form Design
Section F: Adding Controls to Forms
Section G: Filtering Data with Forms
Section H: Building Navigation Forms

Session 4
Section A: Building a Query with a Wizard
Section B: Building a Query from Scratch
Section C: Basic Criteria
Section D: Comparison Criteria
Section E: Performing Calculations
Section F: Working with Calculated Totals
Section G: Advanced Select Queries
Section H: Action Queries

Session 5
Section A: Reports
Section B: Report Formatting
Section C: Basic Report Design
Section D: Grouping Data on Reports
Section E: Controlling Page Layout
Section F: Building Specialized Reports
Section G: Introduction to Macros
Section H: Finalizing the Database

Assessments

The Microsoft Access 2010 course prepares you for the MOS Exam 77-885.

Please note that the course fee does not include any software or exam costs.

Study Time

Study Hours are an approximate figure and are dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

The approximate amount of time required to complete the Microsoft Access course is: 25 hrs

Further Info

• 25 hours training on 5 packed CDs
• Level - Beginner to Advanced and then onto Expert
• Tests and exercises included
• 77-885 MOS Exam coverage

Our Microsoft Access 2010 course is openly available to anyone wishing to learn more about Microsoft Access and has a keen interest in the subject, plus an intention to progress a career.

• Learners will need sufficient numeracy and literacy
• Students should have access to a computer and the Internet throughout your study period.
• Learners should have networking skills in order to progress throughout the course.
• You should be fully committed to your studies.

There are also some hardware & operating systems and software requirements, please enquire now for more information.