Information in this form comes from the Customers table. ![]() For example, the form shown here includes information drawn from several tables:ġ. You can then create queries, forms, and reports that display information from several tables at once. ![]() You do this by placing common fields in tables that are related, and by defining relationships between your tables. In this articleĪfter you have created a table for each subject in your database, you have to give Access a way to bring that information back together again when needed. To do this step correctly, though, you have to understand the relationships between your tables, and then specify these relationships in your database. You then provide Access with a way to bring the divided information back together - you do this by placing common fields in tables that are related. To achieve that goal, you divide your data into many subject-based tables so that each fact is represented only once. ![]() One of the goals of good database design is to remove data redundancy (duplicate data).
0 Comments
Leave a Reply. |