Microsoft Access Introduction
Microsoft Access Introduction Training Courses
1 Day Access Introduction Course | 1 delegate £195 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information
Scheduled public courses are held at Preston, Liverpool, Manchester & London.
Closed tailored courses are available on your site for £595.00 plus vat (up to 8 attendees).
Introduction
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
- Exploring the Access window
- Understanding database terminology
- Viewing an existing database
- Understanding Access objects: Tables / Queries / Forms / Reports
- Looking at relationships within a database
- Understanding the function of the Primary Key
- Keyboard Shortcuts and Menu Items
Database Tables
- Understanding the difference between
fields and records - Entering and editing data
- Moving and copying data
- Sorting and filtering data
- Finding and replacing data
- Looking at data types
- Designing a new table
- Printing data from a table
Query use and design
- Understanding the role of the query
- Modifying a query
- Creating a new query
Form Creation
- Creating a new form
- Editing data within a form
- Modifying the design of a form
Report Design
- Creating a new report
- Modifying the design of a report