In this chapter, you have been introduced to the Access 2019 environment and have gained the required theoretical background to be able to make informed design decisions when planning a new database. You have learned about the different objects that make up a database and how they fit together. You should now be confident enough to create a database and add tables using different views, set up fields and data types, and create relationships confidently using primary keys within tables. You also possess theoretical knowledge about referential integrity and cascading updates.
The next chapter will concentrate on building forms and report design, where you will be entering data and using the relevant formatting tools and learning about the different views when working with both forms and reports. You will learn to modify report headers and footers and manipulate report controls...