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.
Latest Answers