Question 1

Field values that may be entered into a field are determined by the data type of the field. _________________________

Accepted Answer

This statement is true. The data type of a field determines what type of values can be entered into it. For example, a text field would allow for letters and numbers, while a date field would only allow for dates.

Question 2

It is possible to view all Access objects in the Navigation Pane. _________________________

Accepted Answer

The Navigation Pane in Access allows users to view all objects, including tables, queries, forms, reports, macros, and modules.

Question 3

A question asked about the data stored in a database is called a primary key. _________________________

Accepted Answer

A question asked about the data stored in a database is actually called a query, not a primary key. A primary key is a unique identifier for each record in a database table.

Question 4

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). _________________________

Accepted Answer

This is a correct definition of a DBMS.

Question 5

The only option available for creating tables in Access is to use the datasheet view. _________________________

Accepted Answer

Tables in Access can also be created using the design view, which allows for more precise customization of table structure and properties.

Question 6

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet. _________________________

Accepted Answer

This statement is true.

Question 7

A formatted printout (or screen display) of the contents of one or more tables or queries is a form. _________________________

Accepted Answer

report

Question 8

A query is used to enter,edit,and view records in a database. _________________________

Accepted Answer

The answer of  A query is used to enter,edit,and view...

Question 9

A table is a predesigned database that includes professionally designed database objects. _________________________

Accepted Answer

The answer of  A table is a predesigned database that...

Question 10

Each record in a table is uniquely identified by a foreign key. _________________________

Accepted Answer

Each record in a table is uniquely identified by a primary key, not a foreign key. A foreign key is used to create a relationship between two tables.

Question 11

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _________________________

Accepted Answer

This statement is true. Each Access database can be as large as two gigabytes and can accommodate up to 255 concurrent users.

Question 12

The default sort order for records in an Access table is based on the values in the primary key field._________________________

Accepted Answer

The default sort order in Access is based on the primary key field. If there is no primary key, the default sort order is based on the order in which the records were added to the table.

Question 13

Access report printing options may be changed using theNavigation dialog box._________________________

Accepted Answer

Print

Question 14

A single characteristic or attribute of a person,place,object,event,or idea is a table. _________________________

Accepted Answer

field

Question 15

When creating a form in Access,the Layout view allows the user to make design changes to the form while it is displaying data. _________________________

Accepted Answer

In Layout view, the user can modify the design of the form while maintaining data visibility.

Question 16

The query results are stored in the database in which the query has been created._________________________

Accepted Answer

are not,aren't

Question 17

Compacting a database rearranges the data and objects in a database to decrease its file size. _________________________

Accepted Answer

Compacting a database removes any unused space and rearranges it to decrease its file size, making it more efficient and faster to use.

Question 18

A database or a relational database is a collection of related tables. _________________________

Accepted Answer

A database or a relational database is designed to store data in tables that are related to each other through a common field or key. Each table represents an entity in the real world, and the relationships between the tables represent the relationships between the entities they represent. Therefore, a database is a collection of related tables.

Question 19

The default primary key for an Access database is the ID field. _________________________

Accepted Answer

The default primary key for an Access database is the ID field.

Question 20

A relationship between two tables in a database is formed using a Backstage field. _________________________

Accepted Answer

common

Quiz 1: Creating a Database

Field values that may be entered into a field are determined by the data type of the field. _________________________

It is possible to view all Access objects in the Navigation Pane. _________________________

A question asked about the data stored in a database is called a primary key. _________________________

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). _________________________

The only option available for creating tables in Access is to use the datasheet view. _________________________

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet. _________________________

A formatted printout (or screen display) of the contents of one or more tables or queries is a form. _________________________

A query is used to enter,edit,and view records in a database. _________________________

A table is a predesigned database that includes professionally designed database objects. _________________________

Each record in a table is uniquely identified by a foreign key. _________________________