Question 1

Explain how to run an SQL query in Microsoft Access.

Accepted Answer

[Note that this is actually covered in Chapter 2,but it is important to understand how to do this as part of using Microsoft Access].To run an SQL query in Microsoft Access,start on the Create command tab.Click the Query Design button,which will display a Query window together with the Show Tables dialog box.Close the Show Table dialog box by clicking the Close button,and then click the SQL View button on the Design command tab to switch the Query window to SQL View.An SQL statement can now be entered into the Query window.To execute the query after the SQL statement is complete,click the Run button on the Design command tab.

Question 2

The Microsoft Access 2010 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. E

Question 3

Describe the Microsoft Access 2010 Navigation Pane.

Accepted Answer

The Navigation Pane is an area on the left side of the Access 2010 that controls the display of database objects such as table objects,query objects,and so on.The Navigation Pane is the main tool for accessing the various objects in the database.Double-clicking on an object will open it in a tabbed document window.Right-clicking on an object will display a shortcut menu associated with that object.The Navigation Pane can be hidden and restored using a button at the top of the Navigation Pane.

Question 4

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 5

The Microsoft Access window Close button is actually a close-and-exit button.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

By default,Microsoft Access 20

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The default Microsoft Access 2010 command tabs are Home,Create,Internal Data and Database Tools.

Accepted Answer

A) True 
 B)False

Question 11

What is the Microsoft Office Fluent User Interface?

Accepted Answer

The Microsoft Office Fluent User Interfa

Question 12

In Microsoft Access,a 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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

Microsoft Access uses the AutoNumber data type to create surrogate keys.

Accepted Answer

A) True 
 B)False

Question 17

To start Microsoft Access 2010,use the command:

Accepted Answer

Question 18

The Microsoft Access 2010 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.

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 16: Microsoft Access 2010

Explain how to run an SQL query in Microsoft Access.

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

Describe the Microsoft Access 2010 Navigation Pane.

Microsoft Access SQL commands are run in:

The Microsoft Access window Close button is actually a close-and-exit button.

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

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

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

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

The default Microsoft Access 2010 command tabs are Home,Create,Internal Data and Database Tools.

What is the Microsoft Office Fluent User Interface?

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

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

The Microsoft Access application generator is not responsible for:

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

Microsoft Access uses the AutoNumber data type to create surrogate keys.

To start Microsoft Access 2010,use the command:

The Microsoft Access 2010 Close button is actually a:

To open a new Microsoft Access Query window:

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

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