For more information, see Open an existing Access database. Tell users how long they must avoid using the database. If you run compact and repair operations on a regular basis, keep a record of how long it takes.

When you design a form template that is based on an Access database, InfoPath creates a main data source with groups that contain query fields and data fields, and also creates a query data connection as the main data connection for the form template. These fields and groups correspond to the way that data is stored in the tables in the database.

The navigation pane in Access displays database objects and is the primary means by which you view and access all your database objects.

Import a database object from another Access database into your current database. Open the database that you want to import objects into, if it is not already open.

Split an Access database into front-end and back-end components to improve performance and safely share data with other users.

You can use the Performance Analyzer to optimize the performance of a Microsoft Access desktop database.

Access provides a number of ways to copy an object such as a table or form from one database to another. Copying and pasting an object is easiest, but exporting an object offers you more options.

Access guides you through creating a data collection form and sending the form in an e-mail message. When your e-mail recipients return the completed forms, you can choose to have the collected data automatically processed and stored in a specified Access database.

Use the Access Student database template to keep track of information about your students, including emergency contacts, medical information, and information about their guardians. You can also search and filter students, track student attendance, show or hide columns, and map student addresses. Want to watch a video about using this template?

For more information, see Apply a filter to view select records in an Access database. Top of Page. Delete a record. The deletion process is fairly simple, except when the record is related to other data and resides on the "one" side of a one-to-many relationship. To maintain data integrity, by default, Access does not let you to delete related ...