In this chapter, you will be introduced to database theory and will understand the difference between data and information. You will also become familiar with the task of planning a database, learning how to structure a database to ensure speed and accuracy when working with data. Additionally, you will learn how to personalize Access 2019 by setting database options, and will be able to distinguish between database objects such as tables, queries, forms, and reports, as well as learning how to switch between them.
You'll learn how to organize your table data and properties to set primary keys, thereby forming relationships between objects in a database. You will gain an understanding of the different relationship types and when they should be applied, and will learn the rules for setting up relationships between two or more...