Question 1

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

Accepted Answer

The data type of a field determines the type of values that can be entered into it. For example, a field with a data type of "number" can only accept numeric values, while a field with a data type of "text" can accept any textual input.

Question 2

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

Accepted Answer

Access provides two options for creating tables - Datasheet View and Design View. The Design View allows you to create a table with more precision and control over the fields and their properties.

Question 3

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

Accepted Answer

A query is primarily used to retrieve and display data from a database, not to enter or edit records. Forms are typically used for entering and editing data.

Question 4

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

Accepted Answer

report

Question 5

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

Accepted Answer

A table is a database object that stores data in rows and columns, but it is not a predesigned database with other objects like queries, forms, or reports.

Question 6

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 typically called a query or a search, not a primary key. A primary key is a unique identifier that is used to distinguish one record from another in a database table.

Question 7

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

Accepted Answer

This is true in most cases, but it is possible to set a different field as the primary key in Access.

Question 8

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

Accepted Answer

are not,aren't

Question 9

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

Accepted Answer

Compacting a database removes empty spaces and rearranges data and objects to reduce the file size, resulting in improved performance and faster access to data.

Question 10

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

The Layout view in Access allows the user to make design changes to the form while it is displaying data, making it easier to customize the form to meet specific needs.

Question 11

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 true statement. A DBMS is a software program that enables users to create, manage, and manipulate databases. Examples of DBMS include Oracle, MySQL, SQL Server, MongoDB, and PostgreSQL.

Question 12

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 establish a relationship between two tables.

Question 13

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

Accepted Answer

This is true. By default, Access will display the records in ascending order based on the primary key field. However, you can change the sort order by using sorting and filtering options.

Question 14

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

Accepted Answer

field

Question 15

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

Accepted Answer

A database is a collection of related tables that store data in an organized way. The tables are linked together by common fields or attributes, which allow for efficient querying and manipulation of the data.

Question 16

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 is true according to Microsoft's documentation on Access database specifications.

Question 17

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 18

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

Accepted Answer

common

Question 19

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

Accepted Answer

Print

Question 20

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 such as tables, queries, forms, reports, and macros.

Quiz 1: Creating a Database