Back to Search Results

Training Course Summary:

This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports. Access, like other relational database management systems, is not easy to learn all on your own. There are concepts and theories about relational databases that are essential to working with these data repositories. Even if you will only be using a database created by someone else, understanding how a database is designed and structured will make your work easier and help you troubleshoot any data problems you might encounter. Almost all users of Access need to create queries, forms, or reports, and this course will get you started.

Pre-Requisites:

Windows 2000: Introduction

Training Course Overview/Content:

At course completion, delegates will be able to:

Define the purpose of and terminology associated with a relational database and Access objects.
Follow the steps required to properly design a database.
Create tables to hold data and then establish table relationships.
Modify the design of and work with data in tables.
Create, modify the design of, and work with select queries.
Create and modify forms to work with your data.
Create and modify reports to select, organize, and print data.