Question 1

Explain the difference between a primary key and a foreign key.

Accepted Answer

The primary key may consist of one or mo

Question 2

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Accepted Answer

A)  Tab, Insert 
B)  Enter, PgDn 
C)  Insert, PgUp 
D)  Tab, Enter 
A)  Tab, Insert 
B)  Enter, PgDn 
C)  Insert, PgUp 
D)  Tab, Enter

Question 3

It is possible to view all Access objects in the Navigation Pane. _________________________

Accepted Answer

A) True 
 B)False

Question 4

All of the data in a relational database are contained in ____________________.

Accepted Answer

The answer of All of the data in a relational...

Question 5

Compacting a database rearranges the data and objects in a database to decrease its file size.

Accepted Answer

A) True 
 B)False

Question 6

Each column in an Access table datasheet represents a ____.

Accepted Answer

A)  query 
B)  record 
C)  field 
D)  primary key 
A)  query 
B)  record 
C)  field 
D)  primary key

Question 7

-In the accompanying figure, the red brackets designate which element of the Access 2013 window?

Accepted Answer

A)  Navigation Pane 
B)  Shutter Bar Open/Close button 
C)  Navigation Bar 
D)  datasheet window 
A)  Navigation Pane 
B)  Shutter Bar Open/Close button 
C)  Navigation Bar 
D)  datasheet window

Question 8

Green Thumb Nursery is analyzing wholesale customer purchases and would like to create an Access database of wholesale customers and the wholesale prices for all of the nursery's products. When designing the database, it is necessary to determine the number of tables needed to provide the owner with the names, addresses, and contact information of the customers, as well as the product names and wholesale prices for each product. In addition, it is neccessary to know which products have been purchased by each customer. Andrea, the owner, wants to be able to print reports that show which customers bought specific products from the database. Answer the following questions related to this case.
-Which Access 2013 tool should be used to create the report Andrea wants which will show the customer name and the products purchased?

Accepted Answer

The answer of Green Thumb Nursery is analyzing wholesale customer...

Question 9

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process?

Accepted Answer

A)  save the table object 
B)  save the database 
C)  save the record 
D)  save the field 
A)  save the table object 
B)  save the database 
C)  save the record 
D)  save the field

Question 10

-Which of the following is an Access 2013 database object?

Accepted Answer

A)  record 
B)  field 
C)  data 
D)  table 
A)  record 
B)  field 
C)  data 
D)  table

Question 11

When using the copy/paste method to copy records from one table to another table, the two tables must have the same fields, design, and order, known as the table ____________________.

Accepted Answer

The answer of When using the copy/paste method to copy...

Question 12

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

Accepted Answer

A) True 
 B)False

Question 13

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

Accepted Answer

A) True 
 B)False

Question 14

A relationship between two tables in a database is formed using a(n) Backstage field. _________________________

Accepted Answer

A) True 
 B)False

Question 15

Access report printing options may be changed using the Navigation dialog box. _________________________

Accepted Answer

A) True 
 B)False

Question 16

Data organized as a collection of tables creates this type of data system.

Accepted Answer

A)  database 
B)  database management system (DBMS) 
C)  primary key system 
D)  relational database management system 
A)  database 
B)  database management system (DBMS) 
C)  primary key system 
D)  relational database management system

Question 17

A query is used to enter, edit, and view records in a database.

Accepted Answer

A) True 
 B)False

Question 18

MATCHING
-The Access 2013 view that allows the user to manage files and options.

Accepted Answer

A) field value 
B) primary key 
C) Backstage view 
D) data type 
E) Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab 
A) field value 
B) primary key 
C) Backstage view 
D) data type 
E) Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Question 19

The default primary key for an Access database is the ID field. _________________________

Accepted Answer

A) True 
 B)False

Question 20

MATCHING
-A field, or collection of fields, whose values are used to uniquely identify each record in a table.

Accepted Answer

A) field value 
B) primary key 
C) Backstage view 
D) data type 
E) Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab 
A) field value 
B) primary key 
C) Backstage view 
D) data type 
E) Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Explain the difference between a primary key and a foreign key.

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

It is possible to view all Access objects in the Navigation Pane. _________________________

All of the data in a relational database are contained in ____________________.

Compacting a database rearranges the data and objects in a database to decrease its file size.

Each column in an Access table datasheet represents a ____.

-In the accompanying figure, the red brackets designate which element of the Access 2013 window?

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process?

-Which of the following is an Access 2013 database object?

When using the copy/paste method to copy records from one table to another table, the two tables must have the same fields, design, and order, known as the table ____________________.

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

A relationship between two tables in a database is formed using a(n) Backstage field. _________________________

Access report printing options may be changed using the Navigation dialog box. _________________________

Data organized as a collection of tables creates this type of data system.

A query is used to enter, edit, and view records in a database.

MATCHING -The Access 2013 view that allows the user to manage files and options.

The default primary key for an Access database is the ID field. _________________________

MATCHING -A field, or collection of fields, whose values are used to uniquely identify each record in a table.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 1: Creating a Database

Explain the difference between a primary key and a foreign key.

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

It is possible to view all Access objects in the Navigation Pane. _________________________

All of the data in a relational database are contained in ____________________.

Compacting a database rearranges the data and objects in a database to decrease its file size.

Each column in an Access table datasheet represents a ____.

-In the accompanying figure, the red brackets designate which element of the Access 2013 window?

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process?

-Which of the following is an Access 2013 database object?

When using the copy/paste method to copy records from one table to another table, the two tables must have the same fields, design, and order, known as the table ____________________.

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

The default sort order for records in an Access table is based on the values in the primary key field. _________________________

A relationship between two tables in a database is formed using a(n) Backstage field. _________________________

Access report printing options may be changed using the Navigation dialog box. _________________________

Data organized as a collection of tables creates this type of data system.

A query is used to enter, edit, and view records in a database.

MATCHING -The Access 2013 view that allows the user to manage files and options.

The default primary key for an Access database is the ID field. _________________________

MATCHING -A field, or collection of fields, whose values are used to uniquely identify each record in a table.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters