Course Details close

Course Details

Price:
(inc GST)		 $ 1485
Application:Access
Level:Essentials
Version:2010
Duration:3 days
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)		 10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Access Essentials 2010 Course

   (4.78 out of 5)
253 Access essentials student evaluations

Quick links

Access Essentials 2010 Course

Course Overview

This course is for students with no prior knowledge of Microsoft Access or relational databases and is designed to teach you the concepts and structure for building an Access database. During this 3 day course you will learn how to build tables to store data, create forms for data entry, create and run queries to analyse data and produce printable reports. If you have inherited an Access database that you have to learn how to manage and maintain or just need to know how to work with an Access database, then this course is for you. Some knowledge of Excel would be advantageous for this course.

At the completion of this course students will gain an understanding of the concepts and terminology used throughout Microsoft Access. Students will also be able to build a basic database, manipulate the data and create a basic queries, forms and reports.

Course Prerequisites

Basic computer and keyboard skills

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Course Dates

Course Date Price Add Course Qty Status

There are currently no public dates scheduled for this course.

If you have 3 or more people interested in this course, call us today to discuss group training - 1300 937 782.

Course Outline

Introducing Access

  • Info vs Data
  • Why Choose Access
  • Use Access or Excel?
  • Explore Access Windows
  • Access Architecture

Access Options and the Ribbon

  • Tabs and Ribbons
  • Navigation Pane
  • Explore Options

Databases Explained

  • Database Essentials

Designing a Database

  • Design Basics
  • Evaluate Current Business Practices
  • Project Plan Development
  • Database Planning
  • Define Core System Users
  • Plan Tasks
  • Plan Data Flow
  • Plan Data Elements
  • Table Design and Creation
  • Review Tables
  • Design User Interface Model
  • Interface User Testing
  • Finalise User Interface and Underlying Queries
  • Report Design
  • Build Application and start-up routines
  • System User Testing
  • Sign off and Release
  • Importance of Naming conventions

Building Tables

  • Efficient Database Model Designing
  • 1st Normal Form
  • 2nd Normal Form
  • Design Tables
  • Field Properties
  • Lookup Wizards
  • Create Single Table Lookup Manually
  • Date Format Field Properties
  • Phone Number Input Mask Field Properties
  • Breaking Normalisation Rules
  • Primary and Foreign Keys
  • Compact and Repair Database
  • Navigation Pane Options

External Data

  • Import Data
  • Text Files
  • Import Errors
  • Import Unmatched Data

Table Relationships

  • Referential Integrity Explained
  • Establish Referential Integrity
  • Edit Existing Relationship

Forms Quick Look

  • Create Standard Form with AutoForm
  • Form Wizard
  • Form Properties Basics

Configure Display Options

  • Trust Current Database
  • Default Field Properties
  • Change Display Format

Access Select Queries Basics

  • Relational Queries Basics
  • View Data
  • Query Views
  • Pivot Table / PivotChart Views
  • Create Single Table Query
  • Query Design Grid
  • Selecting ALL Table Fields
  • Add Multiple Tables to Query
  • Manually Form Links
  • Move Query Fields
  • Delete Query Fields
  • Single Field criteria
  • Specific Data Types
  • AND and OR Criteria
  • Combe AND and OR
  • Range Expressions
  • Exclusions
  • Wildcards
  • Queries for Table Lookups

Parameter Queries

  • Create Parameter Queries
  • More Flexible Queries
  • Display Range of Records Nominating Parameter Data Types

Calculated Fields

  • Renaming Fields and Concatenation
  • Calculated Fields
  • Numeric Fields in Calculations
  • Format Calculated Fields

Form Design Considerations

  • Forms Uses
  • Form Element Summary
  • View Styles
  • Properties
  • Complete Form Properties Summary
  • Create New Form Manually
  • Edit Labels
  • Field Properties
  • Align and Reposition Form Controls
  • Set Tab Order
  • Finishing Touches
  • Design with Sub Forms
  • Parent and Sub Form Forms

Enhance Form Design

  • Form/Report Tools
  • Review Existing Forms
  • Additional Tables
  • Convert Text Box to Combo Box
  • Unbound Text Boxes
  • Concatenated Combo Boxes
  • Calculated Text Boxes
  • Modify SubForm
  • Sub Form Fields in Calculations
  • Buttons
  • Tab Controls
  • Hyperlinked Fields

Simple Access Reports

  • Define Dataset
  • Reports Using Wizard
  • Design Reports displaying Numeric Info
  • Report Design View
  • Edit Controls
  • Resize Fields and Text Labels
  • Delete Report Elements
  • Report Margins

Modify Reports

  • Group and Sort
  • Page Breaks
  • Report vs. Page Header & Footer
  • Keep Together Options
  • Add Controls
  • Modify Record Source

Design Navigation System

  • User Interface Design Summary
  • Main Menu Form
  • Command Buttons
  • Navigation Buttons
  • Align Buttons
  • Boxes and Labels
  • Delete Buttons
  • Print

Control Access at Startup

  • Application Icon and Title
  • Define Initial Form

Student Comments

  • Access Essentials training course
    Sean was fantastic.
    - Timothy
  • Access Essentials training course
    Informative - a lot of information to take in but the course flowed in a way that allowed for everything taught to make sense.
    - Keirin
  • Access Essentials training course
    This is hands down the best Microsoft application course that I have ever attended. Thank you.
    - Melissa
  • Access Essentials Training Course
    Craig was excellent and passed the training to my level and assisted where I needed additional information.
    - Greg
  • Access Essentials training course
    The trainer really knows his stuff and presented the material very well and made a difficult subject quite understandable.
    - Stephen
  • Access Essentials training course
    Thanks and well done.
    - Aaron
  • Access Essentials training course
    Enjoyed the course and felt I got a lot out of it - Sean is a fantastic trainer!!!!!
    - Sascha
  • Access Essentials training course
    Sean is a great and inspirational teacher and clearly very skilled & knowledgeable in this software - I will be back! (is that a trekky comment?) again, funny......
    - Chris
  • Access Essentials Training Course
    Enjoyed the course and felt I got a lot out of it - Sean is a fantastic trainer!!!!!
    - Sascha
  • Access Essentials Training Course
    Excellent trainer. Approachable and not boring. Imparts knowledge well. Overall a good learning experience. Thank you.
    - Monica
  • Access Essentials training course
    Yes, I now have the secrets of the Gods so bow down before me mere non-Access minions.
    - Ron
  • Access Essentials Training Course
    Sean was fantastic.
    - Timothy
  • Access Essentials training course
    Excellent trainer. Approachable and not boring. Imparts knowledge well. Overall a good learning experience. Thank you.
    - Monica
  • Access Essentials training course
    Craig is a great presenter, very patient, and really tailored the course to our needs. I'd definitely recommend his company to colleagues and to my wider business network.
    - Tracey
  • Access Essentials training course
    Very well organised. Practical applications.
    - Ella
  • Access Essentials training course
    This is hands down the best Microsoft application course that I have ever attended. Thank you.
    - Melissa

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us