Introdution to Microsoft Access
Access
Training
Provided by Microcomputing Solutions ltd
Objectives: This course will introduce the facilities of this database program
Pre Requisites: An understanding of Microsoft Windows is recommended.
Duration: 1 day
The topics covered are as follows:
1 Navigating and Controlling Access
2 Database Creation
a Database Terminology Explained
a Designing a Table
a The Table Design Window
a Field Properties and Data Types
a Setting a Primary Key
a Saving the Table Design
3 Adding and Editing Data
a Working in a Datasheet
a Adding new Records
a Deleting existing Records
a How the program Saves Data
a The Undo feature explained
4 Working with Access
a Creating a New Database
a Opening a Database
a Switching between Objects
5 Altering the Table Design
a Rearranging Fields
a Inserting/ Deleting Fields
a Changing Field Length
a Changing Field Type
6 Working in a Datasheet
a Font and Cell Effects
a Column Width / Row Height
a Hiding / Freezing Columns
7 Simple Queries
a Designing a Query
a The Query Design Window
a Placing Fields in the Grid
a Selecting Records with Criteria
a Saving and Running the Query
8 More Query Features
a Calculating Data during a Query
a Sorting into Various Orders
a Creating a Totalling Query
9 Forms Design
a Creating Forms with a Wizard
a The Forms Design Window
a Moving Controls and Labels
a Formatting and Aligning Objects
a Saving and Using the Form
10 Report Design
a Creating Reports with a Wizard
a The Report Design Window
a Understanding Report Sections
a Moving Controls and Labels
a Formatting / Aligning Objects
a Saving and Running the Report
|
|
||||||||||
Introdution to Microsoft Access
Objectives: This course will introduce the facilities of this database program
Pre Requisites: An understanding of Microsoft Windows is recommended.
Duration: 1 day
The topics covered are as follows:
1 Navigating and Controlling Access
2 Database Creation
Database Terminology Explained
Designing a Table
The Table Design Window
Field Properties and Data Types
Setting a Primary Key
Saving the Table Design
3 Adding and Editing Data
Working in a Datasheet
Adding new Records
Deleting existing Records
How the program Saves Data
The Undo feature explained
4 Working with Access
Creating a New Database
Opening a Database
Switching between Objects
5 Altering the Table Design
Rearranging Fields
Inserting/ Deleting Fields
Changing Field Length
Changing Field Type
6 Working in a Datasheet
Font and Cell Effects
Column Width / Row Height
Hiding / Freezing Columns
7 Simple Queries
Designing a Query
The Query Design Window
Placing Fields in the Grid
Selecting Records with Criteria
Saving and Running the Query
8 More Query Features
Calculating Data during a Query
Sorting into Various Orders
Creating a Totalling Query
9 Forms Design
Creating Forms with a Wizard
The Forms Design Window
Moving Controls and Labels
Formatting and Aligning Objects
Saving and Using the Form
10 Report Design
Creating Reports with a Wizard
The Report Design Window
Understanding Report Sections
Moving Controls and Labels
Formatting / Aligning Objects
Saving and Running the Report
Pre Requisites: An understanding of Microsoft Windows is recommended.
Duration: 1 day
The topics covered are as follows:
1 Navigating and Controlling Access
2 Database Creation
Database Terminology Explained
Designing a Table
The Table Design Window
Field Properties and Data Types
Setting a Primary Key
Saving the Table Design
3 Adding and Editing Data
Working in a Datasheet
Adding new Records
Deleting existing Records
How the program Saves Data
The Undo feature explained
4 Working with Access
Creating a New Database
Opening a Database
Switching between Objects
5 Altering the Table Design
Rearranging Fields
Inserting/ Deleting Fields
Changing Field Length
Changing Field Type
6 Working in a Datasheet
Font and Cell Effects
Column Width / Row Height
Hiding / Freezing Columns
7 Simple Queries
Designing a Query
The Query Design Window
Placing Fields in the Grid
Selecting Records with Criteria
Saving and Running the Query
8 More Query Features
Calculating Data during a Query
Sorting into Various Orders
Creating a Totalling Query
9 Forms Design
Creating Forms with a Wizard
The Forms Design Window
Moving Controls and Labels
Formatting and Aligning Objects
Saving and Using the Form
10 Report Design
Creating Reports with a Wizard
The Report Design Window
Understanding Report Sections
Moving Controls and Labels
Formatting / Aligning Objects
Saving and Running the Report
About The Training Provider: Microcomputing Solutions ltd
Microcomputing Solutions ltd - microcomputing has been providing comprehensive IT solutions to businesses throughout the North East since 1981.
microcomputing provides a comprehensive IT solution for businesses including computer software training, technical support for SMEs and hardware and software solutions focusing on maximum efficiency, at a reduced cost for your business.
Our policy of providing a local personal...
