Course Details close

Course Details

Price:
(inc GST)		 $ 990
Application:Access
Level:Essentials
Version:365
Duration:2 days
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
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 Course

   (4.80 out of 5)
292 Access essentials student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060		 Break Times:
(approx)		 10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 2 days Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)		 $ 990
Sale Price:
(inc GST)		 $

Quick links

Access Essentials Course

Course Overview

The Access Essentials course is conducted over 2 days and is designed for people with no prior knowledge of Microsoft Access or relational databases. This course introduces relational database concepts and architecture which is the cornerstone of any database design. Once the table schema has been constructed and enforced students will be able to enter new data via forms, analyse the data using queries and present the data for presentation or printing using reports. With a solid grounding in the fundamentals of database design, students are able to implement their newly acquired skills from the training when developing Access databases in the future. With time and practice, the sky’s the limit.

Who Should Attend This Course

This course is targeted at students with no prior knowledge of Microsoft Access or relational databases. As a result of this course students will gain a solid understanding of relational database concepts and terminology and with time and practice be able to build a database, manipulate table data, create basic queries, forms and reports.

Course Prerequisites

Basic keyboard and computer skills and a general understanding of Microsoft Excel would be helpful.

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

With each course we provide you with a comprehensive course manual for you to practice post course.

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.

View Course Dates

Face to Face (public course dates)

Online via Webinar (via Microsoft Teams)

Public Course Dates

Course Date Price Add Course Qty Status
13-Jan-25 (Mon)$990.00 0
06-Mar-25 (Thu)$990.00 0
0 items $0.00

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
13-Jan-25 (Mon)$990.00 0
06-Mar-25 (Thu)$990.00 0
0 items $0.00

Course Outline

Exploring Access

  • Why use Access?
  • Starting Access
  • Navigate Access
  • Tabs and Ribbons
  • The Backstage
  • The Quick Access Toolbar Exiting Access

Database Objects

  • Tables
  • Enter Data into Tables
  • Forms
  • Queries
  • Reports
  • Overview of Macros and Modules

Create A New Database and Tables

  • Planning a Database
  • Create a Database
  • Create a Table
  • Select a Data Type
  • Designate a Primary Key
  • Save the Table
  • Enter Data into a Table Selecting and Deleting Records

Working in Tables

  • Find Data
  • Replace Data
  • Filter By Selection
  • Filter Excluding Selection
  • Using Text Filters
  • Freeze Fields
  • Sorting Data
  • Printing

Relationships

  • Relational vs Flat File Databases
  • The Relationships Window
  • Create a One-to-Many Relationship
  • Create a One-to-One Relationship
  • Create a Many-to-Many Relationship
  • Fix the Many-to-Many Relationship
  • Referential Integrity
  • Cascade Update and Cascade Delete SubDataSheets

Simple Queries

  • Query Design
  • Add Tables to the Query
  • Add Fields to the Query
  • Save the Query
  • View the Query in DataSheet View
  • Sort the Query
  • Rearrange the Order of the Fields
  • Filter Criteria and Delimiters
  • Datatype Mismatch Errors
  • Using Mathematical Operators Multiple Criteria “Between” Criteria Wildcards
  • Parameter Prompts
  • The Simple Query Wizard

Table Field Properties

  • Change Field Size for Text Fields
  • Set the Format for Text Fields
  • Apply an Input Mask
  • Enter a Caption
  • Set Default Values
  • Validation Rules and Validation Text
  • Required and Allow Zero Length
  • The Others
  • Activating the Lookup Wizard
  • Type the Values into the Lookup Wizard
  • Modify the List
  • Use Values from a Table in the Lookup
  • Wizard
  • Allow Multiple Values Allow Value List Edits
  • Change Field Size for Number Fields
  • Overflow Errors
  • Singles and Doubles
  • Set the Format for Number Fields Change the Format for Date/Time Fields

Data Entry Forms

  • Create a Form Based on a Table
  • Use the Form Wizard
  • Change to Design View
  • Select Controls on a Form
  • Change the Control Layout
  • Move Controls
  • Snap to Grid
  • Move One Half of a Paired Control
  • Resize Controls
  • Align and Distribute Controls
  • Parts of a Form
  • Add a New Label
  • Format the Label
  • Add a New Text Box
  • Change Control Properties Add a New Combo Box
  • Add a New Image Control
  • Add a Field from the Field List
  • Add a Tab Control
  • Add More Pages to the Page Control
  • Modify the Tab Order
  • Remove Calendar Controls
  • Remove Broken References

Switchboard Forms

  • What is a Switchboard?
  • Create a Blank Form
  • Change the Form Properties
  • Add a Command Button
  • Test the Form
  • Set the Display Form
  • Turn off the Navigation Pane Change Ribbon and Shortcut Menu Options

Query-by-Form

  • Create the Query
  • Create the Form with a Combo Box
  • Add Other Controls
  • Change the Control Properties
  • Link the Query to the Combo Box with the
  • Expression Builder
  • Link the Query to the Text Box Date Control with the Expression Builder What Does It Mean?

Other Query Wizards

  • The Crosstab Query Wizard
  • The Find Duplicates Query Wizard The Find Unmatched Query Wizard

Reports

  • The Report Wizard
  • Add Grouping in the Report Wizard
  • Manually Grouping in the Report
  • Modify and Move Controls on the Report
  • Resize Sections
  • Calculate the Date Printed
  • The Print Blank Pages Error

Student Comments

  • Access Essentials Training Course
    Sean was fantastic.
    - Timothy
  • Access Essentials training course
    The entire course was very helpful and relevant. I have had minimal experience with the 'behind the scenes' of Access so this was an excellent introduction to how the database works.
    - Jenny
  • 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
    Sean was fantastic.
    - Timothy
  • Access Essentials training course
    Thanks and well done.
    - Aaron
  • 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
    As we have our own database at work created with Access Proficiency Information Management System - PIMS it has given me more confidence in navigating through the system without accidentally ruining something that I do not know how to fix. Thank you very much for an extremely informative two day course!
    - Hamish
  • 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
    This is an excellent introductory course for Access
    - Mark
  • 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
    This is hands down the best Microsoft application course that I have ever attended. Thank you.
    - Melissa
  • 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
    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
    Enjoyed the course and felt I got a lot out of it - Sean is a fantastic trainer!!!!!
    - Sascha
  • 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
    Very well organised. Practical applications.
    - Ella
  • Access Essentials training course
    I appreciated Craig's tolerance when I fell behind and had to re-trace sections where I had fallen behind. The comprehensive manual will be very useful when practicing the use of ACCESS.
    - Geoff
  • 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 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

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us