Access

Darwin Human Resource & Computer Academy
Darwin, NT, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Access.

Methodology
Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Confirmation of Assessment Plan
This will be issued to the trainee at commencement of training session.

Expected Outcome
By the end of the course the participant should be able to use the following functions and features of Microsoft Access.

CONTENT

Access Basics

Database overview
Elements of a database system
How other DBMS products work
How Access works
Starting Access
Working from startup
Working with Menus
Using the toolbar
Closing a Database
Opening a database window
Quick Review

Access Help
Online Help
Using the Office Assistnat
Customising the Office Assistant
Removing the Office Assistant
Using Help Contents
Using the Help index
Using the What’s This?
Checking your system details
Quick Review

Creating a Database
Creating a database
Scoping the system
Creating a new database file
Creating a new table
Creating fields
Creating a Primary key
Creating field properties
Saving the table
Quick Review

Adding Records
Overview of data entry
Entering records directly into the table
Using the data entry facility
Adding records through a form
Quick Review

Changing Data
Overview changing the data
Changing table structures
Updating records
Finding a record to change
Changing several records at once
Deleting records
Quick Review

Working with a Table
Data overview
Moving about a table
Finding records
Searching and replacing
Filtering data
Filtering by form
Printing from a Table
Quick Review

Formatting a Table
Formatting overview
Widening columns
Selecting data
Changing the grid lines
Hiding columns
Freezing columns
Changing row heights
Changing fonts
Moving columns
Quick Review

Select Queries
Quering overview
Creating a query design window
Selecting fields for output
Dragging several fields
Double clicking fields
Selecting records
Selecting data within ranges
Sepcifying OR conditions
Using An-In-Line OR
Saving a query

Report Wizards
Reports overview
Creating a columnar report
Creating a tabular report
Using the report wizard
Using a query for a report
Changing a reports design
Running a report
Quick Review

Forms From Wizards
Forms overview
Creating a columnar auto-form
Creating a datasheet auto-form
Creating a tabular auto-form
Using the form wizard
Working with a form
Creating a form from a query
Quick Review

Conclusion
...''

Phone:08-89412344

School Address:

Suite 2/2 Shepherd Street
GPO Box 1815
Darwin NT 0801
Australia

Jobs & Resumes: Darwin
Houses & Roommates: Darwin

Search other schools for Access training resources.

Certificate IV in Project Management
Time Management
Cost Management
Quality Management
Communications Management
Contract and Procurement
Windows XP
MS Word
Excel
PageMaker
CorelDraw
PowerPoint
Photoshop
Publisher
InDesign
MS Project
FrontPage
Dreamweaver

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.