Question 1

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 id 
D)  creating a table 
A)  creating a database 
B)  assigning field names 
C)  creating a primary id 
D)  creating a table A

Question 2

Access opens the 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 C

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

In Microsoft Access,a user has to define the relationships between fields before creating the tables.

Accepted Answer

A) True 
 B)False

Question 5

In Access,to create a relationship between two tables,users must ________.

Accepted Answer

A)  drag the primary key in one table to the foreign key in another table. 
B)  create a link between the foreign keys from both the tables. 
C)  drag the foreign key in one table to the primary key in another table. 
D)  create a link between the primary key in one table to the primary key in another table. 
A)  drag the primary key in one table to the foreign key in another table. 
B)  create a link between the foreign keys from both the tables. 
C)  drag the foreign key in one table to the primary key in another table. 
D)  create a link between the primary key in one table to the primary key in another table.

Question 6

The option to create reports can be found in the Database Tools ribbon of Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 7

To create a report with data from not more than two tables,we must use the Report Wizard.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

In Access,records can be deleted by clicking the down arrow next to Delete and selecting Delete Record,which is present in the Records section of the ________ tab.

Accepted Answer

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

Question 10

An underlined attribute is the primary key and an italicized attribute is a foreign key.

Accepted Answer

A) True 
 B)False

Question 11

In Microsoft Access,users must drag the foreign key in one table to the primary key in another table to enforce a relationship.

Accepted Answer

A) True 
 B)False

Question 12

How can a user generate reports in Microsoft Access?

Accepted Answer

To create a report with data f

Question 13

To create a report with data from two or more tables,we must use the ________.

Accepted Answer

A)  Report Wizard 
B)  Navigation tab 
C)  Report Design 
D)  Share Point lists 
A)  Report Wizard 
B)  Navigation tab 
C)  Report Design 
D)  Share Point lists

Question 14

Access opens a new database by creating a default table named Table A.

Accepted Answer

A) True 
 B)False

Question 15

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)  characterize the fields in terms of their data types 
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)  characterize the fields in terms of their data types

Question 16

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

Accepted Answer

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

Question 17

Explain the different alternatives provided by Microsoft Access for creating data entry forms.

Accepted Answer

Access provides several alternatives for

Question 18

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 19

Relationships can be defined in Microsoft Access by selecting the ________ tab in the ribbon.

Accepted Answer

A)  Database Tools 
B)  External Data 
C)  Connections 
D)  Add-ins 
A)  Database Tools 
B)  External Data 
C)  Connections 
D)  Add-ins

Question 20

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

Exam 20: Using Microsoft Access 2010

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

Access opens the new database by ________.

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

In Microsoft Access,a user has to define the relationships between fields before creating the tables.

In Access,to create a relationship between two tables,users must ________.

The option to create reports can be found in the Database Tools ribbon of Microsoft Access.

To create a report with data from not more than two tables,we must use the Report Wizard.

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

In Access,records can be deleted by clicking the down arrow next to Delete and selecting Delete Record,which is present in the Records section of the ________ tab.

An underlined attribute is the primary key and an italicized attribute is a foreign key.

In Microsoft Access,users must drag the foreign key in one table to the primary key in another table to enforce a relationship.

How can a user generate reports in Microsoft Access?

To create a report with data from two or more tables,we must use the ________.

Access opens a new database by creating a default table named Table A.

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

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

Explain the different alternatives provided by Microsoft Access for creating data entry forms.

All modern DBMS products can process the ________ query language.

Relationships can be defined in Microsoft Access by selecting the ________ tab in the ribbon.

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

The Importance of MIS

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Data Communications

Business Process Management

E-Commerce, Web 2.0, and Social Networking

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Information Systems Management

Information Security Management

Improving Your Collaboration Skills

Using Collaboration Information Systems

Information Systems and Decision Making

Knowledge Management and Expert Systems

Introduction to Microsoft Excel

Preparing a Computer Budget Using Excel

Database Design

Using Excel and Access Together

Remote, Nomadic, and Mobile Systems

Functional Processes, Applications, and Systems

Enterprise Resource Planning (ERP)Systems

Supply Chain Management

Processing Social Capital: Facebook, Twitter, and User-Generated Content (UGC)

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Business Process Management

Systems Development Project Management

Outsourcing

International MIS

Filters