Call us on 01732 870511
“Vue, Dedicated to
Developing Brighter Futures”
Developing Brighter Futures”
Thursday 20th November 2008
Microsoft Access Introduction
Description
Delegates should have basic keyboard and mouse skills and be familiar with working in the Windows environment. Use of another Microsoft Office application, preferably Excel, would be beneficial.
What will you learn?
- To understand basic database terms and concepts
- To store and work with data
- To ask questions of your data
- To create reports from your data
Course content
Introduction to Databases
- What is a Database?
- Terminology
- Moving from Excel
Getting Started with Access
- Running Access
- Creating a New Database
- The Database Window
- Access Objects
Creating Tables
- What is a Table?
- Creating Fields and setting Properties
- Importing a Table
Working with Data
- Viewing, Entering, Modifying and Deleting data
- Navigating around Data
- Sorting Data
- Searching and Filtering Data
Creating Queries
- What is a Query?
- Choosing Fields
- Entering Criteria
- Creating Calculations
- Finding Top Values
- Grouping and Totalling
- Running a Query
Creating Forms
- What is a Form?
- Using AutoForm
- Modifying the appearance of a Form
- Using a Form
Creating a Report
- What is a Report?
- Using a Report Wizard
- Modifying the appearance of a Report
- Previewing and Printing a Report
Dates for this course
- Monday 12th January 2009
- Monday 9th March 2009
- Monday 27th April 2009
