Introduction to Microsoft Access
Instructor-led Access 2010 Introduction Outline
Duration: |
Intended audience: |
1 day |
Anyone who has outgrown Excel or needs to start using Microsoft Access as part of their job |
Aims: |
To familiarise delegates with the Access interface and demonstrate using the software by worked examples |
Objectives: |
By the end of the session delegates will:
|
Prerequisites: |
The ability to use the keyboard and mouse in a Windows environment |
Microsoft Access has been designed for user friendliness, with a familiar interface that people recognise and easy navigation. It is not for everyone, however, and despite its ease of use some people would feel intimidated by the appearance of datasheet view. It is for this reason that our courses focus on making delegates aware of all the database objects Access has available, including Forms for user input and Reports for output. This is the first step in turning a database into a database application in which it is easy to store and retrieve information. The subject of referential integrity is not covered in this course as we deal with a single table.
Exploring the Access 2010 environment
Access Basics
Planning and designing databases
Creating Databases
Closing a database and Access
Using Microsoft Access Templates
Getting help
Working in design view
Using design view
Importing, Exporting and Linking
Importing Access objects
Exporting Access objects
Linking Access objects
Creating and Using Forms
Creating forms by using AutoForm
Using the form wizard
Exploring reports
Creating and Using Reports
Using the report wizard and queries
Creating, modifying and printing reports
Exploring tables
Using the table wizard
Changing the design of a table
Adding and deleting records
Sorting and filtering records
Finding and editing records
Database concepts and terminology
Working with Fields and Records
Querying Tables
Examining queries
Creating and using queries
Modifying query results and queries
Using calculations in queries
Microsoft Access Introduction Courses
We have versions for Microsoft Office 2007, Microsoft Office 2010 and Microsoft Office 2013