Question 1

Microsoft Access 2010 database files are stored using the files extension of:

Accepted Answer

A) adb. 
B) asp. 
C) .accdb. 
D) mdb. 
E) .sql. 
A) adb. 
B) asp. 
C) .accdb. 
D) mdb. 
E) .sql. C

Question 2

Explain how to create a relationship in Microsoft Access.

Accepted Answer

In Microsoft Access relationships are created in the Relationships window,which is opened by using the Relationships button on the Database Tools command tab.Once the Relationships window is open,the needed database tables are displayed using the Show Table dialog box.A relationship is initiated by dragging the primary of one table on top and dropping it on top of the corresponding foreign key in the related table.At this point the Edit Relationships dialog box is displayed.A referential integrity constraint can be set in this box by checking the Enforce Referential Integrity check box.The relationship is actually created by clicking the Create button in the Edit Relationship dialog box.

Question 3

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Accepted Answer

A) True 
 B)False  False

Question 4

To start Microsoft Access 2013,use the Start | All Programs | Microsoft Office | Microsoft Access 2013 command.

Accepted Answer

A) True 
 B)False

Question 5

In addition to the standard Ribbon command tabs,Microsoft Access 2013 also includes:

Accepted Answer

A) optional command tabs. 
B) contextual command tabs. 
C) quick access tabs. 
D) gallery tabs. 
E) template tabs. 
A) optional command tabs. 
B) contextual command tabs. 
C) quick access tabs. 
D) gallery tabs. 
E) template tabs.

Question 6

Microsoft Access SQL commands are run within the SQL View of a Query window.

Accepted Answer

A) True 
 B)False

Question 7

Microsoft Access databases are stored using the file extension .accdb.

Accepted Answer

A) True 
 B)False

Question 8

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 9

The default Microsoft Access 2013 command tabs are HOME,CREATE,INTERNAL DATA and DATABASE TOOLS.

Accepted Answer

A) True 
 B)False

Question 10

Microsoft Access database objects are displayed in the Browser Pane.

Accepted Answer

A) True 
 B)False

Question 11

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 12

What is the Microsoft Office Fluent User Interface?

Accepted Answer

The Microsoft Office Fluent User Interfa

Question 13

The Microsoft Access 2013 Ribbon contains which of the following command tabs?

Accepted Answer

A) HOME 
B) CREATE 
C) EXTERNAL DATA 
D) DATABASE TOOLS 
E) All of the above 
A) HOME 
B) CREATE 
C) EXTERNAL DATA 
D) DATABASE TOOLS 
E) All of the above

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

Accepted Answer

A) True 
 B)False

Question 17

Explain how to run an SQL query in Microsoft Access

Accepted Answer

[Note that this is actually covered in C

Question 18

What Microsoft Access file format is used by default in Microsoft Access 2013?

Accepted Answer

By default,Microsoft Access 20

Question 19

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 20

The Microsoft Access 2013 Close button is actually a:

Accepted Answer

A) Save and Close button. 
B) Save and Exit button. 
C) Close and Exit button. 
D) Print and Close button. 
E) Print and Exit button. 
A) Save and Close button. 
B) Save and Exit button. 
C) Close and Exit button. 
D) Print and Close button. 
E) Print and Exit button.

Exam 13: Microsoft Access 2013

Microsoft Access 2010 database files are stored using the files extension of:

Explain how to create a relationship in Microsoft Access.

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

To start Microsoft Access 2013,use the Start | All Programs | Microsoft Office | Microsoft Access 2013 command.

In addition to the standard Ribbon command tabs,Microsoft Access 2013 also includes:

Microsoft Access SQL commands are run within the SQL View of a Query window.

Microsoft Access databases are stored using the file extension .accdb.

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

The default Microsoft Access 2013 command tabs are HOME,CREATE,INTERNAL DATA and DATABASE TOOLS.

Microsoft Access database objects are displayed in the Browser Pane.

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

What is the Microsoft Office Fluent User Interface?

The Microsoft Access 2013 Ribbon contains which of the following command tabs?

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

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

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

Explain how to run an SQL query in Microsoft Access

What Microsoft Access file format is used by default in Microsoft Access 2013?

Microsoft Access database objects are displayed in the:

The Microsoft Access 2013 Close button is actually a:

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