Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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 3

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 B

Question 4

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 5

Explain the procedure for creating a database using Microsoft Access.

Accepted Answer

To create a new database,select Blank da

Question 6

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 7

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

Accepted Answer

Access provides several alternatives for

Question 8

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Unlike Microsoft Excel,users cannot key in data to Microsoft Access cells.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which of the following options in Microsoft Access can be used to make the data entry form more pleasing for the users?

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 14

Before using a DBMS,the user should have created a(n)________.

Accepted Answer

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

Question 15

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

Accepted Answer

After creating the tables in Microsoft A

Question 16

Before using any DBMS,the user should have created a data model from the users' requirements.

Accepted Answer

A) True 
 B)False

Question 17

In Access,after creating a relationship between two tables,the user cannot and need not assign values for the ________.

Accepted Answer

A) primary key 
B) tracker 
C) foreign key 
D) add-ons 
A) primary key 
B) tracker 
C) foreign key 
D) add-ons

Question 18

To create a query,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

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 17: Using Microsoft Access 2010

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

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

The step after creating a relationship between two tables is ________.

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

Explain the procedure for creating a database using Microsoft Access.

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

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

Access opens the new database by ________.

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

Unlike Microsoft Excel,users cannot key in data to Microsoft Access cells.

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

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

Which of the following options in Microsoft Access can be used to make the data entry form more pleasing for the users?

Before using a DBMS,the user should have created a(n)________.

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

Before using any DBMS,the user should have created a data model from the users' requirements.

In Access,after creating a relationship between two tables,the user cannot and need not assign values for the ________.

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

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

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

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

Data Communication and 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

Introduction to Microsoft Excel 2010

Database Design

Using Excel and Access Together

Mobile Systems

Functional Applications

Enterprise Resource Planning ERP systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters