Here are 2
great Access 2007 Training Sessions with Tutorials and Workshop Manuals,
from the Hillsborough Community College. This freely
available Access training gives you step-by-step instructions
and are illustrated with screen shots to show and guide you through the
many features and topics of Access. The first two links make up the
Access 1 training session as an animated Access tutorial and a workbook
manual in pdf format. The second two comprise the Access 2 training and
are in the same formats.
Access Animated Tutorial 1
Contents:
- Unit 1: Database structure and terminology
- Unit 2: Create a new database and a table
- Unit 3: Enter data
- Unit 4: Data types
- Unit 5: Insert and delete fields
- Unit 6: Forms and Split Forms
Access Workshop Manual 1 (28 pages, 1.6mb, pdf)
Contents:
- Objectives
- Database Structure
- Database Terminology
- Relationships
One-to-many
Many-to-many
One-to-one
- Create a New Database
- Access 2007 Tour and Features
- Create a Table in Datasheet View
- Edit a Table in Design View
- Save a Table
- Enter Data
- Data Types
- Use Input Mask Wizard
- Data Type: Yes/No
- Data Type: Lookup Wizard
- Insert and Delete Fields
- Set a Primary Key
- Form Wizard
- Split Form
Access Training 1 Tutorial and Manual Objectives:
At the end of Access 1 training, you should be able to:
- Create a new database;
- Create tables for data entry in datasheet view and design view;
- Enter data into a table;
- Use, understand, and set data types: text, memo, number, currency, date/time, autonumber, yes/no, lookup wizard;
- Insert and delete a row and a field;
- Create and delete a primary key;
- Create a form using the Wizard tool;
- Create a split form.
Access Animated Tutorial 2
Contents:
- Unit 1: Import and Export Data
- Unit 2: Create a Query
- Unit 3: Modify a Query
- Unit 4: Text Data Criteria and Wildcards in a Query
- Unit 5: Number Criteria and Comparisons
- Unit 6: Aggregate Functions in a Query
- Unit 7: Create a Report
Access Workshop Manual 2 (pages, 2.1mb, pdf)
Contents:
- Objectives
- Import a Table from Excel
- Export an Access Table to Excel
- Create a Query
- Query
Sort
Show
Text Data Criteria
Wildcards
Field Not in Result
Number
Comparison
Comparison And
Comparison Or
- Aggregate Functions
Count
Avg (Average)
- Parameters and the Between Operator
- Report Wizard
- Modify a Report
- Insert Images into a Form or Report
- Resize Images in a Form or Report
Access Training 2 Tutorial and Manual Objectives:
At the end of Access 2 training, you should be able to:
- Import a table from Excel;
- Export an Access table to Excel;
- Create a query;
- Sort fields in a query;
- Show fields in a query;
- Run a query using wildcards;
- Run a query for fields not in result;
- Run a query for a number value;
- Run a query using the comparison criteria “And”;
- Run a query using the comparison criteria “Or”;
- Understand the purpose of Aggregate Functions;
- Create and run a query using count;
- Create and run a query using average;
- Create and run a query using the parameter between;
- Insert and resize a graphic/image;
- Create and Modify a Report.
Related Posts
Tags for this post>> Access | Access 2007