Question 1

Access is a(n) ____________________ database management system.

Accepted Answer

The answer of Access is a(n) ____________________ database management system....

Question 2

The default name for a new table is ______.
A) AccessTable
B) NewTable
C) TableNew
D) Table1

Accepted Answer

The default name for a new table in Access is "Table1". This naming convention is based on numerical incrementation, with each new table being named "Table1", "Table2", "Table3", etc. This makes it easy to keep track of your tables and ensures that each table has a unique name. It is generally not recommended to use generic names like "AccessTable" or "NewTable" as they may become confusing or ambiguous when working with multiple tables.

Question 3

Pilar is creating a new database for her business. Pilar uses a unique product number for each product in her inventory. She makes the product number ____.
A) a table
B) the primary key
C) a database
D) a record

Accepted Answer

The primary key is a unique identifier for each record in a database, and in this case, Pilar is using the product number as the primary key. A database is the overall collection of related data, while a table is a subset of that data in which the records are organized into rows and columns. Each row in a table represents a record, and in this case, the product number would be the primary key for each record.

Question 4

The ____________________ key prevents duplicate entries.

Accepted Answer

The answer of The ____________________ key prevents duplicate entries....

Question 5

The default data type for a field is ____.
A) Number
B) Short Text
C) Currency
D) Yes/No

Accepted Answer

By default, when creating a new field in Microsoft Access, the data type will be Short Text. However, this may vary depending on the version of Access being used and any default settings that have been changed.

Question 6

A table is often referred to as a(n) ____________________.

Accepted Answer

The answer of A table is often referred to as...

Question 7

What is a database? Name a sample use for a database and two tables that database might contain. Name one similarity and one difference between Access and Excel. What is a relational database and how is it used?

Accepted Answer

The answer of What is a database? Name a sample...

Question 8

By default, a table opens in _____ view.
A) Secure
B) Design
C) Datasheet
D) Property

Accepted Answer

By default, a table opens in Datasheet view which displays data in rows and columns.

Question 9

A ____ is a single piece of database information.
A) field
B) record
C) datasheet
D) primary key

Accepted Answer

A field is a single piece of database information, such as a person's name or address. A record is a collection of related fields, while a datasheet is a view of multiple records in a table. A primary key is a unique identifier for a record in a table.

Question 10

Field ____________________ define the characteristics and behavior of a field.

Accepted Answer

The answer of Field ____________________ define the characteristics and behavior...

Question 11

C.J. wants to modify a table in his database. C.J. wants to easily edit the field properties in his table. He should work in ____ view.
A) Table
B) Normal
C) Design
D) Datasheet

Accepted Answer

Design view allows for easy editing of field properties in a table.

Question 12

Access is the Microsoft Office ____________________ application.

Accepted Answer

The answer of Access is the Microsoft Office ____________________ application....

Question 13

C.J. wants to modify a table in his database. C.J. wants to change the default Field Size property for a field with the Text data type from ____ characters to 50.
A) 8
B) 55
C) 100
D) 255

Accepted Answer

The default Field Size property for a field with the Text data type is 255 characters, so changing it to 50 would require selecting this option. Options A, B, and C are not relevant to the question.

Question 14

Pilar is creating a new database for her business. Pilar wants to store information about customers' orders, as well as product details of her inventory. She should create separate ____ for each.
A) tables
B) fields
C) records
D) databases

Accepted Answer

Pilar should create separate tables for each - one for customers' orders and one for product details of her inventory. Tables are used to store data in a database, and each table should contain information about a specific type of data, such as customers or products. Fields are the individual pieces of information within a table (such as customer name or product price), records refer to a complete set of information within a row of a table, and databases are overall collections of related tables.

Question 15

To move the insertion point to the previous field in Datasheet view, press ____.
A) Shift+Tab
B) the right arrow
C) Enter
D) Tab

Accepted Answer

Shift+Tab is the shortcut key to move the insertion point to the previous field in Datasheet view. This key combination is the reverse of the Tab key, which moves the insertion point to the next field.

Question 16

The _____ property in Access specifies how numbers, dates, times, and text are displayed.
A) Field
B) Layout
C) Format
D) Primary key

Accepted Answer

The Format property in Access specifies how numbers, dates, times, and text are displayed. Field refers to a column in a table, Layout refers to the arrangement of objects on a form or report, and Primary key is a field that uniquely identifies each record in a table.

Question 17

In Datasheet view, when a record is being edited, a(n) ____ icon appears to the left edge of the row.
A) star
B) key
C) pencil
D) arrow

Accepted Answer

In Datasheet view, when a record is being edited, a pencil icon appears to the left edge of the row.

Question 18

A ____ would store all of the information about an individual.
A) field
B) record
C) datasheet
D) primary key

Accepted Answer

A record in a database is a collection of fields that contain all the information about an individual or entity.

Question 19

When you create a new field, you can choose a ____, such as text or numbers.
A) field property
B) datasheet
C) field name
D) data type

Accepted Answer

When creating a new field, the data type is the option to choose what kind of data the field will hold, such as text or numbers.

Question 20

Which of the following is NOT true about deleting and copying records and fields in Datasheet view?
A) The Cut, Copy, and Paste commands are available in Access.
B) You can use the Undo command to delete a record.
C) To remove a table field and all the data for the field, you delete the column.
D) You can rearrange the sequence of the columns.

Accepted Answer

The Undo command is used to reverse the last action, not specifically to delete a record. Deleting a record is a deliberate action that would not be described as using the Undo command.

Quiz 23: Getting Started With Access Essentials

Access is a(n) ____________________ database management system.

The default name for a new table is ______.

Pilar is creating a new database for her business. Pilar uses a unique product number for each product in her inventory. She makes the product number ____.

The ____________________ key prevents duplicate entries.

The default data type for a field is ____.

A table is often referred to as a(n) ____________________.

What is a database? Name a sample use for a database and two tables that database might contain. Name one similarity and one difference between Access and Excel. What is a relational database and how is it used?

By default, a table opens in _____ view.

A ____ is a single piece of database information.

Field ____________________ define the characteristics and behavior of a field.

C.J. wants to modify a table in his database. C.J. wants to easily edit the field properties in his table. He should work in ____ view.

Access is the Microsoft Office ____________________ application.

C.J. wants to modify a table in his database. C.J. wants to change the default Field Size property for a field with the Text data type from ____ characters to 50.

Pilar is creating a new database for her business. Pilar wants to store information about customers' orders, as well as product details of her inventory. She should create separate ____ for each.

To move the insertion point to the previous field in Datasheet view, press ____.

The _____ property in Access specifies how numbers, dates, times, and text are displayed.

In Datasheet view, when a record is being edited, a(n) ____ icon appears to the left edge of the row.

A ____ would store all of the information about an individual.

When you create a new field, you can choose a ____, such as text or numbers.

Which of the following is NOT true about deleting and copying records and fields in Datasheet view?