Access Advanced Forms and Interfaces Training

Book this course

Course description

When used to their full potential, the forms and reports functions within Access can provide a powerful, professional-looking interface that can be used to perform multiple tasks, and make it easier for others to use your database application.

We cover a variety of different form types – including search forms, forms with interactive controls, and forms within forms – and show you how to create and manage an effective navigation switchboard.

Is it right for me?

If you’re already competent in designing and using Access databases, and able to build queries, this advanced Access training course will enhance your current skill level.

What will I get out of it?

By the end of the course you will be able to:


  • Create forms for interactive searching and display of search results
  • Build simplified forms and use forms within forms
  • Create interactive combo and list controls on forms
  • Use macros and simple Visual Basic to make forms interactive
  • Build a navigation system including custom menus and toolbars

I found everything on the course to be helpful so don't think it could be improved further

Pricing Analyst, Total Gas and Power

What does it cover?

  • Creating an unbound form
  • Using text boxes and combos
  • Adding a command button
  • Finding a record using a combo
  • Finding a set of records using a combo
  • Showing results in a new form
  • Changing form properties
  • Changing control types
  • Editing combo properties
  • Interactive combo controls
  • Form controls that appear on command
  • Creating inter-dependent controls
  • Understanding control and form events
  • Applying macro and Visual Basic commands to make it work
  • Hiding and showing a control
  • Using the form wizard
  • Adding a sub form
  • Creating a subform using “drag and drop”
  • Changing form and subform properties
  • Creating a linked form
  • Checking parent/child properties
  • Creating a multi-table record source
  • Adding a tab control
  • Changing properties
  • Captions and pages
  • Starting the switchboard manager
  • Creating switchboard pages
  • Switchboard properties
  • Customising the switchboard
  • Add commands to switchboard pages

Book this course

Other recommended courses

Show more courses +

Course leader

Paul Terry

L&D Consultant, IT Solutions

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine