Question 1

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

Accepted Answer

A personal database combines a DBMS with

Question 2

Describe the Microsoft Access 2013 Navigation Pane

Accepted Answer

The Navigation Pane is an area on the le

Question 3

The Microsoft Access 2013 tabbed Ribbon contains a set of control tabs.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

In Microsoft Access,relationships between tables are created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 7

What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?

Accepted Answer

A surrogate key is usually a computer-ge

Question 8

Microsoft Access wizards allow easy building of forms and reports.

Accepted Answer

A) True 
 B)False

Question 9

Microsoft Access SQL commands are run in:

Accepted Answer

A) the SQL window. 
B) the QBE window. 
C) the Query View of an SQL window. 
D) the Design View of a Query window. 
E) the SQL View of a Query window. 
A) the SQL window. 
B) the QBE window. 
C) the Query View of an SQL window. 
D) the Design View of a Query window. 
E) the SQL View of a Query window.

Question 10

To open a new Microsoft Access Query window:

Accepted Answer

A) click the New button on the Home command tab. 
B) click the New Query button on the Home command tab. 
C) click the Create Query button on the Create command tab. 
D) click the New Query in Design view button on the Create command tab. 
E) click the Query Design button on the Command tab. 
A) click the New button on the Home command tab. 
B) click the New Query button on the Home command tab. 
C) click the Create Query button on the Create command tab. 
D) click the New Query in Design view button on the Create command tab. 
E) click the Query Design button on the Command tab.

Question 11

In Microsoft Access,any relationship between two tables is created:

Accepted Answer

A) by entering the name of the foreign key in the appropriate table in Design View. 
B) by entering the name of the primary key in the appropriate table in Design View. 
C) by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window. 
D) by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window. 
E) by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window. 
A) by entering the name of the foreign key in the appropriate table in Design View. 
B) by entering the name of the primary key in the appropriate table in Design View. 
C) by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window. 
D) by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window. 
E) by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window.

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

In addition to the basic command tabs,Microsoft Access 2013 also has additional contextual command tabs.

Accepted Answer

A) True 
 B)False

Question 14

To start Microsoft Access 2013 in Windows 8,use the command:

Accepted Answer

Question 15

Describe the tabbed Ribbon.

Accepted Answer

The tabbed Ribbon,or just Ribbon,is a vi

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The Microsoft Access application generator is not responsible for:

Accepted Answer

A) creating forms. 
B) creating reports. 
C) creating queries. 
D) creating tables. 
E) storing queries. 
A) creating forms. 
B) creating reports. 
C) creating queries. 
D) creating tables. 
E) storing queries.

Question 18

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.

Question 19

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 20

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 the 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 the Edit Relationships dialog box.

Exam 13: Microsoft Access 2013

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

Describe the Microsoft Access 2013 Navigation Pane

The Microsoft Access 2013 tabbed Ribbon contains a set of control tabs.

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

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

In Microsoft Access,relationships between tables are created in the Relationships window.

What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?

Microsoft Access wizards allow easy building of forms and reports.

Microsoft Access SQL commands are run in:

To open a new Microsoft Access Query window:

In Microsoft Access,any relationship between two tables is created:

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

In addition to the basic command tabs,Microsoft Access 2013 also has additional contextual command tabs.

To start Microsoft Access 2013 in Windows 8,use the command:

Describe the tabbed Ribbon.

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

The Microsoft Access application generator is not responsible for:

In Microsoft Access,relationships between tables are created:

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

In Microsoft Access,referential integrity constraints 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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and 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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters