Question 1

To open a new Microsoft Access Query window,click the Query Design button on the Create command.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Microsoft Access 2013 database files are stored using the file extension of ________.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Data in columns defined using which of the following data types in Microsoft Access cannot be changed by the user?

Accepted Answer

A) Long Text 
B) Date/Time 
C) Number 
D) AutoNumber 
A) Long Text 
B) Date/Time 
C) Number 
D) AutoNumber

Question 6

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 DBMS not supporting indexes 
D) the DBMS product being limited to a maximum of ten tables in any given database 
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 DBMS not supporting indexes 
D) the DBMS product being limited to a maximum of ten tables in any given database

Question 7

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 
A) Save and Close button 
B) Save and Exit button 
C) Close and Exit button 
D) Print and Close button

Question 8

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 
A) optional command tabs 
B) contextual command tabs 
C) quick access tabs 
D) gallery tabs

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 2013 uses the Access 2003 .mdb file format as the default file format for database files.

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) secondary key 
A) foreign key 
B) primary key 
C) surrogate key 
D) secondary key

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

To open a new Microsoft Access Query window,click the Query Design button on the Create command.

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

Microsoft Access 2013 database files are stored using the file extension of ________.

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

Data in columns defined using which of the following data types in Microsoft Access cannot be changed by the user?

Microsoft Access is a personal database system,and a personal database system is characterized by ________.

The Microsoft Access 2013 Close button is actually a ________.

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

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

Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.

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

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

In Microsoft Access,relationships between tables are created ________.

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters

Exam 15: Getting Started With Microsoft Access 2013

To open a new Microsoft Access Query window,click the Query Design button on the Create command.

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

Microsoft Access 2013 database files are stored using the file extension of ________.

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

Data in columns defined using which of the following data types in Microsoft Access cannot be changed by the user?

Microsoft Access is a personal database system,and a personal database system is characterized by ________.

The Microsoft Access 2013 Close button is actually a ________.

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

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

Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for database files.

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

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

In Microsoft Access,relationships between tables are created ________.

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters