Decide whether to create a desktop database or an Access web app
To decide between an Access web app or a desktop database, consider the following: There are three important design considerations to consider first. You use Microsoft 365 with SharePoint …
Compact and repair a database - Microsoft Support
This overview explains how using the Compact and Repair Database command can help prevent and correct the following problems that sometimes affect a database: files growing larger with …
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 …
Basic tasks for an Access desktop database - Microsoft Support
Let’s take a walk through the paths you can take to create an Access desktop database, add data to it, and then learn about next steps towards customizing and using your new database. …
Normalize your data using the Table Analyzer - Microsoft Support
If your Microsoft Access database has a table that contains repeating information in one or more fields, use the Table Analyzer to split the data into related tables so that you can store data …
Learn the structure of an Access database - Microsoft Support
Access provides several tools that you can use to familiarize yourself with the structure of a particular database. This article also explains how, when, and why you use each tool. A …
Deploy an Access application - Microsoft Support
Access provides a feature-rich platform for developing database applications. A database application is a computer program that provides both a way to store and manage data and a …
Guide to table relationships - Microsoft Support
Access uses table relationships to decide how to join tables when you need to use them in a database object. There are several reasons why you should create table relationships before …
Use the Performance Analyzer to optimize an Access database
You can use the Performance Analyzer to optimize the performance of a Microsoft Access desktop database. The Performance Analyzer is not available in an Access project or in …
Open an existing database - Microsoft Support
This topic describes the different methods you can use to open existing Access databases. You can open databases from Windows Explorer or from within Access itself. You can open …
Document and print your database design - Microsoft Support
You can use the Database Documenter to print the design characteristics of database objects. Open the database that you want to document. On the Database Tools tab, in the Analyze …
- Some results have been removed