Database design basics - Microsoft Support
A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense.
Create a new database - Microsoft Support
It explains how to create a desktop database by using a template, and how to build a database from scratch by creating your own tables, forms, reports, and other database objects. It also explains some techniques that you can use to get existing data into your new database.
Access specifications - Microsoft Support
This article has information about the limits of Microsoft Access database files and objects. In most cases when a database exceeds the following limits it might be an indication of a design issue.
Create a database in Access - Microsoft Support
With Access, you can build a database without writing code or being a database expert. Well-designed templates help you quickly build databases. Easily find just the data you want with queries.
Featured Access templates - Microsoft Support
Analyze and store large amounts of information, and manage data more efficiently with Access database templates available for download.
Download and install Microsoft 365 Access Runtime
The Microsoft 365 Access Runtime includes the Access Database Engine (ADE) which can be used to facilitate transfer of data between Microsoft Office System files and non-Microsoft Office applications through (OLEDB, ODBC, DAO) interfaces.
Deploy an Access application - Microsoft Support
Learn how to deploy an Access database so that other people can use the application.
Access SQL: WHERE clause - Microsoft Support
To combine data from two data sources based on values in fields that have different data types, you create a WHERE clause that uses one field as a criterion for the other field, by using the LIKE keyword.
Create a form in Access - Microsoft Support
If your Access desktop database is going to be used by multiple users, well-designed forms is essential for efficiency and data entry accuracy. There are several ways of creating a form in an Access desktop database and this article points you to some of the common ways.
Document and print your database design - Microsoft Support
Microsoft Access can help you prepare printed documentation of your database's design, which you can use for offline reference and planning. Specifically, Access can help you print table relationships as depicted in the Relationship window, and can help you print the design characteristics of database objects, such as object properties.