Access Intermediate

This course is run in conjunction with pass training, a Microsoft Certified Partner and Microsoft Office User Specialist (MOUS) Authorised Testing Centre. Pass training is a Numerica Group Plc Company.

Course Objectives

To give users additional skills and knowledge on using the many features and functions of Access to make them more efficient and effective when processing data. Delegates will gain experience in producing database applications and the ability to create a variety of data views, queries and reports.

Delegates:
Maximum 8

This course is suitable for existing users of Access who want to get to grips with some of the more advanced features of this package as quickly as possible. Familiarity with the basic features of Access is required, gained either by previous experience or by attendance on an "Access Introduction" course.

Delegate numbers are restricted to 8, to ensure personal attention from the trainer.
Structure:
PC for every delegate 		All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Access' tools.

Course details

Subject to change without notice.

Database Design
  • The Theory of Normal Forms
  • De-Normalisation
  • Naming Conventions
Designing Tables
  • General Table Design
  • Field Properties
  • Using Field Properties for Protection
  • Using Field Properties to Improve Performance
  • Table Relationships
  • Relationship Types
  • Using Lookups for Referential Integrity
Data Import/Export
  • Importing Data from Another Data Source
  • To Import an Object from Another Access Database
  • Linking To an External Data Source
Queries
  • Simple Query Syntax
  • Viewing The SQL Syntax of a Query
  • Joins; Calculated Fields
  • Adding a Calculated Field to a Query
  • Calculating Summary Information
  • Crosstab Queries
  • General Query Properties
  • Checking Referential Integrity
Forms
  • What Is a Form?
  • Using Form Wizards as the Basis for Form Design
  • Form Sections
  • Form Controls
  • Form Control Layout
  • Using Form Controls
  • Control Properties
  • An Introduction to Multiple Table Forms
Reports
  • Using Report Wizards as the Basis for Reports
  • Report Sections
  • Report Controls
  • Report Control Layout
  • Using Specific Controls
  • Links with Other Office Applications
Databases, Intranets and the Internet
  • Hyperlinks
  • Publishing Datasheet Views On The Internet
  • Publishing On The Internet - Data Access Pages
I want more information:
Phone Me

Duration:

1 day, 9.30am - 4.30pm

Booking

Title First name Last Name
Organisation
Address
Postcode
e-mail address
Phone number
fax number

Course dates 2004                                                                               

 The above course costs £210.00 + VAT


Top of page | Home | Courses | Students

Contact details:

Roger Woolley FCIS
Woolley & Associates
PO Box 992
Blackheath,
London, SE3 9DQ

Fax: 020 8852 8255
Phone: 020 8852 8260

e-mail info@rogerwoolley.co.uk