Microsoft Access - Introduction

1 Day

Introduction

Designed for anyone wishing to use Access for the first time or those who have never received formal training

Pre-requisites
Participants should have attended the Introductory sessions for Microsoft Word and Excel before completing this course

Benefits
Time efficient manipulation and creation of data to support simple business decisions

Programme Objectives

Participants will be able to build a simple database, including Tables, Forms Querying and Reports.  Delegates will also be able to interrogate a simple database and be able to produce labels.
 

Programme Content

• Introduction to Database Concepts and Terminology
• Starting Access
• Access Databases
• Creating  New Databases
• Creating an Object
• Creating a Table
• Changing Tables
• Entering Data in Datasheet View
• Copy, Move, Delete
• Changing the Datasheet’s Layout
• Designing Forms
• Types of Form
• Changing Forms using the Forms Design Work Surface
• Editing the Tab order
• Calculations within Forms
• Creating Forms from Scratch
• Multiple Screen Forms
• Filter/Sort Records
• Queries & Dynasets
• Sorting Data
• Calculations in Queries
• Grouping and Summarising Data
• Producing Cross Tabulated Results
• Customising Queries with Parameters
• Using Filters
• Queries to Link Data from Different Tables
• Queries with Calculated Fields
• Queries to Summarise Data
• Queries with Parameters
• Action Queries
• Action (Update) Query
• Action (Make table) Query
• Action (Delete) Queries
• Action (Append) Query
• Printed reports
• Using the Report Wizard
• Report Design Mode
• Calculated and Statistical Fields
• Including Graphs in Reports
• Organizing Reports
• Label Generation