Question 1

Access opens in ____ view.
A) Design
B) Datasheet
C) Layout
D) Backstage

Accepted Answer

D

Question 2

A database management system does not need to be computerized.

Accepted Answer

A database management system can be manually managed without the use of a computer. However, it is much more efficient and practical to use a computerized system in today's digital age.

Question 3

A computerized DBMS is ____ than using file folders.
A) more flexible
B) more accurate
C) much faster
D) all of the above

Accepted Answer

A computerized DBMS is more flexible, more accurate, and much faster than using file folders. With a DBMS, data can be easily accessed and updated, queries can be run to generate reports, and the system can enforce data integrity constraints to ensure accuracy. Additionally, searching for specific information in a DBMS is much faster than manually searching through paper files.

Question 4

To freeze columns, select the field selectors for the columns that you want to freeze, click the More button in the Layout group on the File tab, and then click Freeze Fields.

Accepted Answer

To freeze columns in Excel, you typically select the column to the right of the column(s) you want to freeze, go to the View tab, and then click on Freeze Panes in the Window group. There is no "Freeze Fields" option under the File tab.

Question 5

When you open a database, Access assumes that the database might contain something that could damage your computer.

Accepted Answer

Access has built-in security features to protect your computer from potentially harmful content, so it assumes that caution is necessary when opening a database.

Question 6

When you want to display more of the open object, you can close the Navigation Pane by clicking the Shutter Bar Open/Close Button at the top of the Navigation Pane.

Accepted Answer

Closing the Navigation Pane will allow more space to display the open object.

Question 7

A record is an incomplete set of data.

Accepted Answer

A record is a complete set of data that represents a single unit or entity. It includes all relevant information about that entity, such as name, address, age, and other attributes. Incomplete sets of data are often referred to as a "partial record" or "incomplete record."

Question 8

After opening a database, the Navigation Pane opens on the left side of the screen.

Accepted Answer

After opening a database in Microsoft Access, the Navigation Pane will automatically open on the left side of the screen by default.

Question 9

A database is a collection of ____.
A) data
B) fields
C) numbers
D) objects

Accepted Answer

The answer of A database is a collection of ____.
A)...

Question 10

Access combines compacting and repairing into one step.

Accepted Answer

In Access, compacting and repairing can be done together as one step.

Question 11

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

Accepted Answer

Backing up a database copies the current state of the database to a separate location, but it does not rearrange how the database is stored or optimize its performance. Those actions would require additional database management tasks.

Question 12

____ is a program known as a database management system (DBMS).
A) Excel
B) PowerPoint
C) Word
D) Access

Accepted Answer

Access is a program specifically designed for managing databases, making it a database management system (DBMS). Excel, PowerPoint, and Word are not DBMS programs.

Question 13

To make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet.

Accepted Answer

Navigation buttons in Access are located at the bottom of the datasheet view or form view, not on the Ribbon. The Ribbon contains tabs and commands for performing various actions, but navigation through records is done via the navigation bar at the bottom.

Question 14

Best of class automatically resizes the column to the best width for the data contained in the column.

Accepted Answer

"Best of class" is a term that typically refers to the top-performing product or service in a particular category, not a feature that automatically resizes the column width in data tables or spreadsheets. The feature that adjusts column width to fit the data is often referred to as "AutoFit" or a similar term, depending on the software.

Question 15

The database object called query stores all the data in the database in a format called a datasheet.

Accepted Answer

The statement is incorrect. The query does not store all the data in the database, rather it is used to retrieve specific information from the database. Additionally, a query does not store data in a datasheet format, rather it returns data in a datasheet format as a result of the query.

Question 16

To start Access, click the Start button on the taskbar, click ____, click Microsoft Office, and then click Microsoft Access 2010.
A) All Programs
B) Microsoft Programs
C) Open Database
D) Navigation Pane

Accepted Answer

To access Microsoft Access, you must first click on the Start button on the taskbar. From there, you must click on "All Programs" to access the list of programs installed on your computer. Once you have located Microsoft Office, you can then find and open Microsoft Access 2010.

Question 17

After you delete a record, you can use the Undo command to restore it.

Accepted Answer

Once a record is deleted, it cannot be restored using the Undo command; you would need to use a backup or a data recovery method to restore it.

Question 18

Access is a DBBS program.

Accepted Answer

Access is a DBMS (Database Management System) program, not DBBS.

Question 19

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

Accepted Answer

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

Question 20

The database object called Macro displays data from one or more tables or queries in a format that might be similar in appearance to a paper form.

Accepted Answer

A Macro in database systems, particularly in Microsoft Access, is a tool that automates tasks and operations, not an object for displaying data. Forms or Reports are used for displaying data in a structured format.

Quiz 1: Microsoft Access Basics

Access opens in ____ view.

A database management system does not need to be computerized.

A computerized DBMS is ____ than using file folders.

To freeze columns, select the field selectors for the columns that you want to freeze, click the More button in the Layout group on the File tab, and then click Freeze Fields.

When you open a database, Access assumes that the database might contain something that could damage your computer.

When you want to display more of the open object, you can close the Navigation Pane by clicking the Shutter Bar Open/Close Button at the top of the Navigation Pane.

A record is an incomplete set of data.

After opening a database, the Navigation Pane opens on the left side of the screen.

A database is a collection of ____.

Access combines compacting and repairing into one step.

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

____ is a program known as a database management system (DBMS) .

To make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet.

Best of class automatically resizes the column to the best width for the data contained in the column.

The database object called query stores all the data in the database in a format called a datasheet.

To start Access, click the Start button on the taskbar, click ____, click Microsoft Office, and then click Microsoft Access 2010.

After you delete a record, you can use the Undo command to restore it.

Access is a DBBS program.

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

The database object called Macro displays data from one or more tables or queries in a format that might be similar in appearance to a paper form.