• Business

    Microsoft Access - Beginners

  • Attendance/Duration

    Delivery Method: Face to Face delivery

    Course Duration: 6 hours (1 day)

    Delivery Method: Online Delivery

    Course Duration: 6 hours total. 2 x 3 hours live interactive tutorial sessions

  • Cost

    For further information on course dates and prices please email businessgrowth@ayrshire.ac.uk

Whats Involved

Microsoft Access is an information management tool that helps you store information. It helps you analyse large amounts of information, and manage related data efficiently.

An Access database can be used for many purposes, for example, to maintain client information, track financial data, manage marketing and sales, or track production and inventory.

For the training sessions, a second screen would be beneficial to enable you to follow the trainer's screen while carrying out the exercises on the other, but is not mandatory.

On completion of this course you will be able to:

  • Create a simple database
  • Navigate the Access interface
  • Create tables to organise data
  • Work with fields
  • Create queries to manipulate the data
  • Use criteria in queries
  • Create parameter queries to ask for input
  • Create forms to allow users to enter data
  • Add a control to a form to allow users to select from a list
  • Create reports to present data in a readable format
  • Customise a report
  • Create a dashboard to navigate your database

Funding and Fees

For further information please email businessgrowth@ayrshire.ac.uk

Enquiries

For further information please email businessgrowth@ayrshire.ac.uk

Course Search

Or

Browse all courses Advanced search