Question 1

Before using any DBMS,a user should create a data model based on the users' requirements.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

How can a user generate reports in Microsoft Access?

Accepted Answer

Report Wizard is used to create a report with data from two or more tables.Click the CREATE tab,and then in the Reports section click Report Wizard.Now,select the table in the Table/Queries combo box,highlight the field in the Available Fields list,and click the single chevron (>)to add the selected field to the report.Using a similar process,other fields can be added,even from other tables.On clicking Finish,the report is generated.

Question 4

Access opens a new database by ________.

Accepted Answer

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

Question 5

Which of the following statements is true about reports in Access?

Accepted Answer

A) The Report Wizard option is present in the Database Tools tab. 
B) A report can only show the data present in the database,it cannot present their sum or average values. 
C) Report Wizard is required when data from more than one table is to be used. 
D) Only the primary key's column width can be increased in a report. 
A) The Report Wizard option is present in the Database Tools tab. 
B) A report can only show the data present in the database,it cannot present their sum or average values. 
C) Report Wizard is required when data from more than one table is to be used. 
D) Only the primary key's column width can be increased in a report.

Question 6

Which of the following is a valid entry for Field Size if the Data Type of the field is "Number"?

Accepted Answer

A) 10.5 
B) long integer 
C) 10 
D) character 
A) 10.5 
B) long integer 
C) 10 
D) character

Question 7

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

Accepted Answer

Access provides several alternatives for

Question 8

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) Tab Order 
B) Add-ins 
C) Property Sheet 
D) Form 
A) Tab Order 
B) Add-ins 
C) Property Sheet 
D) Form

Question 9

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

Question 10

Any text entered as the Description of a field is displayed as help text on forms.

Accepted Answer

A) True 
 B)False

Question 11

In Access,to modify the design of a default table,one must select the Relationships option in the DESIGN tab.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Explain the procedure for creating a new database using Microsoft Access.

Accepted Answer

To create a new database,select Blank de

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

In Access,an underlined attribute is a primary key and an italicised attribute is a foreign key.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

To create a report with data from a single table,we must use the Report Wizard.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following statements is true about a primary key in Microsoft Access?

Accepted Answer

A) A primary key should have its Required Field property set to "No." 
B) A foreign key can be used as one of the fields for a primary key. 
C) Only one field in a table can be marked as the primary key. 
D) The attribute which is italicised is the primary key. 
A) A primary key should have its Required Field property set to "No." 
B) A foreign key can be used as one of the fields for a primary key. 
C) Only one field in a table can be marked as the primary key. 
D) The attribute which is italicised is the primary key.

Exam 18: Using Microsoft Access 2013

Before using any DBMS,a user should create a data model based on the users' requirements.

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

How can a user generate reports in Microsoft Access?

Access opens a new database by ________.

Which of the following statements is true about reports in Access?

Which of the following is a valid entry for Field Size if the Data Type of the field is "Number"?

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

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

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

Any text entered as the Description of a field is displayed as help text on forms.

In Access,to modify the design of a default table,one must select the Relationships option in the DESIGN tab.

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

Explain the procedure for creating a new database using Microsoft Access.

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

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

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.

In Access,an underlined attribute is a primary key and an italicised attribute is a foreign key.

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

To create a report with data from a single table,we must use the Report Wizard.

Which of the following statements is true about a primary key in Microsoft Access?

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organisations 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

Collaboration 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 Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters