In this chapter, you will be introduced to database theory and willunderstand the difference between data and information. You willalso become familiar with the task of planning a database,learning how to structure a database to ensure speed and accuracy whenworking with data. Additionally, you will learn how to personalizeAccess 2019 by setting database options, and will be able to distinguishbetween database objects such as tables, queries, forms, and reports, aswell as learning how to switch between them.
You’ll learn how to organize your table data and properties to setprimary keys, thereby forming relationships between objects in adatabase. You will gain an understanding of the different relationshiptypes and when they should be applied, and will learn the rules forsetting up relationships between two or more tables in a database.
In this chapter, we’re going to cover the following main topics:
- Introduction to Access and the settings options
- Constructing tables and manipulating data
- Building relationships
- Defining the primary key, join type, and referential integrity