At AWT we offer flexibility and range:

Access 2010 Orientation
Understanding Microsoft Access
2010
Starting Access
Understanding The Backstage
View
Opening An Existing Database File
Understanding The Access 2010
Screen
Working With The Navigation Pane
Working With A Table
Working With Other Database
Objects
Closing A Database File
Exiting From Access 2010
 

Designing A Lookup Database
Understanding How Access Stores
Data
Understanding Access 2010 Data
Types
Scoping Your New Database
Identifying Table Problems
Refining Table Structures
Finalising The Design
 

Creating A Lookup Database
Creating A New Database File
Creating The Lookup Table
Defining The Primary Key
Saving And Closing A Table
Creating The Transaction Table
Understanding Lookup Table
Relationships
Connecting To A Lookup Table
Viewing Table Relationships

Modifying Table Structures
Opening An Existing Table
Adding Fields To An Existing Table
Understanding Field Properties
Changing Field Size
Changing Field Names
Changing Decimal Places
Changing Date Formats
Indexing Fields
Deleting Fields From A Table
Copying A Table Within A
Database
Deleting A Table From A Database
File

Adding Records To A Table
Typing Records In A Table
Adding Records Using A Form
Saving A Form Layout For Reuse
Adding Records Using An Existing
Form

Adding Records
Importing From Microsoft Excel

Adding Transactional Records
Typing Transactional Records
Adding Transactional Records
Using A Form
Adding Transactional Records
Adding Records Using A
Subdatasheet
Removing A Subdatasheet
Inserting A Subdatasheet
 

Working With Records
Table Navigation
Navigating To A Specific Record
Editing A Record
Deleting Record Data
Undoing A Change
Deleting A Record
Deleting Several Records
Searching In A Table
Searching In A Field
Finding And Replacing
Printing Records From A Table
Compacting A Database
 

Sorting And Filtering
Simple Sorting
Sorting On Several Fields
Simple Filtering
Working With Filters
Filtering Between Dates
 

Creating Queries
Understanding Queries
Creating A Query Design
Working With A Query
Changing A Query Design
Applying Record Criteria
Clearing Selection Criteria
Saving A Query
Running Queries From The
Navigation Pane
Deleting A Query
Creating Queries

Creating And Using Reports
Understanding Reporting In
Access
Creating A Basic Report
Working With Existing Reports
Previewing And Printing A Report
Changing The Report Layout
Using The Report Wizard
Creating A Grouped Report
Creating A Statistical Report
Working With Grouped Reports

Creating And Using Forms
Understanding Forms
Creating A Basic Form
Creating A Split Form
Binding A Form To A Query
Using The Form Wizard
Working With Existing Forms
Editing Records In A Form
Deleting Records Through A Form
Deleting An Unwanted Form

Learning Outcome:
􀂾 understand how Access is used and how to navigate around it
􀂾 design a database with lookup tables
􀂾 create a database structure using Access 2010
􀂾 modify the structure of an existing table
􀂾 add records to a new table
􀂾 add transactional records to a lookup database
􀂾 work with the records in a database table
􀂾 sort and filter records in a table
􀂾 create simple and effective queries
􀂾 create meaningful reports from tables
􀂾 create and use a variety of forms

Prerequisites: assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows
operating system environment.

Training Options:

Classroom: One-on-one tuition, Course Length: 6hrs, Cost: $570

Self Paced, Distance Learning: Learn in your own time, at your own pace. All you require is a computer and email address. We supply step by step lessons and email support

Cost: $285

Data Validation
Assigning Default Values
Validation Rules And Text
Validating Numbers
Setting Required Fields
Working With Validations
 

Formatting Tables
Changing Column Widths
Formatting Cells In The Table
Changing Fonts
Moving Columns In A Table
Freezing Columns In A Table
Hiding Columns In A Table
Unhiding Columns
 

Querying Techniques
Modifying A Saved Query
Creating AND Queries
Creating OR Queries
Querying Numeric Data
Querying Dates
Using A Range Expression
Querying Opposite Values
Moving Fields In A Query
Sorting Query Data
Removing Fields From A Query
Querying Using Wildcards
Problem Characters
Querying With A Lookup Table
Sorting Query Data Numerically
Displaying NULL Values
 

Parameter Queries
Creating A Parameter Query
Displaying All Records
Using Parameters To Display A
Range
Using Parameters In Expressions

Calculations In Queries
Creating A Calculated Field
Formatting Calculated Fields
Summarising Data Using A Query
Changing The Grouping
Calculating With Dates
Using Criteria In Calculations
Concatenating String Fields
 

Modifying Forms
Understanding Form Design And
Layout
Switching Between Form Views
Selecting Form Objects
Working With A Control Stack
Changing Control Widths
Moving Controls On A Form
Aligning Controls

