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

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

A) result
B) form
C) query
D) report
E) table

Answer 3

C

Question 4

Data entry forms in Access are used to generate reports.

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

Question 6

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

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

Question 8

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

Question 9

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

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

Question 11

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

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.

Question 13

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

Question 14

In the table design mode in Access the field 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

Question 16

Access provides a graphical user interface for creating database queries.

Question 17

Access does not allow users to create queries in SQL.

Question 18

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

Question 19

Access allows users to create tables in a design view.

Question 20

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

Question 21

The ______________ keyword tells Access to present the text data in alphabetical order.

A) order
B) table
C) plus
D) red
E) Ascending

Question 22

________ are used by the user to enter data in to an Access database.

A) Queries
B) Modules
C) Tables
D) Forms
E) Reports

Question 23

The second column at the top of the table design window contains the ________ of the field.

A) field name
B) field size
C) properties
D) data type
E) description

Question 24

Access' graphical query interface translates statements into ________.

A) VBA
B) ASP
C) query
D) SQL
E) C++

Question 25

What are reports used for and how are they created in MS Access?

Question 26

The properties of each field are set at the ________ of the table design window.

A) top
B) centre
C) bottom
D) left
E) right

Question 27

The key icon can be found in the ________ tab ribbon.

A) Design
B) Create
C) Datasheet
D) Home
E) Database Tools

Question 28

Access displays the _____________of a field as help text on forms.

A) description
B) data type
C) name
D) colour
E) attribute

Question 29

You build the links between tables using the ________ window.

A) relationships
B) relationship wizard
C) database diagram
D) mapping
E) database relationships

Question 30

It is possible to create a primary key composed of ___________ columns or fields.

A) relational
B) linked
C) number
D) multiple
E) text

Question 31

In an _____________ field,Access creates values for the user.

A) number
B) hyperlink
C) long integer
D) text
E) Autonumber

Question 32

Why are queries so useful and how are they created in MS Access?

Question 33

In Access,entities are called ________.

A) columns
B) rows
C) fields
D) tables
E) queries

Question 34

The description in the table design window is used for ________.

A) additional data type information
B) formatting fields
C) documentation
D) setting properties
E) additional field name information

Question 35

What are data entry forms used for and how are they created in MS Access?

Question 36

A report ______________ can be used to create a report.

A) wizard
B) queries
C) tables
D) modules
E) forms

Question 37

In a query of two or more tables Access will show

A) all the relevant records in both/all tables.
B) only records in the parent table
C) only records that have matching values in all the tables.
D) only records that do not have matching records in all the tables.
E) every record in one table joined to each record in the other table.

Question 38

________ ask questions about the data.

A) Reports
B) Queries
C) Modules
D) Forms
E) Tables

Question 39

_______________ is one of many reserved words in the Access environment.

A) "Value"
B) "Data"
C) "Colour"
D) "Name"
E) "Variable"