Access Advanced Forms and Interfaces Training

Dates
Duration
1 Day
Location
Crawley
Price
£220.00+VAT

What is the course about?

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.

Why should I learn with Thales L&D?

There are many reasons why you should learn with us but here are just a few:

  • Our trainers are passionate, credible and experts in their field
  • We’ll support you for 3 months’ after your course in case you need help
  • We deliver across the full range of expertise levels and software versions
  • Our learning centre is designed to give you the perfect environment to enhance your knowledge and skills

More information:

If you’d like to check availability or receive a PDF of our course spec, just drop us an email and we’ll send the information straight over. Don’t forget to include all your contact details and the course you are interested in.

What you’ll learn

By the end of the programme you’ll 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

What’s covered

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 subform using “drag and drop”
  • Changing form and subform 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

Prefer a bespoke course at a venue and date of your choice?

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

Customer Testimonials

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

Pricing Analyst, Total Gas and Power

Paul Terry

Course Leader

Enhance Magazine

Issue 5 out now!

READ

HAVE A QUESTION?

Talk to us about how training can enhance your business















RELEVANT BLOG POSTS

Enhance your potential

KEEP UPDATED WITH THALES L&D:

Subscribe

Blog

May 06, 2015

7 Engineering Wonders of the World - Infographic

In the relatively short space of time that people have populated the world, we have gone from living in caves and breaking into our dinner with a sharpened stone to creating things so vast and powerful they would make our stone-wielding ancestors’ jaws drop.Engineering – and with it: effective p

Thales Blog >

Tweets

Visit us on Twitter >

Group

Apprentices are in high demand – research by Barclays shows that £4.4bn would be injected into the UK economy if more businesses employed them. Thales UK is a proud member of The 5% Club which is focused on creating momentum behind the recruitment of apprentices and graduates into the workforce.
As part of Thales UK’s commitment to nurturing raw 

Join the discussion >

Events

Customer Days 2015

31st March - Intelligent Outsourcing, Programme Management & Organisational Health

12th June - A focus on Sales in a complex environment. Content TBC

4th September - Content TBC

4th December - Content TBC -

To book your space click here

 

More events >