Microsoft Access User (aimed at users of existing
databases)
Course Duration: 1 Day
 Printer-friendly
version
Course Objective
By the end of the course, delegates will be able to:
- Make use of the
wizards to design objects in the database easily and quickly
- Create
tables and add data validation
- Create single table queries
- Import and
export data from other sources
- Create forms for ease of data entry
- Customise forms easily
- Create meaningful reports, including total
reports and mailing labels
- Create a menu form with push buttons
Delegate Profile
This course has been designed for those who want a basic
introduction to Access before using it to enter or
view an Access database
designed by someone else.
Pre-Requisites
Attendees should have experience of using the mouse,
and a working knowledge of the Windows operating
system including folder
structures. Experience
of using a Windows word processor, and/or a Windows
spreadsheet application is also required.
Structure
Each delegate has the exclusive use of a PC and
training includes extensive hands-on activity.
Course Content
Overview of Objects in
Access
The Access environment, including shortcut menus
How to create Access objects, i.e. tables, queries, forms and reports
quickly and easily , with the aid of Access wizards
How to switch between design view and data views to check the design
of each object
Entering data and navigating between records
Retrieving record and field selections and reporting
Tables
Creating a table from scratch
Importing data from other sources
Using default values and validation rules
Creating and changing Primary key fields
Forms
Toolbar, toolbox, palette, and properties
Creating a form, and adding fields
Selecting, copying, moving and aligning controls
Entering new records via a form in form view
Sorting, filtering and finding records
Queries
Select and parameter queries
Calculated fields, totals and criteria
Reports
Single column, group/total, summary and mailing labels
Report design sections
Sorting and grouping
Switchboard Form
Design a switchboard form to customise
an application
 Back
to the top
|
