Question 1

How can one identify a primary key in a data model?

Accepted Answer

A)  It is underlined. 
B)  It is italicized. 
C)  It has the title "primary key" next to it. 
D)  It is bold. 
A)  It is underlined. 
B)  It is italicized. 
C)  It has the title "primary key" next to it. 
D)  It is bold.

Question 2

Access does not remember relationships between tables.

Accepted Answer

A) True 
 B)False

Question 3

A table should have multiple primary keys.

Accepted Answer

A) True 
 B)False

Question 4

Ramona works for City Hospital. She wants to fill in details of the hospital staff into the database, but she does not want to use the default table display. She prefers a design that would be easier to use and view. Which of the following options would suit Ramona's requirements?

Accepted Answer

A)  form 
B)  tab order 
C)  property sheet 
D)  table 
A)  form 
B)  tab order 
C)  property sheet 
D)  table

Question 5

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

Accepted Answer

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

Question 6

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 7

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

Accepted Answer

After creating tables in Microsoft Acces

Question 8

To delete data in Microsoft Access, a user should double-click the table name in the left hand pane.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Leonard, a librarian, needs to create a report using data from a table that lists books on management studies and another that lists books on law. Which of the following tools will help Leonard create his report?

Accepted Answer

A)  Report Wizard 
B)  Navigation tab 
C)  Report Design 
D)  SharePoint lists 
A)  Report Wizard 
B)  Navigation tab 
C)  Report Design 
D)  SharePoint lists

Question 15

In Access, what is the next step after the tables are created?

Accepted Answer

A)  The relationships are defined. 
B)  The referential integrity is created. 
C)  The connection is made between all keys. 
D)  The foreign keys are created. 
A)  The relationships are defined. 
B)  The referential integrity is created. 
C)  The connection is made between all keys. 
D)  The foreign keys are created.

Question 16

All relational database management system (DBMS) products can process the ________ query language.

Accepted Answer

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

Question 17

By default, for queries of two or more tables, Microsoft Access shows only those rows that have value matches in both tables.

Accepted Answer

A) True 
 B)False

Question 18

In Microsoft Access, a report is created using a process similar to that for forms.

Accepted Answer

A) True 
 B)False

Question 19

In Microsoft Access, to create a relationship between one row of a table and an unlimited number of rows in another table, users should ________.

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 of 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 of 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 20

It is difficult to make a data entry form more pleasing and easier to use.

Accepted Answer

A) True 
 B)False

Exam 18: Using Microsoft Access 2016

How can one identify a primary key in a data model?

Access does not remember relationships between tables.

A table should have multiple primary keys.

Ramona works for City Hospital. She wants to fill in details of the hospital staff into the database, but she does not want to use the default table display. She prefers a design that would be easier to use and view. Which of the following options would suit Ramona's requirements?

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

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

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

To delete data in Microsoft Access, a user should double-click the table name in the left hand pane.

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

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

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.

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

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

Leonard, a librarian, needs to create a report using data from a table that lists books on management studies and another that lists books on law. Which of the following tools will help Leonard create his report?

In Access, what is the next step after the tables are created?

All relational database management system (DBMS) products can process the ________ query language.

By default, for queries of two or more tables, Microsoft Access shows only those rows that have value matches in both tables.

In Microsoft Access, a report is created using a process similar to that for forms.

In Microsoft Access, to create a relationship between one row of a table and an unlimited number of rows in another table, users should ________.

It is difficult to make a data entry form more pleasing and easier to use.

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2016

Database Design

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning Erp Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters