Access 2021

As a user or developer, you will learn how to design databases in Access 2021 in a fundamentally correct way and build them up step by step in this book! After a comprehensive introduction to good database design, it familiarises you with the creation of tables, queries, forms and reports. You will also learn all the important advanced techniques: From query optimisation and VBA or DAO programming to SQL server connectivity and desktop application development, there is simply everything for you!

From the contents:

Access basics: installation and configuration, relational databases, relationships
Database design: normalisation, naming conventions, referential integrity, common errors, best practice
Creating and modifying tables; field data types, creating relationships, primary and foreign keys, alternate keys and indexes
Creating queries incl. workshops
Data connections, importing and exporting data, integrating SharePoint lists; server databases
Learning SQL: querying and evaluating data, sub-queries, action queries, union and SQL pass-through queries
Creating forms: Form types, design, controls, layout, views, working with multiple forms.
Clear reports: design, views, sections, labels and multi-column reports
Programming with macros and VBA: enriching forms, responding to events, development environment, processing data in memory, case distinctions and loops, modules, class modules, error handling
DAO class library: creating and executing action queries, processing data sets, transactions
Creating application programs: Desktop databases.