How to Add or Remove Records in Microsoft Access Tables and Queries
Question details
The user needs to know the correct procedure for adding and deleting information in an existing Microsoft Access database, and wants to verify if modifications made to tables will automatically update their queries.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user is updating an existing database and needs to modify table data securely without breaking queries.
- Observed behavior
- The user aims to insert new records and delete unneeded ones while ensuring that SELECT queries display the accurate, updated information.
Always create a backup copy of your database before modifying or deleting records, as removing data can permanently impact related tables and drastically alter the results of your queries.
Add or Remove Records Using Database Forms
Using built-in forms is the safest and most standard method for modifying records, as forms are designed to protect database integrity and structure.
In a well-designed Access database, users interact with the data through the interface layer (forms) rather than editing the raw data layer (tables) directly. This prevents accidental changes to essential relationships.
Launch your Access database and double-click the appropriate Form from the navigation pane on the left-hand side.
Click the 'New (blank) record' button, typically indicated by a yellow asterisk at the bottom navigation bar of the form. Type in your new information to save the record.
Navigate to the record you want to remove. Click the 'Delete' button located on the Home tab of the ribbon, or use the form's built-in delete button if one is provided.
Modify Records Directly in Table Datasheet View
If your database does not utilize forms, you can add or remove data directly within the table's datasheet view, though this should be done with caution.
Looking for a Lightweight Alternative to Microsoft Office?
While WPS Office does not include a direct database application like Access, it offers a powerful, free alternative to Microsoft Word, Excel, and PowerPoint. Enjoy seamless format compatibility, a lightweight design, and a familiar user interface without heavy subscription costs.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install the Suite: Run the downloaded installer file and follow the quick on-screen instructions to set up the software.
- 3. Start Creating: Open WPS Writer, Spreadsheet, or Presentation to easily manage your daily documents.
Frequently Asked Questions
Do changes made in tables automatically appear in queries?
Yes. Tables store the foundational data, while SELECT queries filter and display results from those tables. If you add, edit, or delete a record in a table, the query automatically reflects that change when refreshed, provided the new record fits the query's sorting criteria.
Can I add or remove records directly from a SELECT query?
While sometimes technically possible, it is not recommended to add or remove records directly from a SELECT query. It is significantly safer to modify your data using the designated database forms or by updating the underlying base tables directly.
What is the difference between a SELECT query and an action query?
A SELECT query is simply used to display, filter, and review data without altering it. In contrast, action queries (such as INSERT, UPDATE, or DELETE) actively modify the database by adding, changing, or erasing multiple records at once based on predefined rules.
