Introduction Access 2010
Course Duration
Duration – 1 Day. Course timings 0930-1630 (approximate)
Course Aims
You will learn the basic skills necessary to create databases, tables, queries, forms and reports using Access. Additionally, you wilt team elementary skills to modify forms and reports.
Pre-requisites
No prior knowledge of Access is assumed, but some exposure to databases would be helpful. You should be able to use basic Windows features, a mouse and keyboard.
Target Audience
This course is designed for new users who wish to learn the basic operations of Microsoft Access to perform their day-to-day responsibilities and to be able to create and amend basic Tables, Forms, Queries and Reports from data entered into the Database.
Content/Topics
The Microsoft Access 2010 Introduction course will cover the following topics enabling delegates at the end of the course to be able to:
———————————————————————————————————————————————————————-
2010 Environment
Exploring the Fluid User Interface
Exploring the Ribbon
The Quick Access Toolbar
Customise the QAT and Ribbon
Help
Database Concepts
Understanding Databases
Introduction to Relational Databases
Getting Started
Starting Access & Opening Files
The Access Application Window
The Table Datasheet and Design Views
Introducing Queries, Forms and Reports
Views and Navigating in a Table and Form
Close a database tile and Access
Database Design and Table Creation
Create a database using a Wizard
Create a blank database
Create a Table using the Table Wizard
Create a Table in Datasheet View
Create a Table in Design View
Adding Fields and Data Types to a new table
Setting a Primary Key
Introducing Field Properties and the Input Mask
Saving a Table
Database Entry & Editing Techniques
Enter Records in a Table
Selecting techniques
Editing and Deleting Records and Fields
Sort and Filter Records
Relationships
The Relationship Window
Adding Tables
Create a Relationship between tables
Referential .Integrity &.Join Types
Troubleshoot Relationships
Editing and deleting Relationships
Forms
Creating a Form Using Autoform
Enter records in a form
Modify Form
Queries
Opening Existing Queries
Creating Queries with the Simple Query Wizard
Creating Queries in Design View
Using criteria e.g. Text, Logical and Comparison Operators, and Multiple Criteria
Reports
Creating Reports with Auto Report
Creating Reports with the Report Wizard
Creating Labels with the Label Wizard
Basic formatting and customising reports
Printing Reports