Skip to Content

Bookings and Enquiries: 0800 077 36 46

Microsoft Access Advanced Forms and Interfaces Course

Microsoft Access Advanced Forms and Interfaces Course

1 Day Crawley £220.00+VAT
Available Date(s):

Is this course right for me?

Our Access Advanced Forms and Interfaces course demonstrates how Access forms and reports provide a powerful interface that can be used to perform multiple tasks.

This course is aimed at users who can design and build tables and queries for a relational database and who wish to create a professional-looking interface to make it easy for others to use their database application. You should already be able to design and use Access databases and be able to build queries.

Training course objectives:

  • 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

Versions Available

2003, 2007, 2010

Related Training Courses in Our Range

Building search forms

  • 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

Forms With Interactive Controls

  • 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

Forms Within Forms

  • Using The Form Wizard
  • Adding A sub form
  • Creating a sub form using “drag and drop”
  • Changing form and sub form properties
  • Creating a linked form
  • Checking Parent / Child Properties

Tab Controls On Forms

  • Creating a Multi-table Record Source
  • Adding a Tab Control
  • Changing properties
  • Captions and Pages

Creating A Navigation Switchboard

  • Starting the Switchboard Manager
  • Creating Switchboard Pages
  • Switchboard properties
  • Customising the switchboard
  • Add Commands to Switchboard Pages

Call our expert Learning and Development team today on
0800 077 36 46 for more details about the training options available to
you or to book your course.