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 wish all training courses were run this well!"

RPS Design

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

RAF Culdrose

"I am writing to say thank you for organising my FileMaker training day; I learned so much with my trainer, Nick, and have come away with such a great database. It delighted both the Director and my job share partner. I feel I have left with a great amount of knowledge that can help the business immensely. I learned more than I thought I would and would like to thank Transmedia for being so helpful!"

Lucie Mills



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team