SydneyMelbourneBrisbane

BOOK NOW

Course Details
Price: $495dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFAccess Intermediate

Upcoming Dates

BOOK NOW

Course Details
Price: $495dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFAccess Intermediate

Upcoming Dates

BOOK NOW

Course Details
Price: $495dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFAccess Intermediate

Upcoming Dates
Do you want to understand how to create and manage databases?

Learn how to create, design and modify database structures efficiently. You will be taught how to use forms, build more complex queries and start using macros – these tools will allow you to get the most out of Access and improve your overall productivity.

What do I need to know to attend?

There is no requirement for this course however, it is aimed at students who have had some exposure to Access and Databases in the past. Students should be familiar with the content covered in our Access Level 1 course.

Learning Outcomes – Access Level 2

On completion of this course you should be able to:

  • 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 a navigation form for a database in Access
  • create forms using a combination of wizards and manual techniques
  • create and use macros in Access
  • work with a number of macro techniques
  • create and work with macros in forms
  • create and manage custom categories and groups in the Navigation Pane
Course Details
  • Courses will run from 9am – 4pm (approx.)
  • Classes limited to approx 10 people
  • Access Level 2 Course costs $495
  • Reference Manuals provided
  • Central city locations
Each Student receives
  • Reference Workbooks
  • e-Certificate of attendance
  • Complimentary post course training e-support
  • Experienced Trainers
  • Satisfaction guarantee or repeat FREE within 6mths
Related courses

InfoAccess Course Beginner
InfoAccess Course Advanced

Course Content
Data Validation
  • Assigning Default Values
  • Validation Rules and Text
  • Assigning Default Values
  • Validation Rules and Text
  • Required Fields Working with Validations
Formatting Tables
  • Changing Column Widths
  • Formatting Cells in a Table
  • Changing Fonts
  • Moving Columns in a Table
  • Freezing Columns in a Table
  • Hiding Columns in a Table
  • Unhiding Columns
Querying
  • 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
  • Querying for Uniqueness

Parameter Queries

  • Creating a Parameter Query
  • Displaying All Records
  • Using Parameters to Display a Range
  • Using Parameters in Expressions
  • Using Parameters with Wildcards

Calculations

  • 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
Navigation Forms
  • Creating a Simple Navigation Form
  • Creating a More Complex Navigation Form
  • Creating the Navigation Form Page Tabs
  • Creating Subsidiary Pages
  • Assignment Adding Subsidiary Pages
  • Editing Page Tab Names
  • Applying a Theme
  • Modifying Properties
  • Automatically Starting the Navigation Form

Forms

  • Creating a Multiple Item Form
  • Adjusting the Layout of a Form
  • Typing into a Form Layout
  • Disabling Fields
  • DIY Sub Forms
  • Removing SubForm Redundancy
  • Splitting and Merging Layout Cells
  • Adding an Easy Lookup Field
  • Adding Buttons to a Form
  • Adjusting Form Properties

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
Macro-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
Navigation Pane Protection
  • Understanding the Navigation Pane
  • Creating Custom Categories
  • Creating Custom Groups
  • Adding Objects to a Group
  • Hiding Groups and Objects
  • Showing Hidden Groups and Objects
Average rating:  
 7545 reviews

I enjoyed participating in the Microsoft Project Level 2 Course with Jason. Great teacher and fantastic knowledge of this subject. Well done! - Excel Intermediate Brisbane

Page 1 of 7545:
«
 
 
1
2
3
 
»
 
Download Course Content Here