Understanding Properties
Changing Label Captions
Adding An Unbound Control
Adding A Control Source
Formatting A Control
Checking The Current Tab Order
Changing The Tab Order
Inserting The Date Into The Form
Header

Creating And Using Macros
Understanding Macros And VBA
Creating A Macro
Running A Macro
Modifying An Existing Macro
Interacting With The User
Stepping Through A Macro
Documenting Macros

Macro Techniques
Creating A Print Macro
Using Conditions To Enhance A
Macro
Creating A Sequence Of
Conditions
Understanding The Versatility Of
MsgBox
Using The MsgBox Function
Reconfiguring A Message Box
Using The InputBox Function
 

Macros On Forms
Understanding Macros On Forms
Creating Navigation Macros
Accessing Event Macros
Creating Unassigned Buttons
Programming An Event
Running An Event Macro
Modifying An Event Macro
Setting Echo Off
Adding A Close Button
Creating A Search Macro
Running The Search Macro
Understanding The Search Macro
Naming Macros
Referencing Macro Sheet Macros
 

Learning Outcome:
􀂾 use various data validation features in Access to protect data
􀂾 format the data in a table
􀂾 perform more advanced queries using a variety of querying techniques
􀂾 create and use parameter queries
􀂾 create calculated queries
􀂾 modify and adapt an existing form according to specific needs
􀂾 create and use macros in Access
􀂾 work with a number of macro techniques
􀂾 create macros on forms

Prerequisites: assumes some knowledge of the software to create basic databases and generate reports. It would be beneficial to have a general understanding of personal computers and the Windows operating system environment

Training Options:

Classroom: One-on-one tuition, Course Length: 6hrs, Cost: $600

Self Paced, Distance Learning: Learn in your own time, at your own pace. All you require is a computer and email address. We supply step by step lessons and email support

Cost: $300

Relational Database Design
Designing A Relational Database
Scoping The System
Determining The Inputs
Normalising A Database
First Normal Form (1NF)
Second Normal Form (2NF)
Second Normal Form – Case
Study
Third Normal Form (3NF)
Database Indexing
 

Creating A Relational Database
Creating A New Database File
Creating Lookup Tables
Defining A Primary Key
Saving And Closing A Table
Creating The Expense Type Table
Creating The Transactions Table
Creating The Details Table
 

Setting Table Relationships
Understanding Table Relationships
Understanding Lookup
Relationships
Looking Up The Employees Table
Looking Up The Expense Types
Table
Viewing Table Relationships
Understanding Table Joins
Editing The Employee Table Join
Editing The Expense Type Table
Join
Creating A New Join
Creating A Relationships Report

Multi-Table Queries
Understanding Relational Queries
Creating A Relational Query
Design
Filtering A Relational Query
Filtering Related Fields
Adding More Tables And Fields
Utilising Hidden Fields
 

Aggregation Queries
Creating An Aggregation Query
Working With Aggregation Queries
Multiple Aggregations
Modifying Aggregation Headings
Aggregating Calculated Fields
Applying Criteria To Aggregates
Understanding Nested Queries
Creating An Assembly Query
Creating The Nesting Query
 

Action Queries
Creating A Make Table Query

Using A Make Table Query
Expressions And Update Queries
Preparing An Update Query
Running An Update Query
Updating Using Expressions
Running An Expression-Based
Update
Creating A Delete Query
Running A Delete Query
Creating An Append Query
Running An Append Query
Turning Action Messages Off

Macro Techniques
Creating A Print Macro
Using Conditions To Enhance A
Macro
Creating A Sequence Of
Conditions
Understanding The Versatility Of
MsgBox
Using The MsgBox Function
Reconfiguring A Message Box
Using The InputBox Function
 

An Introduction To VBA
Understanding VBA
Coding VBA For An Event
Running VBA Event Code
MsgBox And InputBox
Modifying An Existing Procedure
Understanding The Modified Code
Creating A Standard Module
Loan Simulator Code
Running The Code
Understanding The Loan Simulator
Code
Creating A Button For The
Simulator
Attaching The Simulator Code

Outline
Creating A Manual Group
Grouping By Columns

Learning Outcome:
􀂾 design a relational database project
􀂾 create a relational database file with multiple tables
􀂾 set table relationships and join tables together
􀂾 create queries based on one or more tables
􀂾 create and work with aggregation queries
􀂾 create and use a series of action queries
􀂾 work with a number of macro techniques
􀂾 create some simple programming code using VBA

Prerequisites:

assumes some knowledge of the software and it would be beneficial to have a general understanding of personal computers and the Windows operating system environment

Training Options:

Classroom: One-on-one tuition, Course Length: 6hrs, Cost: $720

Self Paced, Distance Learning: Learn in your own time, at your own pace. All you require is a computer and email address. We supply step by step lessons and email support

Cost: $360