Question 1

Access provides a graphical ________ for creating queries.

Accepted Answer

user interface

Question 2

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

Accepted Answer

A)  table 
B)  data 
C)  field 
D)  application 
E)  key 
A)  table 
B)  data 
C)  field 
D)  application 
E)  key C

Question 3

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

Accepted Answer

A)  text 
B)  integer 
C)  currency 
D)  number 
E)  autonumber 
A)  text 
B)  integer 
C)  currency 
D)  number 
E)  autonumber E

Question 4

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

Accepted Answer

The answer of Queries in Access are translated into ________...

Question 5

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

Accepted Answer

Creating database queries shows the True

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

The answer of Access makes it easy to generate database...

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  drive 
B)  switch 
C)  exclamation mark 
D)  relationship 
E)  key 
A)  drive 
B)  switch 
C)  exclamation mark 
D)  relationship 
E)  key

Question 11

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

Accepted Answer

The answer of In a form you can ________ over...

Question 12

In a query of two or more tables, Access will show

Accepted Answer

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

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

Accepted Answer

In order to help users view the data and

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Access provides a graphical ________ for creating queries.

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

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

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

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

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

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

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

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

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

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

In a query of two or more tables, Access will show

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

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

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

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

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

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

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

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

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Database Design

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters

Exam 8: Extension-Using Microsoft Access 2013

Access provides a graphical ________ for creating queries.

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

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

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

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

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

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

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

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

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

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

In a query of two or more tables, Access will show

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

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

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

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

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

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

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

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

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Database and Content Management

Extension-Database Design

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters