AccTech Systems COURSE OUTLINE:
COURSE: MICROSOFT ACCESS:
FOUNDATION LEVEL

One of the most efficient and powerful way of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, create and modify databases and its various objects using the Microsoft Office Access 2007 relational database application. This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes.

TIMES: 09:00 - 16:00
DURATION: 1 Day
VENUE: AccTech Academy : Rivonia
AccTech Academy : Centurion
COURSE TYPE: Hands-on, Instructor lead
GROUP SIZE: Grouped according to skill level with a maximum number of 8 delegates
COURSE DOCUMENTATION:
  • User guide
  • User Competency Assessment
  • Certificate of competence
TARGET AUDIENCE: This course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.
PREREQUISITES: Windows literate
INCLUSIONS: Light Lunch and refreshments
COST PER DELEGATE:
Price on request
FOR BOOKINGS:
Contact Elmien Diedericks or Ronlee Amien
training@acctech.biz

HIGH LEVEL COURSE OUTLINE:

ACCESS 2007 database concepts
  • What is a database
  • What is a relational database
  • What is a table
  • What is a record
  • What is a field
  • What is data
  • Data types

ACCESS navigation
  • Opening access
  • Exploring the access window
  • The ribbon
  • Ribbon tabs
  • Groups and dialog box launcher
  • Shortcut keys
  • Pointer keys and quick keys
  • Mouse wheel
  • Contextual tabs
  • Minimizing the ribbon
  • Quick access toolbar
  • The Office button
  • Help function

Database security
  • Opening a database
  • Security warnings
  • Trusted locations - trust centre
  • Setting of default folder location

Database creation
  • Creating a new database
  • Blank database
  • Saving a table
  • Adding and renaming fields
  • Using datasheet views
  • Using design views
  • Changing views

Tables - modify and navigate
  • Adding fields - design view
  • Data type - overview
  • Data type - descriptions
  • Using the attachment data type
  • Adjusting column width
  • Moving a column to rearrange the column order
  • Adding records to a table
  • Navigating through records within a table
  • Closing a database
  • Navigation pane

Forms
  • Forms overview
  • Creating forms
  • Modify forms
  • Modify a form title
  • Modify a form label
  • Saving a form
  • Form view
  • Adding and formatting attachments
  • Modifying records in forms
  • Deleting records in forms
  • Adding records in forms
  • Closing forms
  • Opening forms
  • Deleting a form

Queries
  • What are queries
  • Creating a simple query
  • Adding a criteria to a query
  • Running a query
  • Editing criteria in a query
  • Saving a query
  • Creating a two table query and sorting the results
  • Deleting a query

Field properties, validation and input masks
  • Field properties
  • Input mask
  • Validation rules
  • Field properties - guide tables

Table and record manipulation
  • Closing an object table
  • Renaming an object table
  • Editing data within record
  • Deleting data within a record
  • Using the undo command
  • Deleting a single record
  • Deleting multiple records
  • Save as - database object
  • Deleting table

Indexing and primary keys
  • Defining a primary key
  • Indexing
  • Crating a single field index
  • Creating a multiple field index
  • Deleting multi-field indexes

Filtering and sorting
  • Text filters
  • Applying a single filter
  • Clearing a single filter
  • Creating multiple filters
  • Clearing multiple filters
  • Sorting

Relationships
  • Table relationships
  • One-too-many relationship
  • Many-to-many relationship
  • Creating relationships between tables
  • Referential integrity
  • Cascade options
  • Cascade update related fields
  • Cascade delete related records
  • Enabling cascade options
  • Deleting relationships

Reports
  • What is a report
  • Creating simple reports
  • Using Report Wizard
  • Modifying the layout of a report
  • Widening a report column
  • Modifying the report title
  • Adding logos to a report
  • Auto formatting a report
  • Modifying field names within a report
  • Inserting and formatting the date and time
  • Adding available fields to a report
  • Resizing reports for printing
  • Closing a report
  • Deleting a report

Printing
  • Considerations before printing
  • Print preview
  • Orientation
  • Print Preview
  • Setting margins
  • Printing a complete table
  • Printing selected records
  • Printing a query or reports
  • Printing forms
For more information please contact Elmien at our Centurion office +27 (12) 664 0200 or contact
Ronlee at our Rivonia office +27 (11) 803 7327.

Print this page