c2
Connect on:
  • Home
  • Course Centre
    • Project Management >
      • Professional Project Management
      • Project Management Essentials
      • Managing Project Requirements
      • Scheduling & Cost Control Project Managers
      • Project Leadership, Management & Communication
      • Risk Management for Project Managers
      • Negotiation Skills for Project Managers
      • Managing Remote Project Teams
      • Project Quality Management
      • Project Procurement Management
      • Earned Value Management
      • Professional Project Management - Best Practice
      • Professional Project Management - Exam Preparation
      • PRINCE2® Foundation & Practitioner
      • PRINCE2® Overview
    • Agile Project Management Courses >
      • Agile Project Management
      • Using Scrum in organistations
      • Certified ScrumMaster
    • Java >
      • Core Java Programming
      • Advanced Java Programming
      • Java Programming & XML
      • Java Networking
      • Java Virtual Machine (JVM)
      • Java & Java EE Open Source Testing Tools
    • Java Enterprise Edition (EE) >
      • Enterprise Java with Hibernate and Spring
      • Developing Java Web Applications
      • Java & Java EE Open Source Testing Tools
      • Spring Framework Development
    • C/C++ Programming >
      • C Programming Techniques
      • C++ Programming Fundamentals
      • C++ for C Programmers
      • Advanced C++ Programming
      • C++ & STL Design Patterns
      • Object Oriented C++ for Real-time Applications
    • Unix/Linux >
      • Linux Fundamentals
      • Linux Administration Essentials
    • Windows Server Courses >
      • Installing and Configuring Windows Server 2012
      • Windows Server 2008 - Server Administration
      • Configuring Windows Server 2008 Active Directory
    • .NET Courses >
      • ASP.NET MVC 4.0
    • Perl Programming Courses >
      • Perl Programming
      • Advanced Perl Programming
    • Python Programming Courses >
      • Python Programming
    • Database Courses >
      • MySQL for Developers
    • CompTIA >
      • CompTIA Network+
    • Scripting >
      • JavaScript - Introduction
      • JavaScript - Advanced
    • Data Analysis & Design >
      • Data Analysis & Design - Introduction
      • Data Analysis & Design with UML
    • Microsoft Office Courses >
      • Microsoft Word - Introduction
      • Microsoft Word - Intermediate
      • Microsoft Word - Advanced
      • Microsoft Access - Introduction
      • Microsoft Access - Intermediate
      • Microsoft Access - Advanced
      • Microsoft Excel - Introduction
      • Microsoft Excel - Intermediate
      • Microsoft Excel - Advanced
      • Microsoft Excel - Dashboards
      • Microsoft Excel - Macros
      • Microsoft Excel - Expert
      • Microsoft PowerPoint - Level 1
      • Microsoft PowerPoint - Level 2
      • Microsoft PowerPoint - Advanced
      • Microsoft Outlook - Introduction
      • Microsoft Outlook - To Manage Your Time Efficiently
      • Microsoft Project - Introduction
      • Microsoft Project - Advanced
      • Microsoft Publisher - Introduction
      • Microsoft Visio - Introduction
    • Solaris >
      • Solaris 10 Administration
  • Testimonials
  • About
  • Contact

Microsoft Access - Advanced

Course Description

This is a Microsoft Access Advanced course.  The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending.  For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

Course Duration

1 day

Course Objectives

This course provides candidates with practical experience of the topics listed in the course outline below.  On completion, candidates should have an excellent knowledge of the advanced features.

Course Content

​CONCEPTS OF NORMALISATION
Database Design

TRANSFERRING DATA
Using Data from Another Source
Exchanging Data With Excel
Using The Linked Table Manager
Exporting Data

DATABASE UTILITIES
Adding Security Encryption To A Database (Password Protecting)
Compacting And Repairing A Database
Backing Up A Database

SPECIAL QUERIES
Join Types In A Query
Using The Crosstab Query Wizard
Using The Find Duplicates Query Wizard
Using The Unmatched Query Wizard

CREATING RELATIONSHIPS
Creating A Relationship 
Setting Referential Integrity
Adding Cascade Options
Viewing Subdatasheets
Deleting A Relationship

FORM DESIGN TOOLS AND METHODS
Form Headers and Footers
Setting The Tab Order
Creating A PivotTable View
Filtering a PivotTable View
Using AutoCalc in a PivotTable View
Changing PivotTable View Properties

SPECIAL FORM DESIGN TECHNIQUES
Automating Forms with Controls 
Creating A Command ButtonCreating A Combo Box
Creating A List Box
Creating An Option Group
Adding A Logic Control
ActiveX Controls

SPECIAL REPORT DESIGN TECHNIQUES
Controlling Sections in Report Design View
Creating A Calculated Control
Sorting a Report
Grouping Data In A Report
Creating Summary Calculations 
Inserting a Page Break

USING SUBFORMS/SUBREPORTS
Creating MainForm/Subform and MainReport/SubReport Arrangements
Formatting Main/Sub Form/Report Arrangements
Displaying A Subform/Subreport Total

WORKING WITH MACROS
Introduction to the Macro Designer
Creating A Macro
Saving A Macro
Using Single Step Mode For Testing A Macro
Running A Macro
Editing An Existing Macro
Creating An Autoexec Macro
Macro Examples

USING SWITCHBOARDS
Using the Switchboard Manager
Opening A Switchboard Automatically

Who should attend?

Aimed at those people who wish to learn the advanced features of Microsoft Access. This course provides candidates with practical experience of the topics listed in the course outline. On completion, candidates should have an excellent knowledge of the advanced features.

Pre-requisites

Those attending should have an above average understanding of Microsoft Access to an intermediate level, be competent Windows users and be familiar with the basics of file and disk management.
Powered by Create your own unique website with customizable templates.