Question 1

Every field in Microsoft Access must have a Description associated with it.

Accepted Answer

A) True 
 B)False  False

Question 2

In Microsoft Access,different attributes are referred to as ________.

Accepted Answer

A)  identifiers 
B)  keys 
C)  entities 
D)  fields 
A)  identifiers 
B)  keys 
C)  entities 
D)  fields D

Question 3

In Microsoft Access,the option to generate a data entry form is present in the CREATE ribbon.

Accepted Answer

A) True 
 B)False  True

Question 4

In Microsoft Access,relationships can be defined by selecting the DATABASE TOOLS tab.

Accepted Answer

A) True 
 B)False

Question 5

In Access,the step after creating a relationship between two tables is ________.

Accepted Answer

A)  to create macros 
B)  to enter data 
C)  to provide descriptions to each of the tables 
D)  to create queries 
A)  to create macros 
B)  to enter data 
C)  to provide descriptions to each of the tables 
D)  to create queries

Question 6

Explain the procedure for establishing a relationship between two tables in Microsoft Access.

Accepted Answer

After creating tables in Microsoft Acces

Question 7

Access opens a new database by ________.

Accepted Answer

A)  creating a default table named Table A1 
B)  creating a default table named Table A 
C)  creating a default table named Table 1 
D)  asking the user to name his/her table 
A)  creating a default table named Table A1 
B)  creating a default table named Table A 
C)  creating a default table named Table 1 
D)  asking the user to name his/her table

Question 8

In Access,a surrogate key has no meaning to the user.

Accepted Answer

A) True 
 B)False

Question 9

In the ________ tab in Access,the Record section contains the Delete option.

Accepted Answer

A)  Database Tools 
B)  Home 
C)  Fields 
D)  File 
A)  Database Tools 
B)  Home 
C)  Fields 
D)  File

Question 10

The Description field in Microsoft Access is used mainly for documentation.

Accepted Answer

A) True 
 B)False

Question 11

In Microsoft Access,the Description of fields is used to ________.

Accepted Answer

A)  document the details of each field 
B)  define rules for how each field should behave 
C)  define how the fields should behave in case of exceptions 
D)  specify the data types of the fields 
A)  document the details of each field 
B)  define rules for how each field should behave 
C)  define how the fields should behave in case of exceptions 
D)  specify the data types of the fields

Question 12

All modern DBMS products can process the ________ query language.

Accepted Answer

A)  SQL 
B)  MySQL 
C)  DB10 
D)  HTML 
A)  SQL 
B)  MySQL 
C)  DB10 
D)  HTML

Question 13

The option to create reports can be found in the DATABASE TOOLS tab of Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 14

In Microsoft Access reports,the Grouping & Totals section contains the options to display totals in a report.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following tabs in Microsoft Access is used to generate reports?

Accepted Answer

A)  CREATE 
B)  DATA 
C)  TOOLS 
D)  FORMAT 
A)  CREATE 
B)  DATA 
C)  TOOLS 
D)  FORMAT

Question 16

Before using a DBMS,a user should create a(n)________.

Accepted Answer

A)  data model 
B)  database 
C)  identifier 
D)  attribute 
A)  data model 
B)  database 
C)  identifier 
D)  attribute

Question 17

Which of the following options in Microsoft Access can be used to present data in a more pleasing manner than the default table display?

Accepted Answer

A)  Form 
B)  Tab Order 
C)  Property Sheet 
D)  Add-ins 
A)  Form 
B)  Tab Order 
C)  Property Sheet 
D)  Add-ins

Question 18

To create a query in Microsoft Access,one must drag columns out of the required tables into the grid in the lower part of the query definition form.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is the first activity to be performed on starting Microsoft Access?

Accepted Answer

A)  creating a database 
B)  assigning field names 
C)  creating a primary key 
D)  creating a table 
A)  creating a database 
B)  assigning field names 
C)  creating a primary key 
D)  creating a table

Question 20

Microsoft Access provides a default table display for creating a data entry form.

Accepted Answer

A) True 
 B)False

Exam 18: Using Microsoft Access 2013

Every field in Microsoft Access must have a Description associated with it.

In Microsoft Access,different attributes are referred to as ________.

In Microsoft Access,the option to generate a data entry form is present in the CREATE ribbon.

In Microsoft Access,relationships can be defined by selecting the DATABASE TOOLS tab.

In Access,the step after creating a relationship between two tables is ________.

Explain the procedure for establishing a relationship between two tables in Microsoft Access.

Access opens a new database by ________.

In Access,a surrogate key has no meaning to the user.

In the ________ tab in Access,the Record section contains the Delete option.

The Description field in Microsoft Access is used mainly for documentation.

In Microsoft Access,the Description of fields is used to ________.

All modern DBMS products can process the ________ query language.

The option to create reports can be found in the DATABASE TOOLS tab of Microsoft Access.

In Microsoft Access reports,the Grouping & Totals section contains the options to display totals in a report.

Which of the following tabs in Microsoft Access is used to generate reports?

Before using a DBMS,a user should create a(n)________.

Which of the following options in Microsoft Access can be used to present data in a more pleasing manner than the default table display?

To create a query in Microsoft Access,one must drag columns out of the required tables into the grid in the lower part of the query definition form.

Which of the following is the first activity to be performed on starting Microsoft Access?

Microsoft Access provides a default table display for creating a data entry form.

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters