Deck 8: Extension-Using Microsoft Access 2013

Question 1

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

Answer 1

B

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

Data entry forms in Access are used to generate reports.

Question 5

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

Question 6

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

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

Question 7

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 8

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 9

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

Question 10

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

Question 11

Access does not allow users to create queries in SQL.

Question 12

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

Question 13

Access allows users to create tables in a design view.

Question 14

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 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

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

Question 17

Access provides a graphical user interface for creating database queries.

Question 18

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

Question 19

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

Question 20

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

Question 21

Access makes it easy to generate database queries by providing an easy-to-use ________ that generates SQL statements automatically.

Question 22

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

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

Question 23

A report ________ can be used to create a report.

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

Question 24

To run a ________ click on the red exclamation point labelled Run.

Question 25

Database forms allow the users to view, add, update or ________ data in the underlying tables.

Question 26

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 27

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

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

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

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

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

Question 30

In Access, entities are called ________.

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

Question 31

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 32

________ ask questions about the data.

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

Question 33

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

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

Question 34

To create a data entry form in Access, you can use the default table display or you can use the form ________.

Question 35

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 36

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 37

Access's graphical query interface translates statements into ________.

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

Question 38

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

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

Question 39

You build the links between tables using the ________ window.

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

Question 40

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

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

Question 41

Forms allow a user to view and maintain the ________ in a database.

Question 42

Access provides a graphical ________ for creating queries.

Question 43

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

Question 44

Queries in Access are translated into ________ by the query graphical interface.

Question 45

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

Question 46

To create a report from two tables you can use the ________.

Question 47

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

Question 48

In a form you can ________ over any data you wish to change.

Question 49

In order to execute a query in Access, create the query and then click on the ________ icon.