Introduction to Microsoft Access

Duration: 2 Days

Objectives

This course is designed for new users of Microsoft Access. By the end of the course, delegates will be able to: create tables, enter and change data; sort, and query data using criteria; create basic forms and reports; review and print data from queries, forms and reports.

Pre-requisites

Delegates need no prior Access experience but should be familiar with the Windows environment. It is also helpful for those attending to have a clear idea of the basic structure of the database system they plan to build after training.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Introduction to Databases

  • Relational database concepts and terminology
  • Creating a database
  • Displaying object properties

Creating a Table

  • Defining the table structure
  • Defining field types and properties; creating a primary key

Editing Table Data

  • Entering and editing records
  • Table navigation techniques
  • Customising table layout
  • Previewing and printing data; scaling the preview window

Querying Data

  • Creating ‘Select’, ‘Action’ and Parameter and Crosstab queries
  • Entering criteria
  • Creating calculated fields
  • Querying multiple tables

Forms

  • Creating forms using Form Wizards
  • Changing the design of forms
  • Creating list and combo boxes for data entry
  • Creating calculated fields

Reports

  • Creating reports using Report Wizards
  • Changing the design of reports
  • Sorting and grouping data

Restructuring a Table/Object Management

  • Inserting and deleting fields; renaming and re-arranging fields
  • Changing data types and field properties
  • Renaming, deleting, and copying objects

Opening, Converting and Saving Databases

  • Opening and Converting databases in previous versions
  • Saving databases in previous version

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

Related Courses


"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"

Julian Support

"Our trainer was very approachable and knowledgeable."

Bond Pearce

"An excellent presentation, very clearly explained and enjoyable at the same time. Has given me confidence in using this software."

RAF Culdrose



© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260