RMD Business Access 2003 Foundation Syllabus
This course is designed for delegates who have little or no experience of
using Microsoft Access 2003.
If the course syllabus does not entirely match your requirements, please contact us
as we are able to customise it to your needs.
This course has a duration of 1 day.
Access Basics
Database Terminology
What Is A Table?
What Is A Record?
What Is A Form?
What Is A Report?
What Is A Query?
Meeting Access
Starting Access
The Microsoft Access Environment
Working With Toolbars
Working With The Task Pane
Creating A Database
Plan Your Database
Creating A New Database Using The Wizard
The Database Window
The Relationships Window
Understanding Join Lines
Creating Tables
About Referential Integrity
Viewing Tables And Entering Data
Viewing Table Properties
Creating Forms
Previewing A Forms Design
Previewing Reports
Viewing A Reports Design
Tables
Table Basics
Table Structure
Primary Key Field
Changing Field Properties
Creating A Table
Creating A Table Using The Wizard
Creating A Table Using Newobject:Table
Creating A Table In Design View
About Table And Field Names
Working With A Table
Editing A Table
Changing Table And Field Names
Deleting Fields
Finishing A Table
Saving A Table
Editing A Table In Design View
Changing A Table Structure
Entering Table Data
Importing Data From Excel
Forms
Creating A Form
Creating A Form Using Newobject
Creating A Form Using The Wizard
Creating A Form In Design View
Modifying A Form
Designate The Record Source
Place The Fields
Move And Place Controls
Delete Controls
Using Controls
Use The Toolbox
Format Controls
Changing Formatting Using The Format Painter
Using The Navigation Bar To Move Through Your Form
Viewing Your Work
Reports And Queries
Creating A Report
Create A Report Using Newobject:Report
Create A Report Using The Wizard
Create A Report In Design View
Grouping And Sorting
Using Report Controls
Bound Controls
Unbound Controls
Option Buttons
Toolbox
Control Properties
Finishing A Report
Report Sections
Add A Report Header Or Footer
Sort And Group
Previewing Your Report
Queries
Working With Queries
Manipulate Tables In The Query Window
Arrange The Query Design Window
About The Design Grid
Multi-Table Queries
About Calculated Fields
