Access Courses

Microsoft Access Courses Available

  • Course Description:
    The course concentrates on designing tables in a database, setting up relationships between the tables and setting up lookups between the tables. Table properties are explained in detail. Linking/Importing from other applications are also covered. Sample database templates are used for illustration. The user is introduced to queries, forms and reports. Delegates will be created a simple database during the course to illustrate all the features of a database. The course covers MICT Unit Standard: 116936.

    Duration:
    7 hours.

    Target Group:
    This course is intended for a delegate who would have to design new tables in MS Access or users who need to link/import existing Excel data into Access. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification would benefit from attending this course.

    Prerequisites:
    The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills. Excel knowledge would be an advantage, but is not essential.

    Method of training:
    Instructor led, hands-on exercises using a computer. Groups not more than 12 delegates.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topic 1 Database Terminology What is a table?
    What is the Primary key of a table?
    What is a Foreign key?
    What is a query?
    What is a form?
    What is a report?
    what is a macro?
    What is a module?
    Topic 2 Database Templates Database Templates
    Topic 3 Security in Access Trust Centers: Setting up Trusted Locations
    Topic 4 Navigation in the MS Access environment The Access Screen
    Navigating in an existing database
    Using the ribbon
    Shortcut Menus and Shortcuts
    Using the Wizards to create tables, queries, forms and reports
    Topic 5 Printing in Access Printing in Access
    Topic 6 Using Help Using Help
    Topic 7 Naming conventions for objects in a database Naming conventions for objects in a database
    Topic 8 Database Planning Database Planning
    Topic 9 Designing Tables Setting The Primary Key
    Selecting The Data Type For Table Fields
    Captions
    Input Mask Settings
    Formatting Numbers/Text/Dates
    Default Value
    Using Validation Rules and Validation Text
    Indexing in tables
    Using Unique Indexes
    Lookups to other tables/queries or create a typed list
    Copying/Deleting a table
    Topic 10 Importing/Linking tables Importing/Linking tables
    Topic 11 Navigating and Working in Tables Editing A Table
    Finding /Replacing data
    Deleting records
    Rearranging Fields
    Changing Column Widths
    Sorting
    Changing Font Size and Row Heights
    Hiding/Unhiding Columns
    Freezing/Unfreezing Columns
    Filtering Data
    Topic 12 Subdatasheets in Tables Subdatasheets in Tables
    Topic 13 Defining Default Relationships Between Tables Defining Default Relationships Between Tables
  • Course Description:
    This course concentrates on the design of queries. Forms and Reports are handled on an introductory level only. The course covers MICT Unit Standard: 116936.

    Duration:
    7 hours.

    Target Group:
    This course is intended for a delegate who would have to design new tables in MS Access or users who need to link/import existing Excel data into Access. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification would benefit from attending this course.

    Prerequisites:
    It would be an advantage to have attended the MS Access Basic course, but if the user is not going to be designing tables and ONLY going to be using existing data i.e. SQL tables or tables that have already been set up, they can start with this course. The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills. Excel knowledge would be an advantage, but is not essential.

    Method of training:
    Instructor led, hands-on exercises using a computer. Groups not more than 12 delegates.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topic 1 Tools to run MS Access efficiently Compacting and repairing a database
    Making a backup of a database
    Working with Trust centers Ð Trusted locations
    Topic 2 Queries Viewing Existing Queries
    Using the Query Window
    Examples Of Typical Criteria
    Creating A Query With A Sorting Order
    Adding Another Table In The Query Design
    Create A Query That Is Based On More Than One Table
    Topic 3 Using Calculations In A Query Using A Concatenation Operator In A Query (Combining Two Or More Fields)
    Calculating Totals In A Query (Group By)
    Topic 4 More advanced Query options Creating a query from another query
    Determining the top 10
    Creating a parameter query (Prompting the user to supply the criteria)
    Topic 5 Printing query results Printing query results
    Topic 6 Specialised queries Crosstab Queries
    Find Unmatched Query
    Find Duplicates Query
    Topic 7 Action Queries Creating a Make-Table Query
    Creating a Delete Query
    Creating an Append Query
    Update Queries
    Topic 8 Join Types In Queries Join Types In Queries
    Topic 9 Forms (Introduction) Creating a form with the form wizard
    Different views for a form
    Tips and tricks when designing a form
    To insert fields not displayed on a form
    Topic 10 Reports Creating a report using the report wizard
    Totals/summary options on reports
    Printing a report
    Topic 11 Exporting A Report As An Excel File Exporting A Report As An Excel File
    Topic 12 Send An Access Report To A Mail Recipient (Email) PDF format
    Excel format
  • Course Description:
    This course concentrates on Form and Report Design. Overview on Table design and Query Design. In this course the delegates would be expected to design a simple integrated database, consisting of tables, queries, forms, reports and macros. The course covers MICT Unit Standard: 116936 and 117927.

    Duration:
    14 hours suggested 2 day course (if only specific topics are covered the course can be done in one day).

    Target Group:
    This course is intended for a delegate who knows the basics of MS Access. Delegates should already be able to create their own queries in MS Access and they must understand the concepts of a database. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification would benefit from attending this course.

    Prerequisites:
    The delegates must have basic Windows skills; handling the mouse, opening and finding documents and basic typing skills. Excel knowledge would be an advantage, but is not essential.

    Method of training:
    Instructor led, hands-on exercises using a computer. Groups not more than 12 delegates.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topic 1 Database Design What is the aim of the database?
    What must the database generate as output?
    What fields do I need?
    Which tables must I create from the fields?
    What data must be validated and which fields are you going to be compulsory to fill in. What other properties will be needed, e.g. formatting
    How will I input the information?
    How will I automate my database?
    Testing the Database
    Topic 2 Trust Centres and setting up trusted locations Trust Centres and setting up trusted locations
    Topic 3 Tables (Overview) Table properties
    Topic 4 Normalisation Ð explaining the concept and illustrate with tables being imported from Excel Normalisation Ð explaining the concept and illustrate with tables being imported from Excel
    Topic 5 Relationships between tables Different types of Relationships
    Setting Referential Integrity to protect data
    The Cascade Update Related Fields Option
    The Cascade Delete Related Records Option
    Join Properties
    Topic 6 Queries (Overview) Different Types of Queries
    Creating a query to search for a blank field
    Using the left, middle, right, str$ functions to create codes
    Topic 7 Specialised Queries Creating a Parameter Query
    Using Calculations in A Query
    Setting Formats for a field in a Query
    Crosstab Queries
    Find Unmatched Query
    Topic 8 Action Queries Make-Table Query, Delete Query, Append Query, Update Queries
    Topic 9 Forms Tips and Tricks when designing a Form
    To insert fields not displayed on a form
    Disable Fields on a Form
    To hide a Field on a Form
    Tab Indexes on a Form
    Topic 10 Using Controls in Forms Adding controls to a form that perform tasks
    Calculations on a Form
    Working with Combo Boxes to find specific data on a form and formatting this combo box to always show the current record
    Creating Forms with Sub Forms
    The Switchboard
    Topic 11 The Start-up Menu Option Ð opening the database with a specific form and hiding objects The Start-up Menu Option Ð opening the database with a specific form and hiding objects
    Topic 12 Reports Sort records in a report
    Using grouping in reports to display totals
    Create a report based on more than one table
    Showing/Hiding Headers and Footers in a Report
    Section width greater than Page Width
    Saving A Form as A Report
    Creating Mailing Labels
    Topic 13 Documenting The Design Of A Database Documenting The Design Of A Database
    Topic 14 Exporting to Word/Excel/PDF format Exporting to Word/Excel/PDF format
  • Course Description:
    This course concentrates on Advanced Form and Report Design. The course also covers the use of macros and introduces Visual Basic to the user. The focus is on development. The course covers MICT Unit Standard: 116936 and 117927.

    Duration:
    21 hours, suggested 3 day course.

    Target Group:
    This course is intended for a delegate who wants to develop in MS Access. More advanced techniques on automation, using macros and a bit of Visual Basic programming is introduced. Delegates should already be able to create their own queries in MS Access and they must understand the concepts of a database. Delegates who would like to be assessed for a computer qualification or delegates who wish to obtain Microsoft Office Specialist certification would benefit from attending this course.

    Prerequisites:
    The delegates must a good knowledge of MS Access, using queries, forms and reports. They must also be able to design their own tables in MS Access.

    Method of training:
    Instructor led, hands-on exercises using a computer. Groups not more than 12 delegates.

    Course Content
    (If on mobile swipe table left and right to view details)

    Topic 1 Normalisation And Advanced Table Design Advanced Indexing In Tables
    Creating Unique Combinations In Tables (Non Primary Keys)
    Properties For A Table
    Topic 2 Relationships Referential Integrity
    Cascading Update And Cascade Delete Relationships
    Topic 3 Analyse Tools In Access Printing The Specs Of A Table, Query and Macros
    Topic 4 Advanced Query Features Updateable Queries
    Join Types In Queries
    Join Two Copies Of The Same Table In A Query
    Displaying Unique Values In A Query
    Handle the Error Messages In A Query
    Union Queries using SQL
    Using The DLOOKUP Function To Make Sure That A Query Is Still Updateable
    Topic 5 Advanced Form Design Hyperlink On A Form
    Unbound versus Bound controls
    Using Tab stops
    Adding Navigation Buttons And Record Controls On A Form
    Using Combo Boxes On A Form
    Change A Combo Box To Display The Current Record On A Form
    Display The Visual Basic Coding For Command Buttons
    Understanding And Using Events
    Opening A Form As A Popup Form
    Use Visual Basic Coding To Update A Record In A Table
    Displaying A Total From A Sub Form On A Main Form
    Visual Basic Commands For Opening And Closing Forms/Reports
    Using A Form To Create A Filter To Print A Specific Record In A Report
    Using Openers When Opening Forms
    Using Options Buttons And Check Boxes On Forms
    Topic 6 Reports Ð Advanced Features Hiding Duplicated Data On A Report
    Placing Information In More Than Column On A Report
    Print Group Headers In The Same Line As The Details Section
    Running Totals On Reports
    Using Running Totals To Generate Automatic Numbering On Reports
    Using The DSUM Function On Reports/Forms To Sum Relevant Data
    Restart Page Numbers On A New Group In A Report
    Topic 7 Autoexec Macro Autoexec Macro
    Topic 8 Splitting A Database Splitting A Database
    Topic 9 Modules Examples of functions that can be used for a specific purpose, using Visual Basic
    Topic 10 Protect A Database By Adding A Database Password Protect A Database By Adding A Database Password
    Topic 11 Working With Workgroups (When Access is run in compatibility mode for versions 2003 and before) Workgroups And Permissions
    Topic 12 Ms Access Specifications Ms Access Specifications
Microsoft Access

Our Courses

Microsoft Excel Course

Read More

Microsoft Word Course

Read More

Microsoft PowerPoint Course

Read More

Microsoft Access Course

Read More

Microsoft Oulook Course

Read More

Microsoft Excel Dashboard Reporting

Read More

VBA for Excel or VBA for Access

Read More

Microsoft Projects

Read More
Top