2007Ó Integrity Computer Solutions.
The
Learning Laboratory
innovate results trust
ABN: 94 081 457 454
11th Floor
Adelaide Bank Building
90 King William Street
ADELAIDE SA 5000
Tel. 1300 731 451
Fax. (08) 8231 2427
www.learnlab.com.au
labinfo@learnlab.com.au
Integrity
Training Solutions
innovate results trust
ABN: 58 309 252 680
Suite 2, Level 1
902 Mt Alexander Road
Essendon VIC 3040
Tel. 1300 731 451
Fax. (03) 9372 9382
www.integritytrainingsolutions.com
info@integritytrainingsolutions.com
A division of...
Microsoft Access - Training Needs Analysis
This Questionnaire is designed to assess which training course will best suit your needs. Please indicate which box best describes your level of competence with each of the functions listed. The Questionnaire will be most useful if you answer as openly as possible.
You will receive an email with our recommendation(s) for the course(s) best suited to your current skill level, based on the findings from this questionnaire.
* Name and email are required fields.
Name
Company
Email
Phone
N/A = Not Applicable Are you Competent? Y = Yes N = No
Topic
N/A Y N
Access Basics
Using a Mouse
Identifying Parts of the Screen
Using Pull down Menus
Working with Dialog Boxes
Defining a Relational Database
Starting Access
Exiting Access
Opening a Database
Closing a Database
Defining the purpose of Objects in the Database Container
Using Existing Databases
Analysing an Existing Database
Discovering the Relationships
Adding Records
Deleting Records
Navigating through data
Finding specific records
Filtering by selection
Creating basic queries
Creating basic reports
Tables
Database Design Fundamentals
Normalisation
The Primary Key
Field Types
Field Attributes
Setting One to One Relationships
Setting One to Many Relationships
Setting Many to Many Relationships
Referential Integrity
Cascade Update Related Fields
Cascade Delete Related Records
Attaching Tables
Importing Data
Queries
Purpose and Planning
Creating Queries
Query Design View
Queries using Criteria
Queries using Parameters
Using fields from multiple tables
Calculated Fields
Totalling Query
Cross Tab Query
Make Table Query
Update Query
Append Query
Delete Query
Using DateAdd
Modifying Join Types
Forms
Purpose and Planning
Using the Form Wizard
Modifying Form Design
Adding and Removing Fields
Moving and Sizing Fields
Entering Titles and additional text
Modifying Properties
Modifying Form and Control colours
Setting up ComboBoxes
Changing the Tab Order
Main and Sub Forms
Advanced Form Controls
Reports
Purpose and Planning
Using the Report Wizard
Modifying Reports
Printing Reports
Creating Label Reports
Mail Merging to Microsoft Word
Creating Grouped Reports
Totals Reports
Saving a Form as a Report
Page Breaking
Chart Reports
Macros
Purpose and Planning
Creating Basic Macros
Assigning Macros to Buttons
Creating a Main Menu including Macro Buttons
Macro Groups
Conditions
Macros vs Modules
Other Database Functions
Repairing and Compacting
Security
Replica
Analyse
N/A Y N
Any Other Comments