Microsoft Access 2010: Introduction

Producer: Gopas

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

Overview

In this course, you will become familiar with the basics of using the Microsoft Access program. You will learn how to use and design tables and create various types of queries over them for purpose of effective information retrieval.
The course takes the form of tutorials, exercises and quizes

Course Content
- Pre-assessment (optional)
- 19 lessons
- Final test

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 course 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 3

Topics

This course covers the following topics

• Introduction to databases
• The Microsoft Access environment
• Table creation in datasheet view
• Table design view
• Special field types
• Work within extensive tables
• Looking up and editing data
• Data sorting and filtering
• Designing databases
• Field selection and data sorting via queries
• Work with criteria for select queries
• Calculated items
• Analysis of table relations
• Relationships and referential integrity
• Linked tables in queries
• Relation features
• Lookup column
• Queries with parameters
• Functions and formula creator

Objectives

Once you have completed this course you will be able to:

• Design and create tables
• Work with tables to sort, filter and edit data
• Create queries to allow information retrieval

ASK US A QUESTION...
* required field

ASK US