Access 2007/2010 Introduction

Course details

This course is aimed at new users of the MS Access database package who are interested in identifying its use and application. Delegates are shown how to set up database tables, how to build queries to select information based on criteria, how to create forms and use them to enter information into the database tables and reports to extract and display information from them. On the course you will be introduced to many of the topics required for the Microsoft Office Specialist (MOS) Core

Objectives

In this course, you will learn how to use Access 2010 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, sort data and generate reports. On completion of this course, all participants will be able to perform the following:

Content

• Getting Started
• Creating a Database and Working with Tables
• Querying Database
• Working With Forms
• Generating Reports

Prerequisites

It would be beneficial for delegates to be familiar with using a mouse, computer and Windows

Who should attend?

This course is designed to introduce students who wish to learn the basic operations of the Microsoft Access database program to perform their dayto-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.