Question

You're performing routine data maintenance on a table within an Access database. When should you execute the Save command?

A. Immediately after you add, edit or delete a record.
B. Periodically during a session.
C. Once at the end of a session.
D. As often as you feel necessary.
E. None of the above since Access automatically saves changes as they are made.

Answer 1

The Save command should be executed immediately after adding, editing, or deleting a record in an Access database.

Step-by-step explanation:

The correct answer is A. Immediately after you add, edit or delete a record.

When performing routine data maintenance on a table within an Access database, it's important to save changes as you make them. This ensures that the changes are stored and can be accessed later. Waiting until the end of a session or saving as often as you feel necessary can lead to data loss if the application crashes or if there is a power outage.

For example, let's say you add a new record to a table in Access. If you do not save the changes immediately after adding the record, the data will not be stored in the table. This means that if something were to happen before you save your changes, such as closing the program or a power outage, the new record would be lost.