Case 22-1 Dana has just been hired to create and maintain a database for a local sports organization. The organization has several different sports with many teams and divisions. She is creating the database in Design view. If Dana doesn't save the table in Design view and switches to Datasheet view, what will happen?
A) She will lose all the data in the table.
B) She will be prompted to save the table.
C) Nothing. Access saves automatically in Design view.
D) The database will be closed and all data will be lost.

Question

Quizplus · Accepted Answer

When switching from Design view to Datasheet view in Access, the user is prompted to save any changes made in Design view before viewing the data in Datasheet view. Therefore, if Dana doesn't save the table in Design view before switching to Datasheet view, she will be prompted to do so.

Case 22-1 Dana Has Just Been Hired to Create and Maintain