Share this article...

Microsoft Access TrainingMicrosoft Access is a powerful way to organise your information

You use it to record, view and print data. For example Record Collection, Recipes, Customer Details, Invoices, Orders, Stock Control etc.

Easykey offers 1-to-1 or Group training to help you get the most out of Microsoft Access

send
Send Your Access Training Enquiry

What is a 'Relational Database'?

A Relational Database is created by linking two or more tables and relating them to each other so you avoid having to type the same information in more than once. So if you are creating a new invoice for a customer you have already entered you don't have to type all the customer details again.

What are Queries?

Queries are used to filter and sort information from one or more tables. So you could list all the unpaid invoices only showing the name of the customer more than 28 days old sorted by the oldest first.

What are Forms?

You design Forms to layout information based on tables or queries in the most useful way to view on your screen. Well designed forms ensure that when you input new information it is as easy as possible and prevents people from entering incorrectly (e.g. A date in the future for a Date of Birth)

What are Reports?

This is where you design what Reports Microsoft Access prints including, Layout, Fonts, Colours and Charts.

What about Macros and Modules?

The secret of a well-designed database is when you get it to intelligently 'think' for you. You can use Microsoft Access Macros to remember a series of actions and conditions and assign it to a button with one click. Modules can be designed to embed preset calculations into your code - like return a person's current age in Years and Months based on their date of birth and the current date.

Can more than one person use the database at the same time?

Unlike Excel documents Microsoft Access is designed so you can network it. This is achieved by splitting the database into Front End (for each computer) and Back End (typically storing all the information in tables on a server)

Microsoft Access Training

Easykey offers 1-to-1 or Group training to help you get the most out of Microsoft Access. Click the link below to complete your pre-training checklist where you can design your own tailored course indicating exactly what you would like to learn.

checklist
Send Your Pre-training Checklist

Share this article...
Was this article helpful? Add your comment below...

Flexible Training

Denis Computer Training
What Do You Prefer?

  • On Your Computer?
  • At your place? (Essex, Herts)
  • At Easykey, Harlow?

Send Your Training Enquiry



Send a Training Enquiry

Design Your Access Training

checklist

Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 158

    Suzanne has awarded Denis Virtual Choccy because "You will need it after China and to ward off...

  • Thanks No. 157

    Marina has awarded Dominic a Virtual Beer because "I want to thank you for your...

  • Thanks No. 156

    John has awarded Denis Virtual Cake because "he sorted out my...

  • Thanks No. 155

    Ricky has awarded Dominic a...

This website uses cookies to help us improve your experience.
By using our website you accept our Privacy Policy and use of cookies.