DVANA
Menu

Course Overview

Would you like to boost your Microsoft Access 2016 skills? Come along to this fabulous Access course - it’s packed full of Tips & Tricks for Access!

You’ll discover some amazing new ways of working that will allow you to fly through capturing and processing data!

Who is this course aimed at?

This course is intended for those who are already using Access and would like to expand their knowledge and be able to work super efficiently with Access.

What does the course offer me?

You’ll gain the skills and practical knowledge to use Access more effectively, to get your work done faster and will less hassle. These are skills for life!

What do I take away?

Practical experience with the different features we cover in Access and the tips and hints we go through in the class.

Course Outline

Each delegate receives a complete set of high quality notes already printed.

1 - Structuring Existing Data

  • Analyse tables
  • Create a junction table
  • Improve table structure

2 - Writing Advanced Queries

  • Create sub-queries
  • Create unmatched and duplicate queries
  • Group and summarise records using criteria
  • Summarise data using crosstab query
  • Create a PivotTable and PivotChart

3 - Simplifying Tasks with Macros

  • Create a Macro
  • Attach a Macro
  • Restrict Records using Conditions
  • Validate data using a Macro
  • Automate data entry using a Macro

4 - Making Effective use of Forms

  • Display a calendar on a form
  • Organise information with Tab pages
  • Display a Summary of Data in a form

5 - Making Reports More Effective

  • Include a Chart in a Report
  • Print data in columns
  • Cancel Printing of a blank report
  • Create a Report snapshot

6 - Maintaining an Access Database

  • Link tables to external data sources
  • Manage a database
  • Determine object dependency
  • Document a database
  • Analyse the performance of a database

Throughout the course we will cover the jargon and correct terms, so you can use them efficiently, as we discuss your individual questions.

Course

Access 2016 - Productivity

Book Now

Class Size

To give you the best learning outcome, we try to limit classes as follows:

  • Min: 4
  • Max: 12

When a class is too large, we split it into two smaller classes. This maximizes your learning, with your co-workers and colleagues.

Equipment

We make the general assumption that you’ll provide your own computer, laptop etc.

If you need to use one of our computers, please mention it when you book, as there is a nominal extra charge.

We supply everything else, including high quality printed materials.

Duration

This is a one day course. Delivered either on your site or at an off-site location.

Typically, we start at about 09:30 and work through the day until finished.

Adequate time is allowed for breaks, lunch, questions and individual tuition.


Please feel free to share this around your social networks.

Need a special course? Contact us.

We have a wide range of ready-made courses. However, if you need something extra, we are happy to devise a course that meets your needs, contact us today.