Question 1

Tables are created in Microsoft Access using the ________ button.

Accepted Answer

A) Table Design 
B) Table Wizard 
C) Create Table 
D) Create Relation 
A) Table Design 
B) Table Wizard 
C) Create Table 
D) Create Relation

Question 2

Explain how to create a relationship in Microsoft Access.Include an example.

Accepted Answer

In Microsoft Access relationships are cr

Question 3

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 dragging the primary key column of one table onto the primary key column of the other table in the Relationships window 
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 
A) by entering the name of the foreign key in the appropriate table in Design View 
B) by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window 
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

Question 4

Microsoft uses the term object as a general name for various parts of a Microsoft Access 2013 database.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

Question 6

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 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 Query Design button on the Command tab

Question 7

Microsoft Access database objects are displayed in the Browser Pane.

Accepted Answer

A) True 
 B)False

Question 8

What is the Microsoft Office Fluent User Interface?

Accepted Answer

The Microsoft Office Fluent User Interfa

Question 9

What Microsoft Access file format is used by default in Microsoft Access 2013? When was it introduced,and what was the previous format?

Accepted Answer

By default,Microsoft Access 20

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Microsoft Access Datasheet view can be used for all of the following tasks except ________.

Accepted Answer

A) writing join queries 
B) inserting new rows 
C) updating existing rows 
D) deleting rows 
A) writing join queries 
B) inserting new rows 
C) updating existing rows 
D) deleting rows

Question 13

Microsoft Access wizards allow easy building of forms and reports.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Question 16

Microsoft Access SQL commands are run in ________.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A personal database combines a DBMS with

Question 20

The Microsoft Access 2013 Ribbon contains all of the following command tabs except ________.

Accepted Answer

A) HOME 
B) SQL 
C) EXTERNAL DATA 
D) DATABASE TOOLS 
A) HOME 
B) SQL 
C) EXTERNAL DATA 
D) DATABASE TOOLS

Exam 15: Getting Started With Microsoft Access 2013

Tables are created in Microsoft Access using the ________ button.

Explain how to create a relationship in Microsoft Access.Include an example.

In Microsoft Access,any relationship between two tables is created ________.

Microsoft uses the term object as a general name for various parts of a Microsoft Access 2013 database.

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

To open a new Microsoft Access Query window ________.

Microsoft Access database objects are displayed in the Browser Pane.

What is the Microsoft Office Fluent User Interface?

What Microsoft Access file format is used by default in Microsoft Access 2013? When was it introduced,and what was the previous format?

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

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

Microsoft Access Datasheet view can be used for all of the following tasks except ________.

Microsoft Access wizards allow easy building of forms and reports.

Microsoft Access is a good tool for forms and reports because ________.

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

Microsoft Access SQL commands are run in ________.

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

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

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

The Microsoft Access 2013 Ribbon contains all of the following command tabs except ________.

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