Microsoft Access Automating and Enhancing your Database

Course

In Herts

Price on request

Description

  • Type

    Course

  • Location

    Herts

  • Duration

    2 Days

By the end of the course delegates will be able to: Create more advanced forms utilising some of the further features available within Access - utilising relationships, properties and custom controls. Apply simple customising to set how the database should open and what the user can see and access. Perform mathematical and logical analysis on data using expressions and calculations. Apply Access mechanisms to secure the database. Integrate Access data with the other applications in MS Office.

Facilities

Location

Start date

Herts (Hertfordshire)
See map
Cp House Business Centre Otterspool Way Watford, WD25 8HP

Start date

On request

About this course

Those attending this course should have attended the \'Introducing Database Creation\' course or have equivalent knowledge through their own usage of the product.

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

Course programme

This two day course is designed to explore the opportunities to enhance databases through advanced formatting, customising and automating procedures.

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

  • Create more advanced forms utilising some of the further features available within Access - utilising relationships, properties and custom controls.
  • Apply simple customising to set how the database should open and what the user can see and access.
  • Perform mathematical and logical analysis on data using expressions and calculations.
  • Apply Access mechanisms to secure the database.
  • Integrate Access data with the other applications in MS Office.
  • Create copies of a database enabling several people to work on the same database at the same time and from different locations.
  • Create more advanced reports from Access data.
  • Utilise built-in macro actions to automate common tasks.
  • Create databases with advanced relationships using links and joins and, using indexes, optimise their performance.
  • Create hyperlinks to quickly move to different objects in Access or to jump to different applications.
  • Create forms for use on a web page that are linked to a database.

Microsoft Access Automating and Enhancing your Database

Price on request