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
"Our needs and expectations were surpassed."
FSL Aerospace
"Extremely good. Very knowledgeable, helpful and approachable."
Hachette
"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
