Question 1

In the figure above, use item number 1 to:
A) Create a database from a template
B) Open an existing database
C) Search Microsoft online templates
D) Exit Access

Accepted Answer

B

Question 2

The [F2] key switches between Edit and Navigation modes.

Accepted Answer

The [F2] key is used to toggle between Edit and Navigation modes in various software programs such as Microsoft Excel and Notepad++.

Question 3

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Accepted Answer

In most database systems, you can resize the width of a field in a datasheet view after it has been created and named.

Question 4

The Navigation buttons on a datasheet display the total number of fields in the datasheet.

Accepted Answer

The Navigation buttons on a datasheet display the total number of records, not fields.

Question 5

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

The answer of An Access database is limited to a...

Question 6

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

AutoNumber fields in Access generate a unique value for each record automatically.

Question 7

You can move datasheet columns by dragging the field name left or right.

Accepted Answer

In many spreadsheet applications, you can rearrange columns by clicking and dragging the column header to a new position.

Question 8

This Access object provides an easy-to-use data entry screen.
A) Macro
B) Form
C) Table
D) Module

Accepted Answer

A form is an Access object that provides an easy-to-use data entry screen.

Question 9

Field names appear in the top row of a datasheet.

Accepted Answer

Field names are typically displayed in the top row of a datasheet to label the columns and indicate the type of data each column contains.

Question 10

Tables contain all of the data in the database.

Accepted Answer

The answer of Tables contain all of the data in...

Question 11

More than one person can be entering, updating, and using an Access database at the same time.

Accepted Answer

Access allows for multiple users to simultaneously access and make changes to the same database, although proper precautions should be taken to avoid data conflicts and corruption.

Question 12

Pressing [Ctrl][;] will insert the current date in a Date field.

Accepted Answer

pressing [Ctrl][;] will insert the current date in a Date field.

Question 13

Field properties change depending on the data type of the field.

Accepted Answer

Field properties such as size, format, and input mask can change depending on the data type of the field. For example, a text field may have a maximum length property, while a number field may have a decimal places property.

Question 14

Which of the following is NOT a way to open Access?
A) From the Start menu
B) From Internet Explorer
C) From a pinned program on the taskbar
D) From a shortcut on the desktop

Accepted Answer

Access cannot be opened directly from Internet Explorer as it is a web browser, not a method to launch applications like Access.

Question 15

Press [Esc] once to undo a change to the current field.

Accepted Answer

Pressing [Esc] once will undo the last change made to the current field.

Question 16

"Focus" refers to which data you would edit if you started typing.

Accepted Answer

"Focus" refers to the area where the user's keyboard input is actively being entered and edited, hence it refers to the data that the user would edit if they typed something.

Question 17

Which is NOT true about Access?
A) It can be used to arrange data in a variety of ways.
B) It relates lists of information in a relational database.
C) Reporting is limited to 20 saved reports.
D) Multiple users can simultaneously enter and update data within Access.

Accepted Answer

Access does not limit reporting to 20 saved reports; users can create and save many more reports as needed.

Question 18

A primary key field uniquely identifies each record.

Accepted Answer

A primary key field must have a unique value that identifies each record in a table.

Question 19

Microsoft Access can best be described as ____ software.
A) Spreadsheet
B) Presentation
C) Database
D) Systems

Accepted Answer

Microsoft Access is a database management system software used to store, manage, and manipulate data.

Question 20

No two records can have the same value in the primary key field.

Accepted Answer

This is a fundamental concept in database management. The primary key must uniquely identify each record in the table, so no two records can have the same value in that field.

Quiz 1: Getting Started With Access 2.0

In the figure above, use item number 1 to: