Microsoft Access Introduction
Contact us for dates, pricing and how we can customise courses to your requirements: contact us
Microsoft Access Introduction
Duration: 1 days
Pre-requisites
Microsoft Windows knowledge.
Microsoft Windows knowledge.
Overview
This course is for users who have limited or no database knowledge.
The Basics
- Database concepts and terminology
- Definition of a Database
- Definition of a Table
- Defining a Relational Database
Creating Databases
- Creating a database
- Using the table wizard
- Working in design view
Forms
- Creating forms by using AutoForm
- Using the form wizard
- Using design view
- Finding, sorting and filtering records
Fields and Records
- Changing the design of a table
- Adding and deleting records
- Finding and editing records
- Sorting and filtering records Querying Tables
- Creating and using queries
- Modifying query results and queries
- Using calculations in queries
Importing, Exporting and Linking Objects
- Importing Access objects
- Exporting Access objects
- Linking Access objects
Reports
- Using the report wizard and queries
- Creating, modifying and printing reports