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
"Very clear instruction and presentation."
Hay Group
"Amazing! Looking forward to the follow-up course!"
MOD
"Excellent. The best training I have ever had."
National Housing Federation
