In this courses you will find all the information that you need to learn to perfectly master the Microsoft Access application – from basic orientation to the environment of the application to the formulation of queries and the creation of complex forms and output reports.
The course will make you familiarise with the basics of working with Access, by learning to design, use, and join tables.
Once done with the basics, you will learn more advanced techniques for designing tables and queries and try out creating a composite index and a dynamic validation rule that will compare the values of two different fields within a table.
Access will also enable you to try out creating totals, crosstab, make-table and action queries. You will acquaint yourself with the creation of forms and reports. You will also learn to create pivot tables, charts and macros. You will secure, compress and backup a database and, finally, you will take a look at the SQL commands that correspond to the different types of query.
Course Study Format
This course is delivered through ONLINE method.
The course is available for you to complete at your convenience over a 12 month period.
IT Training Courseware Support
The entire home study courses include step by step online training and keyword search facilities.
Using show and ask training methods you can access the desired eLearning courseware step by step.
Our technical support team is available for 24 hours a day from Monday to Friday, to help you out regarding any queries related to your online course
All exam vouchers supplied with our courses must be used within the duration of your course. Exam Vouchers become invalid once the course has expired.
MS Access 2007: Introduction
This course will help you to understand the basics of using MS Access. You will learn to design and use tables and to create various types of queries over them for effective information retrieval.
List of Lessons:
Introduction to databases
Becoming familiar with Access
Creation of a table in the datasheet view
Table design view
Special field types
Working with a table
Looking up and editing records
Filtering and sorting records
Fields selection and records sorting with a query
Working with criteria for the select query
Creating calculated items
Linked tables in queries
Analysis of relationships between tables
Relationships and referential integrity
Queries with parameters
MS Access 2007: Intermediate
In this course you will learn advanced methods for designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.
List of Lessons:
Joins and their properties
Functions and Expression Builder
Field indexing and data validation
Creating a form by using the wizard
Working with forms
Creating a form in design view
Working with form controls
Calculated items in the form
A combo box in the form
Buttons in the form
Organizing fields in the form
Creating a form with a subform by using wizard
Inserting subforms in the design view
A form as a user interface
MS Access 2007: Advanced
This course focuses on the creation of reports, data access pages and macros. You will also learn about the options for database management, for data import and export and also about SQL language.
List of Lessons:
Dependent objects and property inheritance
Reports with calculations
Graphic adjustments in reports
Pivot table and chart
How to work with macros
Matching macros and buttons
Verifying data by means of macros
Evaluating data by means of macros
Print and database documenter
Importing objects and splitting the database
Automatic import and export
Navigation in databases
Database security and administration
Become fully trained and substantially improve your chances of employment or earn more money!
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn.
Course Completion Certificate
*Please note, unless stated otherwise or included in package, our online courses only offer course completion certificates ( £10 fee) and in all cases official testing (at a charge made by testing centre) is required to gain officially certified recognised qualifications.
Unless otherwise specified, official exams are not included.