Please download the latest flash player

CourseAccess (Part 1) Introductory to Intermediate

Course Details

Venue: Commerce House, Stoke on Trent
Duration: One Day (9.30am - 4.30pm)
Trainer: Eileen Venables
Cost: £185.00+VAT - Members £230.00+VAT- Non-Members

INTRODUCTION TO DATABASES

• The Access Database Window
• Terminology

ACCESS OBJECTS

• Tables
• Queries
• Forms
• Reports

CREATING A NEW DATABASE

• Designing a Database
• Preparing your data
• Creating a New Database
• Creating a New Table
• Table Design Window
• Entering Field Names
• Specifying Data Types
• Specifying Field Properties
• Importing Spreadsheet Data into an Access Table

FIELD FEATURES

• Adding a Lookup to a Table
• Using the Database Wizard

PRIMARY KEYS

• Changing the Primary Key
• Saving the design

USING DATASHEET VIEW

• Editing Data
• Moving Round the Datasheet
• Adding records
• Amending records
• Deleting records

FILTERING RECORDS

• Sorting Records
• Filtering Records
• Multi-level Sorting

CREATING FORMS

• Creating a Form
• Naming your Form
• Design View
• Adding/Deleting a Field
• Modifying the Form Design
• Entering records in Form View
• Changing form properties

QUERIES

• Creating and saving Simple Queries
• Parameter Queries
• Summary Queries

REPORTS

• Creating Simple Reports using Wizard
• Creating Grouped Reports using Wizard
• Simple Modifications to a Report

TABLE RELATIONSHIPS

• One to One
• One to Many
• Many to Many relationships

JOINING TABLES

• Enforcing Referential Integrity
• Cascade Update/delete
• Establishing a join between tables
• Deleting/modifying a join

Course Details

Course Date: 6 September 2012 Cost For Members: £185 + VAT Cost For Non-Members: £230 + VAT

Book a place at this course

To book a place at this course, input the number of delgates attending and press add to cart

x Delegates

Shopping Basket

Your Shopping Basket is empty

Event Calendar

<< June 2013 >>

S	M	T	W	T	F	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19• HR: Value Add to Manufacturing?	20	21	22
23	24	25• Make the Most of Your Membership	26	27• Negotiation Skills	28• finest Ten Year Celebration	29
30

Mouse over dates to view events

Events open to all members

Event Location Guide

Stafford (South) Area

Stoke (North) Area