Duration

2 days

Aim

The skills and knowledge acquired in Microsoft Access 2010 Level One,Two & Three are sufficient to be able to use and operate the software at a very efficient level. Starting with the design of a database through to the execution of a fully functioning database. Exploring, designing and creating Tables, Queries, Forms, Reports, Macros and Modules.

Target Audience

Microsoft Access 2010 Level One ,Two & Three is designed for users who have no experience or have had no formal training within Microsoft Access 2010 class.

Prerequisites

Microsoft Access 2010 Level One, Two & Three assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Course Content

o Access 2010 Orientation o Designing A Lookup Database o Creating A Lookup Database o Modifying Table Structures o Adding Records To A Table o Adding Transactional Records o Working With Records o Sorting And Filtering o Creating Queries o Creating And Using Reports o Creating And Using Forms o Data Validation o Formatting Tables o Querying Techniques o Parameter Queries o Calculations In Queries o Modifying Forms o Creating And Using Macros o Macro Techniques o Macros On Forms o Relational Database Design o Creating A Relational Database o Setting Table Relationships o Multi-Table Queries o Aggregation Queries o Action Queries o Macro Techniques o An Introduction To VBA  Concluding

Course Objectives

At the completion of Microsoft Access 2010 you should be able to:

 understand how Access is used and how to navigate around it  design a database with lookup tables  create a database structure using Access 2010  modify the structure of an existing table  add records to a new table  add transactional records to a lookup database  work with the records in a database table  sort and filter records in a table  create simple and effective queries  create meaningful reports from tables  create and use a variety of forms  use various data validation features in Access to protect data  format the data in a table  perform more advanced queries using a variety of querying techniques  create and use parameter queries  create calculated queries  modify and adapt an existing form according to specific needs  create and use macros in Access  design a relational database project  create a relational database file with multiple tables  set table relationships and join tables together  create queries based on one or more tables  create and work with aggregation queries  create and use a series of action queries  work with a number of macro techniques  create some simple programming code using VBAAudience

Course Outline