Call us on 01732 897511
01732 897511
Thursday 9th September 2010
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
Please contact the team for dates of this course
