Question 1

In Datasheet view, the table displays its data in rows and columns in a ____.

Accepted Answer

A)   datasheet
B)   spreadsheet
C)   report
D)   query programE) None of the above
F) C) and D)

Question 2

FIGURE AC 1-1  Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

Accepted Answer

A)   field
B)   field value
C)   field name
D)   field selectorE) C) and D)
F) B) and C)

Question 3

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

Accepted Answer

A)   prompt you to save your changes
B)   automatically save your changes
C)   give you an error message
D)   close the tableE) None of the above
F) All of the above

Question 4

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

Accepted Answer

A)   Table
B)   Query
C)   Form
D)   ReportE) None of the above
F) All of the above

Question 5

Before printing a datasheet, you should view it in ____ so you can check the print settings.

Accepted Answer

A)   Print Preview
B)   Datasheet view
C)   black and white
D)   Zoom modeE) None of the above
F) B) and C)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

By default, the rows in a datasheet are displayed with ____.

Accepted Answer

A)   pastel colors
B)   rainbow colors
C)   alternating light and dark background colors
D)   a white backgroundE) A) and B)
F) None of the above

Question 8

Access combines compacting and repairing into one step.

Accepted Answer

A) True 
 B)False

Question 9

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.

Accepted Answer

A)   Datasheet view
B)   Column view
C)   Edit view
D)   Freeze viewE) B) and D)
F) B) and C)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

When you are navigating in Datasheet view, pressing Shift+Tab ____.

Accepted Answer

A)   moves to the next field in the current record
B)   moves to the first field in the current record
C)   moves to the previous field in the current record
D)   moves to the last field in the last recordE) B) and C)
F) A) and D)

Question 13

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

Accepted Answer

A)   All Programs
B)   Microsoft Programs
C)   Open Database
D)   Navigation PaneE) A) and C)
F) None of the above

Question 14

A database management system does not need to be computerized.

Accepted Answer

A) True 
 B)False

Question 15

When resizing a column, selecting ____ automatically resizes the column to the best width for the data contained in the column.

Accepted Answer

A)   best fit
B)   best column
C)   best data
D)   best selectorE) B) and D)
F) A) and C)

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The ____ object is similar to a macro, but allows more complex programming of database operations.

Accepted Answer

A)   Table
B)   Module
C)   Query
D)   ReportE) A) and B)
F) A) and C)

Question 18

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

Accepted Answer

A)   only if she saves them
B)   automatically by Access
C)   with a generic name
D)   none of the aboveE) A) and B)
F) C) and D)

Question 19

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

Accepted Answer

The answer of A(n) ____________________ is used to search for...

Question 20

A(n) ____________________ is a collection of objects.

Accepted Answer

The answer of A(n) ____________________ is a collection of objects....

Exam 1: Access Lesson 1: Microsoft Access Basics

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

Correct AnswerverifiedShow Answer

When you are navigating in Datasheet view, pressing Shift+Tab ____.

Correct AnswerverifiedShow Answer

A database management system does not need to be computerized.

Correct AnswerverifiedShow Answer

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

Correct AnswerverifiedShow Answer

By default, the rows in a datasheet are displayed with ____.

Correct AnswerverifiedShow Answer

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.

Correct AnswerverifiedShow Answer

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

Correct AnswerverifiedShow Answer

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

Correct AnswerverifiedShow Answer

In Datasheet view, the table displays its data in rows and columns in a ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Access combines compacting and repairing into one step.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____ object is similar to a macro, but allows more complex programming of database operations.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

FIGURE AC 1-1 Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

Correct AnswerverifiedShow Answer

A(n) ____________________ is a collection of objects.

Correct AnswerverifiedShow Answer

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

Correct AnswerverifiedShow Answer

When resizing a column, selecting ____ automatically resizes the column to the best width for the data contained in the column.

Correct AnswerverifiedShow Answer

Before printing a datasheet, you should view it in ____ so you can check the print settings.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified