Access 2007 Introduction
Who is this training course suitable for?
Our Microsoft Access 2007 Introduction course is suitable for complete beginners to Microsoft Access.Prerequisites
A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Access is required.
Benefits
At the end of this course you will have a good working knowledge of Microsoft access 2007 training basics. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports.
After completing this course you will be prepared to attend the Access 2007 Intermediate training course.
Course Syllabus
What's new in Access 2007Database Concepts
Database concepts and terminology
Exploring the Access environment
Planning and designing databases
Getting help
Closing a database and Access
Access Basics
Exploring tables
Examining queries
Exploring reports
Creating Databases
Creating a database
Using the table wizard
Working in design view
Working with Fields and Records
Changing the design of a table
Adding and deleting records
Finding and editing records
Sorting and filtering records Querying Tables
Creating and using queries
Modifying query results and queries
Using calculations in queries
Creating and Using Forms
Creating forms by using AutoForm
Using the form wizard
Using design view
Finding, sorting and filtering records
Creating and Using Reports
Using the report wizard and queries
Creating, modifying and printing reports
Importing, Exporting and Linking Objects
Importing Access objects
Exporting Access objects
Linking Access objects