Question 1

Of all the database objects, a table provides the most formatting, layout, and summary options.

Accepted Answer

Reports and forms provide the most formatting, layout, and summary options in a database. Tables provide the structure for organizing and storing data, but do not offer extensive formatting or summarization capabilities.

Question 2

You can create a table in Table Datasheet view or Table Design view.

Accepted Answer

You can create a table in both Table Datasheet view and Table Design view in Microsoft Access.

Question 3

When you enter a record in a table, you are working in navigation mode.

Accepted Answer

When you enter a record in a table, you are working in data entry mode, not navigation mode. Navigation mode is used to move around the table and make changes to existing records.

Question 4

Press ESC to remove editing changes you made to the previous record.

Accepted Answer

The answer of Press ESC to remove editing changes you...

Question 5

Use the New (blank) record button to move the focus to the first record in a table.

Accepted Answer

The answer of Use the New (blank) record button to...

Question 6

After you create a table, you must save the entire database so you do not lose the new table.

Accepted Answer

Creating a table within a database management system (DBMS) typically auto-saves the new table structure into the database without requiring a manual save of the entire database.

Question 7

Compacting a database has the same result as backing up a database.

Accepted Answer

Compacting a database reduces its size by removing unnecessary space, while backing up a database creates a copy of its data for safekeeping. While both maintenance tasks are important, they serve different purposes and should not be confused as interchangeable.

Question 8

Which Access object contains all of the data in the database?
A) form
B) macro
C) table
D) query

Accepted Answer

The table is the object in Access that contains all of the data in the database. Forms, macros, and queries all manipulate the data in the table, but the table is the fundamental object that holds the information.

Question 9

Before you close a database, you must save any changes you made to the data.

Accepted Answer

The answer of Before you close a database, you must...

Question 10

To display the data in a table, you open the table in Table Design view.

Accepted Answer

To display the data in a table, you would typically view it in Datasheet view, not Table Design view. Table Design view is used to create or modify the structure of the table itself.

Question 11

A field with the Currency data type contains values such as quantities, measurements, and scores.

Accepted Answer

The answer of A field with the Currency data type...

Question 12

Before you can rename a field, you must change its data type.

Accepted Answer

You do not need to change the data type of a field in order to rename it. Renaming a field changes its name only, and does not affect its data type or any of the data stored in that field.

Question 13

To select fields and records to answer a question, you most likely create a form object.

Accepted Answer

To select fields and records to answer a question, you most likely use queries. Forms are used to create user interfaces for data entry and viewing.

Question 14

To navigate to a record in a table, switch to Table Design view.

Accepted Answer

To navigate to a record in a table, switch to Datasheet view, not Table Design view. Table Design view is used to modify the structure of the table, such as adding or removing columns.

Question 15

A new blank desktop database includes one table named Table1.

Accepted Answer

A new blank desktop database includes one table named Table1 by default.

Question 16

When you start Access, the first screen that appears is one showing a blank database.

Accepted Answer

When you start Access, the first screen that appears is the Access start screen, which offers various options such as opening a recent database, creating a new database from a template, or creating a blank database.

Question 17

Compacting a database rearranges the data and objects in a database to decrease its file size.

Accepted Answer

Compacting a database removes unused space and rearranges data and objects to improve its performance and decrease its file size.

Question 18

To learn more about a data type, you can enter the name of the data type in the Tell Me box.

Accepted Answer

This statement is true. When you enter the name of a data type in the Tell Me box, you will be directed to more information about that data type.

Question 19

After starting Access, which of the following is the fastest way to open a database you worked on yesterday?
A) Click Open Other Files, click Browse, navigate to and click the database file, and then click Open.
B) Click the database you want to open in the list of recent databases.
C) Click Blank database and then enter a name for the new database.
D) Right-click Blank database and then click Open.

Accepted Answer

The fastest way to open a database you worked on yesterday is to click on the database you want to open in the list of recent databases. This eliminates the need to navigate through folders or create a new database.

Question 20

When you add a field to a table in Table Design view, the _____ property is optional.
A) Data Type
B) Description
C) Field Name
D) View Type

Accepted Answer

The Description property is optional when adding a field to a table in Table Design view. The Data Type and Field Name properties are required, while the View Type property is not relevant in this context.

Quiz 1: Access 2019