Microsoft Access 2010: Set of 3 Interactive Courses

Producer: Gopas

Duration: 28 hours.
This product is an online product and is a single-user, 1-year licence.

Overview

In this bundle of all three of our Microsoft Access 2010 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 bundle contains:
• MS Access 2010: Introduction
• MS Access 2010: Intermediate
• MS Access 2010: Advanced
The courses in this bundle take the form of tutorials, exercises and quizzes.

Bundle Content
- 55 lessons
- 28 study hours

Please Note: The demo is designed to be representative of this course, and may not be the course itself.

This product allows the student to print a certificate from the course on successful completion.

The recommended settings to run this bundle are:
- Any of following internet browsers: Internet Explorer 6.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
- 1 GHz CPU; 512 MB RAM; OS Windows 2000, XP, Vista or Windows7
- Display resolution of 1280 x 1024
- Soundcard, speakers or headphones are recommended

Screenshots

Screenshot 1Screenshot 2Screenshot 3Screenshot 4Screenshot 5

Topics

First you will familiarise yourself with the basics of working with Access, by learning to design, use, and join tables. Then 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. You will also 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.

Objectives

Once you have completed the lessons in this bundle you will be able to:
• Create databases
• Store, interrogate and report on data contained within your database.
• Use queries, macros, pivot tables and other tools to work with data.

ASK US A QUESTION...
* required field

ASK US