Introduction to Access

For

 Delegates who need to set up and use Access databases.

Aims & Objectives

 To provide delegates with the skills and knowledge required to set up a simple database with one table and manipulate the data within it.  Including simple form design, parameter prompts, creating queries and presenting data in reports.

Pre-requisites

 Basic  familiarity with keyboard, mouse use and Windows

Content

 Terms and Concepts
Creating a Table
Setting Properties including Validation Rule and Text
Assigning a Primary Key
Manipulating Data: Importing, Sorting, Finding, Editing, Deleting and Selecting Records by Single or Multiple
  Criteria 
Formatting the Datasheet
Creating Forms: Objects, Controls and Labels, Form
  Width, Changing Number Display, Object Linking &       Embedding, Screen Tips & other Formatting Features
Creating Queries: Parameter Prompts & Filters
Command Buttons – their Use and Setup
Creating Reports: Running, Editing and Printing

Duration

 1 day                     back