Back to Course List

Course Name:
Introduction to Access

Aim:
This is a practical hands on training session, which will introduce participants to Microsoft Access. Participants will build their own database and be taken through all the steps covering object design and data manipulation.

Content:
Course content includes

• Concepts of Databases - Viewing Data
- Creating and Designing a Database
• Tables - Creating a Table with a Wizard
- Choosing a Field Data Type
- Table Design View
- Datasheet View
- Setting a Field Property
- Setting or Changing a Primary Key
• Queries - Opening an Existing Query
- Creating a Select Query
- Adding Fields to a Query
- Remove Field from the Grid in a Query
- Editing a Query
- Sorting Records in a Query
- To Remove a Sort
- Entering Criteria in a Query
• Reports- Report - Layout
- Previewing a Report
- Creating a Report with a Wizard
• Forms - Opening an Existing Form
- Creating a Form with a Wizard
- Viewing Records, Form View and Datasheet view
- Form Design
- Control Appearance
- Create a Custom Form

Who will benefit:
People who have little or no experience of Microsoft Access and database design.

Duration: 2 day
Date: Times arranged to suit availability
Time: 9.30am to 4.30pm
Cost: £300.00

Back to Course List

HOME	© 2001 - 2008 Glasgow North Regeneration Agency. All Rights Reserved	TOP