Question 1

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

Accepted Answer

The answer of In order to execute a query in...

Question 2

A report ________ can be used to create a report.

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

________ ask questions about the data.

Accepted Answer

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

Question 6

Access provides a graphical user interface for creating database queries.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

Reports allow users to place summarized

Question 9

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

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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.

Accepted Answer

A)  relationship 
B)  attribute 
C)  window 
D)  key 
E)  table 
A)  relationship 
B)  attribute 
C)  window 
D)  key 
E)  table

Question 13

Access does not allow users to create queries in SQL.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of To create a report from two tables...

Question 15

Access's graphical query interface translates statements into ________.

Accepted Answer

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

Question 16

Access allows users to create tables in a design view.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of Forms allow a user to view and...

Question 20

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

Accepted Answer

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

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

A report ________ can be used to create a report.

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

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

________ ask questions about the data.

Access provides a graphical user interface for creating database queries.

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

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

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.

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

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.

Access does not allow users to create queries in SQL.

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

Access's graphical query interface translates statements into ________.

Access allows users to create tables in a design view.

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

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

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

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

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

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

A report ________ can be used to create a report.

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

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

________ ask questions about the data.

Access provides a graphical user interface for creating database queries.

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

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

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.

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

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.

Access does not allow users to create queries in SQL.

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

Access's graphical query interface translates statements into ________.

Access allows users to create tables in a design view.

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

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

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

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

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