Microsoft Access Advanced (2007, 2010 & 2013)

Course

Online

£ 245 + VAT

Description

  • Type

    Course

  • Methodology

    Online

This is a one-day training course structured into 6 modules Target Audience Users with a solid understanding of Microsoft Office Access 2007, 2010 or 2013 who want to expand on their capabilities in a short space of time. Tsome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses. Class Size Maximum class size for Microsoft Access courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates. What happens on the day Dress code is smart casual.   Refreshments and a free buffet lunch will be provided, but please note that, as a training company who relies on caterers, we are unable to reliably provide for differing dietary requirements, so if you are in any doubt then please bring your own.   The timetable as a guide is as follows: 9:15: - Arrival time9:30: - Training starts11:00: - Mid-morning break1:00: - Lunch break (one hour)3:15: - Mid-afternoon break4:30: - Wrap up Note: break times can vary according to the needs of the training, and course duration for smaller class sizes can be shorter because fewer delegates have fewer questions! What you get You get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. Every delegate gets a Training Attendance Certificate.   Learning Objectives This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access 2007, 2010 and 2013 in order to increase their knowledge and productivity.

About this course

A good working knowledge of Access is required

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Access
  • Database training
  • SQL
  • Database
  • Access

Course programme

MODULE 1: Advanced Data Management

Learning outcomes:

A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database.

Topics covered:

  • Referential Integrity
  • Table Relationships
  • An Introduction to SQL
  • Modal Dialog Boxes

MODULE 2: Advanced Form Tasks

Learning outcomes:

Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface.

Topics covered:

  • Using Subforms
  • Creating a Navigation Form
  • Advanced Form Controls
  • Exporting a Form
  • Other Form Tasks

MODULE 3: Automating Reports

Learning outcomes:

Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form.

Topics covered:

  • Creating the Report Form
  • Building Query Criteria

MODULE 4: SQL and Microsoft Access

Learning outcomes:

Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.

Topics covered:

  • Understanding SQL
  • Using the SELECT Statement
  • Using Subqueries
  • Using SQL Joins

MODULE 5: Macros and Visual Basic for Applications (VBA)

Learning outcomes:

Using Macros and Visual Basic to create some advanced functionality to your Access Database.

Topics covered:

  • Macro Basics
  • More about Macros
  • Access and VBA
  • Building Advanced Procedures
  • Using VBA in a Database

MODULE 6: Finishing the Application

Learning outcomes:

Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password.

Topics covered:

  • Setting Start Up Options
  • Sharing/Splitting the Database
  • Creating an ACCDE
  • Encrypting the Database with a Password

Microsoft Access Advanced (2007, 2010 & 2013)

£ 245 + VAT