Question 1

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Accepted Answer

The foreign key field is used to link the "many" side of a one-to-many relationship to the "one" side, which contains the primary key field.

Question 2

Which is NOT true about Access?
A) It can be used to create forms
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

Reporting is not limited to 20 saved reports. Access allows users to create and save an unlimited number of reports.

Question 3

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

Accepted Answer

False

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 record number currently being viewed and allow for navigation between records, not the total number of fields in the datasheet.

Question 5

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

Accepted Answer

The F2 key is used to switch between Edit and Navigation modes in many applications such as Microsoft Excel and Word.

Question 6

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

Accepted Answer

Field properties such as size, format, validation rules, and default values can vary depending on the data type of the field. For example, a text field may have a maximum size limit while a numeric field may have decimal places allowed.

Question 7

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

Accepted Answer

"Focus" refers to the section of text where the cursor is currently active and where any typing or editing will occur. This means that you would edit the data within the focused section.

Question 8

Access databases cannot be password protected.

Accepted Answer

Access databases can be password protected using the built-in encryption feature in Access.

Question 9

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

Accepted Answer

This is true in relational database design, as the primary key uniquely identifies each record in a table. If two records had the same primary key value, it would violate this rule and cause data inconsistencies.

Question 10

Which of the following is NOT available to you as you start Access?
A) opening an existing database
B) recalibrating an existing database
C) creating a new database from a template
D) creating a new blank database

Accepted Answer

Access does not provide an option to recalibrate an existing database at start-up. Options available include opening an existing database, creating a new database from a template, or creating a new blank database.

Question 11

Tables contain all of the data in the database.

Accepted Answer

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

Question 12

Tables, queries, and forms are examples of Access ____.
A) entities
B) objects
C) values
D) controls

Accepted Answer

Tables, queries, and forms are all objects within Access. Entities refer to the data being stored, values refer to specific data points, and controls refer to tools used to interact with objects.

Question 13

Microsoft Access 2016 can best be described as ____ software.
A) spreadsheet
B) presentation
C) database
D) systems

Accepted Answer

Microsoft Access 2016 is specifically designed to create and manage databases. It allows users to store, organize, and retrieve data in an efficient manner. It is not a spreadsheet software like Microsoft Excel, nor is it a presentation software like Microsoft PowerPoint. It is also not a system software that controls and manages the hardware and software components of a computer system.

Question 14

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A subdatasheet displays related records from the "many" side of a one-to-many relationship in a separate datasheet below the main datasheet.

Question 15

More than one person can enter, update, and analyze data in an Access database at the same time.

Accepted Answer

Access allows for multiple users to access and make changes to a database simultaneously, with the use of a multi-user environment and lock handling.

Question 16

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

Accepted Answer

Pressing the Esc key once can undo a change made to the current field.

Question 17

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

AutoNumber fields generate unique, sequential values automatically when a new record is added to the table.

Question 18

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Accepted Answer

The answer of If a number has already been incremented...

Question 19

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

Accepted Answer

This is correct. Pressing [Ctrl][;] will insert the current date in a Date field in Microsoft Word.

Question 20

A primary key field uniquely identifies each record.

Accepted Answer

This is correct. The primary key field is a unique identifier for each record in a database table, allowing it to be easily located and referenced.

Quiz 1: Getting Started With Access