6. Break the list in Figure 1-31 into tables, each with a single theme. Create you think necessary. 7. Show how the tables you created for question 1.12 solve the three problem identified in this chapter.
Access organizes your information into tables: lists of rows and columns reminiscent of an accountant’s pad or a spreadsheet. In a simple database, you might have only one table. For most databases you will need more than one. For example, you might have a table that stores information about products, another table that stores information about orders, and another table with information about customers.
Image depicting three tables in datasheets
Each row is more correctly called a record, and each column, a field. A record is a meaningful and consistent way to combine information about something. A field is a single item of information — an item type that appears in every record. In the Products table, for instance, each row or record would hold information about one product. Each column or field holds some type of information about that product, such as its name.
Step by step
Solved in 2 steps with 1 images