What does Microsoft Access actually do?

577 views

All I know is that it’s a “database management system”, and I don’t even know what that means! I have tried fooling around with Access and have gotten nowhere. Where do I start and what is the purpose of this?

In: 4

20 Answers

Anonymous 0 Comments

Imagine you have a box of toys. Each toy has a different name, color, and shape. Normally, if you were to dump all the toys into this box without organising them it would take a while to find a specific toy or a toy with a specific property.

Microsoft Access allows you to dump all the toys into the box and have them be organised in a way that you can immediately find a specific toy, or toy with specific properties/information attached to it.

The way we do this is with a table-like system. In the toy example, each row (we call these ‘records’) would be an instance of a toy, and each column (we call these ‘fields’) would be all the properties of the toy such as name, color and shape. In the real world, records are often customers or products, and field may be things like customer IDs, names, phone numbers etc. etc.

You are viewing 1 out of 20 answers, click here to view all answers.