Question 1

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 2

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

Accepted Answer

Access allows multiple users to access and work on the same database simultaneously using network connections. This feature is known as multi-user access. However, it is important to properly manage access permissions to avoid data conflicts or corruption.

Question 3

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

AutoNumber fields automatically generate a unique and sequential number for each record. These values cannot be edited by users and are managed by Access.

Question 4

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

Accepted Answer

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

Question 5

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 in Access.

Question 6

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

Accepted Answer

Microsoft Access 2016 is a database software tool used to create and manage databases. It allows users to store, organize, and manipulate large amounts of information, making it particularly useful for businesses and organizations that deal with large volumes of data. While it does have some spreadsheet-like functionalities, such as the ability to organize data into tables and create calculations, it is primarily a database tool.

Question 7

Tables contain all of the data in the database.

Accepted Answer

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

Question 8

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 9

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 10

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

Accepted Answer

Field properties such as size, format, input mask, and validation rules vary based on the data type of the field.

Question 11

Access databases cannot be password protected.​

Accepted Answer

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

Question 12

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

Accepted Answer

"Focus" refers to the part of a document or application that is currently active and where your typing or editing will take place. So, it is true that the focus determines which data you would edit if you started typing.

Question 13

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

Accepted Answer

This is correct. Pressing F2 toggles between Edit and Navigation modes in many applications, including Microsoft Excel.

Question 14

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

Recalibrating an existing database is not an available option when starting Access. The other three options of opening an existing database, creating a new database from a template, and creating a new blank database are available.

Question 15

A primary key field uniquely identifies each record.

Accepted Answer

A primary key field must have a unique value for each record in a table, ensuring that there are no duplicates and allowing for easy indexing and searching of records.

Question 16

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

Accepted Answer

A subdatasheet is a way to view related data from the "many" side of a one-to-many relationship. It allows you to see all the related records in a table or query, which can be expanded or collapsed within the main datasheet view.

Question 17

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 current position in the datasheet and allow for navigation through the records, but they do not display the total number of fields in the datasheet.

Question 18

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 in Access, representing different components of a database. Entities refers to the data itself, and values refers to the individual pieces of data within the entities. Controls are used to manipulate or display data within a form or report.

Question 19

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

Accepted Answer

This statement is true. The foreign key field is used to link records in the "many" side of the relationship to the corresponding record in the "one" side of the relationship.

Question 20

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

Accepted Answer

The primary key field is used to uniquely identify each record in a table, so it cannot have the same value in two different records.

Quiz 5: Module 1 Getting Started With Access

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

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

Values in an AutoNumber field are automatically created by Access.

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

Which is NOT true about Access?

Microsoft Access 2016 can best be described as ____ software.

Tables contain all of the data in the database.

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.

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

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

Access databases cannot be password protected.​

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

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

Which of the following is NOT available to you as you start Access?

A primary key field uniquely identifies each record.

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

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

Tables, queries, and forms are examples of Access ____.

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

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

Access databases cannot be password protected.