Question 1

The relationships window allows users to define the relationships between tables.

Accepted Answer

The relationships window in a database management system allows users to define the relationships between tables.

Question 2

A primary key is indicated by a small key icon next to the field name in the design mode of the table.

Accepted Answer

This is a true statement. In the design mode of a table, a small key icon will appear next to the field that is designated as the primary key.

Question 3

A question one asks of the database is known as a(n)
A) result
B) form
C) query
D) report
E) table

Accepted Answer

A query is a specific question or request made of a database in order to retrieve relevant data. The other options either refer to the output of a query (such as a result or report) or aspects of the database itself (such as tables or forms).

Question 4

Data entry forms in Access are used to generate reports.

Accepted Answer

Data entry forms in Access are used to input and edit data, not generate reports. Reports are generated from queries or through the use of report design tools.

Question 5

When defining a relationship between two tables in Access,it is important to be sure to drag the correct ________ in the right direction and lay it on the other table.
A) relationship
B) attribute
C) window
D) key
E) table

Accepted Answer

The answer of When defining a relationship between two tables...

Question 6

Relationships can be assigned using the Relationships tool that is found on the Database Tools tab of the ribbon.

Accepted Answer

The Relationships tool can be found on the Database Tools tab and can be used to assign relationships between tables in a database.

Question 7

In MS Access,________ is a term that refers to the attributes that are described in the data model.
A) table
B) data
C) field
D) application
E) key

Accepted Answer

"Field" is the term used in MS Access to refer to the attributes described in the data model. A field represents a characteristic of the data to be stored in a table, such as a person's name, address, or phone number. Tables are made up of one or more fields, and fields are assigned data types to ensure data integrity and facilitate data analysis. The other options (A, B, D, and E) are related to MS Access, but do not accurately describe the term being asked about in the question.

Question 8

Before creating a database in Access,you should develop a data model based on the user requirements.

Accepted Answer

Developing a data model based on user requirements is an important step before creating a database in Access. This helps in understanding the data flow, relationships, and entities involved, which can then be used to design a database schema.

Question 9

A subform allows multiple records to be displayed that are related to the record displayed in the main form.

Accepted Answer

A subform is a form that is nested within another form, and displays records related to the record displayed in the main form. This allows for easy navigation and editing of related data in a database.

Question 10

When creating a new table in Access,the primary key is set by clicking on the ________ icon.
A) drive
B) switch
C) exclamation mark
D) relationship
E) key

Accepted Answer

The primary key for a new table in Access is set by clicking on the "key" icon, which represents the Primary Key field. This is necessary to ensure each record in the table has a unique identifier. The other options listed are not relevant to defining the Primary Key.

Question 11

A quick way of creating reports in Access is to use the Report Wizard.

Accepted Answer

The Report Wizard in Access is a quick and easy way to create reports by guiding users through a step-by-step process.

Question 12

Relationships are created in the relationships window by clicking on the primary key in one table and dragging it to the related field in another table.

Accepted Answer

This is how relationships are created in Microsoft Access.

Question 13

The most common data type for fields in tables is always the "number" data type.

Accepted Answer

The most common data type for fields in tables is actually the "text" data type. Number data type is also frequently used but it is not always the most common. Other data types such as date, time, and boolean are also commonly used depending on the type of data being stored.

Question 14

In the table design mode in Access the field and data type are required to create an attribute.

Accepted Answer

In the table design mode in Access, both the field name and data type are required to create an attribute.

Question 15

In MS Access,the ________ data type is used to generate a unique primary key.
A) text
B) integer
C) currency
D) number
E) autonumber

Accepted Answer

The autonumber data type is used to generate a unique primary key in MS Access. It automatically assigns a unique sequential number to each new record added to the table. The other data types listed (text, integer, currency, and number) may be used for other fields in the table, but they do not provide the automatic uniqueness and sequentiality of an autonumber field for a primary key.

Question 16

Access provides a graphical user interface for creating database queries.

Accepted Answer

Access provides a graphical user interface for creating database queries.

Question 17

Access does not allow users to create queries in SQL.

Accepted Answer

Access allows users to create queries in SQL by using the SQL View in the Query Design window.

Question 18

Forms allow users to view and maintain data in a database.

Accepted Answer

Forms provide a user-friendly interface for users to interact with data stored in a database. Users can view, enter, modify, and search for data through forms without having to write complex queries or commands.

Question 19

Access allows users to create tables in a design view.

Accepted Answer

Access allows users to create tables in both a design view and a datasheet view.

Question 20

A data entry form in Access can be created using the Form tool in the Create tab ribbon.

Accepted Answer

The Form tool in the Create tab ribbon can be used to create a data entry form in Access.

Quiz 16: Creating and Utilizing Forms, Queries, and Reports in MS Access

The relationships window allows users to define the relationships between tables.

A primary key is indicated by a small key icon next to the field name in the design mode of the table.

A question one asks of the database is known as a(n)

Data entry forms in Access are used to generate reports.

When defining a relationship between two tables in Access,it is important to be sure to drag the correct ________ in the right direction and lay it on the other table.

Relationships can be assigned using the Relationships tool that is found on the Database Tools tab of the ribbon.

In MS Access,________ is a term that refers to the attributes that are described in the data model.

Before creating a database in Access,you should develop a data model based on the user requirements.

A subform allows multiple records to be displayed that are related to the record displayed in the main form.

When creating a new table in Access,the primary key is set by clicking on the ________ icon.

A quick way of creating reports in Access is to use the Report Wizard.

Relationships are created in the relationships window by clicking on the primary key in one table and dragging it to the related field in another table.

The most common data type for fields in tables is always the "number" data type.

In the table design mode in Access the field and data type are required to create an attribute.

In MS Access,the ________ data type is used to generate a unique primary key.

Access provides a graphical user interface for creating database queries.

Access does not allow users to create queries in SQL.

Forms allow users to view and maintain data in a database.

Access allows users to create tables in a design view.

A data entry form in Access can be created using the Form tool in the Create tab ribbon.