Access - Accelerated Introduction
Participants can bring work that they would like to put on a database. Over the 3 hour course participants can apply their new skills to work that is relevant to them and they can take their work away with them.
BASICS
- Starting and exiting Access
- Using the menus and help
- Opening and closing a database
- Aspects of the database window
USING A DATABASE
- Using a database
- Changing from table to form view
- Moving and resizing columns and rows
- Formatting the table
CREATING A TABLE
- Create a table
- Define fields
- Choose data types and field properties
- Setting default entries and validating data
- Delete, insert and rearrange fields
- Using the primary key and indexes
FIND, SORT AND FILTER
- Finding a record
- Sorting the database
- Create a filter, specify criteria. apply and save
WORKING WITH QUERIES
- Entering query criteria
- Choosing columns to show
- Calculating totals and averages
- Saving and modifying a query
CREATING REPORTS
- Designing a report using Report Wizard
- Grouping Fields
- Summary Information
- Detail Properties, Headers and Footers
Class Details
3 hours 10am - 1pm or 1:30 - 4:30
4 or more people - $150 + GST (per person)
3 people - $175 + GST (per person)
1 or 2 people - $195 + GST (per person)
Evening Class 2½ hours 5:30pm - 8:00pm $90 + GST
Venue:
On your premisses or we can arrange a venue to suit.
Dates
Dates don't suit? Call or E-mail.