Software and Management Training Courses

Pre Course Assessment Tool

Personal Details

Name
Company
Phone
Email
Address
Contact Preference Phone Email Mail

  Knowledge Level
Topic Good Fair None N/A
Database Theory
The Standard Access Layout
Other Possible Screen Layouts
Navigating in a Table
Editing/Deleting Records
Sub-Datasheets
Moving/Freezing/Hiding/Unhiding Columns
Formatting a Data Table
Sorting & Filtering
Saving Records v Saving Layout/Design Changes
Define a Select Query
Set Sort Options
Use Filter Options
Use Totals to Summarise Data
Understand Table Joins
Modifying Join Types
Create a Form from a Table or Query
Create a Sub Form Using the Wizard
Entering Data in Form View
Using Filter By Form
Add/Edit/Delete Records in Form View
Find Records
Create a Report from a Table or Query
Use the Report Wizard
Create a Grouped Report
Report Formatting Basics
Use a Text Box for Calculations in a Report
Print a Datasheet or Report
Change the Page Setup options
Print Part of a Datasheet or Report

Topic Good Fair None N/A
Understanding Databases
How Access Stores Data
Database Planning/Design
Documentation and Testing
Create a New Database
Field Names and Data Types
Field Size
Use Field Properties to Support Quality Data Entry
Use the Lookup Wizard
Understand Primary Keys
Use Indexing
Design Considerations for Linked Tables
Types of Relationship
The Relationship Window
Define/Edit a Relationship
Referential Integrity and Cascade Options
Printing Relationships
Use the Form Wizard
Add Labels/Lines/Boxes to Forms
Arrange Form Objects
Format Forms
Use Conditional Formatting
Add Text Boxes for Calculated/LookedUp Information
Define a Form/SubForm Structure
Create a Tabbed Form
Form and Form Object Properties
Define Multi-Table Select Queries
Add/Modify Joins
Adjust Join Properties
Use Sorts/Filters
Include Calculations
Create Parameter Queries
Nested Queries
Summary Queries
Hiding Query Fields
Concatenate Data Strings
Reports Based on Tables and Queries
Report Sections
Report Formatting
Grouped Reports
Sorting & Grouping Properties
Create Totals and Subtotals on Reports
Page Break Options
Make Table Queries
Update Queries
Append Queries
Delete Queries
Using Parameters in Expressions
Previewing Records/Forms/Reports
Changing Report Orientation/Paper Size
Printing the Entire Table/Form Records
Printing Query Output
Printing A Report/Specific Report Pages
Create a Switchboard
Create Additional Menus
Modifying the Startup Options
Export Data to Excel
Import Data from Excel
Import From Another Access Database

Topic Good Fair None N/A
Check a Table for Performance
Creating Single & Multiple Field Indexes
Multiple Field Primary Keys
The Crosstab Query Wizard
Modifying/Formatting Crosstab Queries
Crosstabs based on Queries
Using Criteria and Adding Parameters to a Crosstab
Find Duplicates and Find Unmatched Query Wizards
Create Complex Expressions
Use Domain Aggregate Functions
Creating a Chart using a Wizard
Modifying & Formatting a Chart
Updating Chart Data
Create Combo/Unbound Text Box to Collect Criteria
Use Criteria with a Query
Create Pivot Table Using Access Data
Refresh an Access Pivot Table
SQL Basics
Consolidate Data Using An Sql Union Query
Choosing to Split a Database
Using the Database Splitter
Working with a Split Database
Updating Database Links
Creating A Workgroup/Administrator
Adding Groups/Users
Assigning Permissions & Testing Database Security
Setting/Removing Passwords
Encoding/Decoding Database Files
Hiding/Unhiding Database Objects
Creating/Running/Modifying Macros
Using Conditional Macros
The MsgBox & InputBox Functions
Using Macro Names
Attaching Macros to Form Events
Option Groups and Macros
ApplyFilter Macro Action
Handling Exceptions
Understand Difference Between Macros and VBA
Simple Form/Sub Procedures
MSGBOX & INPUTBOX Functions
Standard Modules
Running Procedures from Controls
Navigating the VBA Editor
 

(You will not be able to submit your assessment until you have completed the personal details section and selected the appropriate Knowledge Level for EVERY topic in the above list.)