Question 1

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

Accepted Answer

False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

Pressing the F2 key toggles between Edit and Navigation modes in many programs, including Microsoft Excel and Microsoft Word.

Question 4

Tables contain all of the data in the database.

Accepted Answer

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

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, so this statement is false. Access allows for the creation of numerous reports based on the data within a database.

Question 6

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 record number and allow the user to navigate between records, but they do not display the total number of fields in the datasheet. The total number of fields can be seen in the column headings of the datasheet.

Question 7

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

Accepted Answer

This is correct, the foreign key field on the "many" side of the relationship links to the primary key field on the "one" side of the relationship.

Question 8

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

Accepted Answer

Tables, queries, and forms are all examples of objects in Microsoft Access. Entities refer to the individual pieces of data stored in a database, values refer to specific data inputs, and controls are specific features within forms and reports that allow users to interact with data.

Question 9

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

Accepted Answer

A subdatasheet displays the related records on the "many" side of a one-to-many relationship, making it easier to navigate and analyze the data. It is accessed from a related table in a database and displays all the related records in the form of a datasheet.

Question 10

A primary key field uniquely identifies each record.

Accepted Answer

A primary key field must have a unique value for each record, allowing it to be used as a reference point for that specific record.

Question 11

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 option when starting Access. The available options are opening an existing database, creating a new database from a template, or creating a new blank database.

Question 12

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

Accepted Answer

Microsoft Access is a database software used to store, organize and manage large amounts of data. It allows users to create and manage relationships among different data tables, generate reports, and create forms for data entry. It is not a spreadsheet or presentation software, and while it is a system software, that choice is too broad and not specific enough.

Question 13

Which Access object provides an easy-to-use data entry screen?
A) macro
B) form
C) table
D) module

Accepted Answer

A form in Access provides an easy-to-use data entry screen where users can enter, view, and edit data in a user-friendly interface.

Question 14

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

Accepted Answer

This is the fundamental rule of primary keys in a relational database. Primary keys uniquely identify each record in a table, and duplicate values are not allowed.

Question 15

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

Accepted Answer

"Focus" refers to the active or selected data element on the screen or application, and if you start typing, it would affect the focused data element.

Question 16

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

Yes, values in an AutoNumber field are automatically created by Access. Access assigns a unique number to each new record in the table.

Question 17

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 18

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

Accepted Answer

This is true. Field properties can vary depending on the data type of the field. For example, a text field may have a maximum character limit while a number field may have a range limit.

Question 19

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

Accepted Answer

Access allows for multi-user access, which means multiple users can work with the same database simultaneously.

Question 20

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.

Quiz 1: Getting Started With Access 2013