MS Access - Introduction
1 Day Training Course | £195 plus VAT |
This one-day instructor led course is designed to give an introduction to the different aspects of Access including basic design principles and effective use of an existing database. By the end of the course delegates will be able to enter and edit data, extract data, and to design a new Access database table.
Course Objectives
- Understand database terminology
- Enter, edit and format data
- Create a new database table
- Design a new query to extract specified data
- Create and edit a database form for data entry and manipulation
- Create and edit simple reports to print out data
Pre-requisites
We recommend that all those who attend are able to:
- Use the mouse to select and open menus and icons
- Identify and use the Shift, Ctrl, TAB and Home keys on the keyboard
Course Content
|
Access Basics
|
Query use and design
|
|
- Exploring the Access window
|
- Understanding the role of the query
|
|
- Understanding database terminology
|
- Modifying a query
|
|
- Viewing an existing database
|
- Creating a new query
|
|
- Understanding Access objects:
Tables / Queries / Forms / Reports |
|
|
- Looking at relationships within a database
|
Form Creation
|
|
- Understanding the function of the Primary Key
|
- Creating a new form
|
|
- Keyboard Shortcuts and Menu Items
|
- Editing data within a form
|
|
|
- Modifying the design of a form
|
|
Database Tables
|
|
|
- Understanding the difference between
fields and records |
Report Design
|
|
- Entering and editing data
|
- Creating a new report
|
|
- Moving and copying data
|
- Modifying the design of a report
|
|
- Sorting and filtering data
|
|
|
- Finding and replacing data
|
|
|
- Looking at data types
|
|
|
- Designing a new table
|
|
|
- Printing data from a table
|
|