Question 1

Explain how to create a relationship in Microsoft Access.

Accepted Answer

In Microsoft Access relationships are cr

Question 2

Microsoft Access is considered a "personal database" product.What is a personal database?

Accepted Answer

A personal database combines a DBMS with

Question 3

Microsoft Access is a personal database system,and a personal database system is characterized by:

Accepted Answer

A) the DBMS removing the metadata from the database. 
B) the DBMS product taking the role of the DBMS and the database application generator. 
C) the database being stored inside the DBMS. 
D) the DBMS product being limited to a maximum of ten tables in any given database. 
E) the DBMS not supporting indexes. 
A) the DBMS removing the metadata from the database. 
B) the DBMS product taking the role of the DBMS and the database application generator. 
C) the database being stored inside the DBMS. 
D) the DBMS product being limited to a maximum of ten tables in any given database. 
E) the DBMS not supporting indexes.

Question 4

Microsoft Access database objects are displayed in the Browser Pane.

Accepted Answer

A) True 
 B)False

Question 5

Describe the tabbed Ribbon.

Accepted Answer

The tabbed Ribbon,or just Ribbon,is a vi

Question 6

In Microsoft Access,the primary key must be set as a field property while the table is in Design View.

Accepted Answer

A) True 
 B)False

Question 7

The Microsoft Access application generator provides the ability to create and store forms,reports,and queries.

Accepted Answer

A) True 
 B)False

Question 8

Most Microsoft Access 2010 commands and tools are available on the tabbed Ribbon.

Accepted Answer

A) True 
 B)False

Question 9

In Microsoft Access,tables are added to a Query window by:

Accepted Answer

A) selecting the tables from the Use Table dialog box. 
B) selecting the tables from the Show Table dialog box. 
C) selecting the tables from the Tables section of the Navigation Pane. 
D) selecting the tables from the Queries section of the Navigation Pane. 
E) selecting the tables from the Relationships window. 
A) selecting the tables from the Use Table dialog box. 
B) selecting the tables from the Show Table dialog box. 
C) selecting the tables from the Tables section of the Navigation Pane. 
D) selecting the tables from the Queries section of the Navigation Pane. 
E) selecting the tables from the Relationships window.

Question 10

Microsoft Access 2010 uses the Microsoft Office Fluent User Interface.

Accepted Answer

A) True 
 B)False

Question 11

Microsoft Access is a personal database that combines a DBMS with an application generator.

Accepted Answer

A) True 
 B)False

Question 12

In Microsoft Access,referential integrity constraints are created:

Accepted Answer

A) by setting a property value on the primary key in the table which contains it. 
B) by setting a property value on the foreign key in the table which contains it. 
C) by setting a property value on the primary key in the Relationships window. 
D) by setting a property value on the foreign key in the Relationships window. 
E) by checking the Enforce Referential Integrity check box in Edit Relationships dialog box. 
A) by setting a property value on the primary key in the table which contains it. 
B) by setting a property value on the foreign key in the table which contains it. 
C) by setting a property value on the primary key in the Relationships window. 
D) by setting a property value on the foreign key in the Relationships window. 
E) by checking the Enforce Referential Integrity check box in Edit Relationships dialog box.

Question 13

Microsoft Access wizards allow easy building of forms and reports.

Accepted Answer

A) True 
 B)False

Question 14

Microsoft Access database objects are displayed in the:

Accepted Answer

A) Navigation Pane. 
B) Browser Pane. 
C) Object Browser Pane. 
D) Gallery Pane. 
E) Gallery. 
A) Navigation Pane. 
B) Browser Pane. 
C) Object Browser Pane. 
D) Gallery Pane. 
E) Gallery.

Question 15

Microsoft Access can run QBE queries,but not SQL queries.

Accepted Answer

A) True 
 B)False

Question 16

Microsoft Access is a good tool for forms and reports because:

Accepted Answer

A) the form and report generators do not exist within Access itself. 
B) Access forms and reports are very simplistic. 
C) Access wizards make it easy to create the forms and reports. 
D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. 
E) Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets. 
A) the form and report generators do not exist within Access itself. 
B) Access forms and reports are very simplistic. 
C) Access wizards make it easy to create the forms and reports. 
D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. 
E) Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets.

Question 17

Each command tab contains a set of tools grouped into sets of related commands.

Accepted Answer

A) True 
 B)False

Question 18

The Microsoft Access data type of AutoNumber is used when there is a specific need for a:

Accepted Answer

A) foreign key. 
B) primary key. 
C) surrogate key. 
D) spare key. 
E) secondary key. 
A) foreign key. 
B) primary key. 
C) surrogate key. 
D) spare key. 
E) secondary key.

Question 19

In Microsoft Access,the relationship between two tables is not actually created until:

Accepted Answer

A) the OK button in the Create Relationships dialog box is clicked. 
B) the Create button in the Create Relationships dialog box is clicked. 
C) the OK button in the Edit Relationships dialog box is clicked. 
D) the Create button in the Edit Relationships dialog box is clicked. 
E) the Join button in the Edit Relationships dialog box is clicked. 
A) the OK button in the Create Relationships dialog box is clicked. 
B) the Create button in the Create Relationships dialog box is clicked. 
C) the OK button in the Edit Relationships dialog box is clicked. 
D) the Create button in the Edit Relationships dialog box is clicked. 
E) the Join button in the Edit Relationships dialog box is clicked.

Question 20

In Microsoft Access,relationships between tables are created:

Accepted Answer

A) by the Relationships button on the Create command tab. 
B) by the Relationships button on the Home command tab. 
C) in the Relationships window. 
D) in the Table window of the table containing the primary key. 
E) in the Table window of the table containing the foreign key. 
A) by the Relationships button on the Create command tab. 
B) by the Relationships button on the Home command tab. 
C) in the Relationships window. 
D) in the Table window of the table containing the primary key. 
E) in the Table window of the table containing the foreign key.

Exam 16: Microsoft Access 2010

Explain how to create a relationship in Microsoft Access.

Microsoft Access is considered a "personal database" product.What is a personal database?

Microsoft Access is a personal database system,and a personal database system is characterized by:

Microsoft Access database objects are displayed in the Browser Pane.

Describe the tabbed Ribbon.

In Microsoft Access,the primary key must be set as a field property while the table is in Design View.

The Microsoft Access application generator provides the ability to create and store forms,reports,and queries.

Most Microsoft Access 2010 commands and tools are available on the tabbed Ribbon.

In Microsoft Access,tables are added to a Query window by:

Microsoft Access 2010 uses the Microsoft Office Fluent User Interface.

Microsoft Access is a personal database that combines a DBMS with an application generator.

In Microsoft Access,referential integrity constraints are created:

Microsoft Access wizards allow easy building of forms and reports.

Microsoft Access database objects are displayed in the:

Microsoft Access can run QBE queries,but not SQL queries.

Microsoft Access is a good tool for forms and reports because:

Each command tab contains a set of tools grouped into sets of related commands.

The Microsoft Access data type of AutoNumber is used when there is a specific need for a:

In Microsoft Access,the relationship between two tables is not actually created until:

In Microsoft Access,relationships between tables are created:

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters