One of the goals of good database design is to remove data redundancy or duplicate data. Each record includes a unique ID known as the primary key. The same fields of information are stored for each record in the table. In other words, the record includes all of the fields and their information about one unique item in the table. A record is a meaningful and consistent way to combine information about something. Each field includes some type of information relevant to the table you have created.Įach row is a record. For example, a field could be Last Name, or Product description. A field is a single piece of information. Tables have relationships to connect data without having to store it in multiple places. Tables make up the backbone of your database. Understanding Tables and Table Relationships Select an option under Filter By Group to show only those items. You can also filter the contents of the Navigation Pane.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |