Question 1

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 2

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

Accepted Answer

The primary key may consist of one or mo

Question 3

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

Accepted Answer

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

Question 4

Clicking or tapping this navigation button 
   moves the insertion point to the ____________________ in a table.

Accepted Answer

The answer of Clicking or tapping this navigation button 
...

Question 5

What is the purpose of the primary key?

Accepted Answer

A)  to uniquely identify each record in a table 
B)  to uniquely identify each table in a database 
C)  to create a relationship between two tables in a database 
D)  to create a relationship for queries in a database 
A)  to uniquely identify each record in a table 
B)  to uniquely identify each table in a database 
C)  to create a relationship between two tables in a database 
D)  to create a relationship for queries in a database

Question 6

An important reference tool available in Access 2013, which may be used to assist a user with problems that might occur, is the ____________________ system.

Accepted Answer

The answer of An important reference tool available in Access...

Question 7

A question asked about the data stored in a database is called a primary key.

Accepted Answer

A) True 
 B)False

Question 8

The accompanying figure shows the first dialog box for the ____ Wizard.

Accepted Answer

A)  Simple Form 
B)  Simple Report 
C)  Simple Query 
D)  Simple Table 
A)  Simple Form 
B)  Simple Report 
C)  Simple Query 
D)  Simple Table

Question 9

In the accompanying figure, the Table Tools tab is an example of this type of tab that appears and provides options for working with a specific object when the object is selected.

Accepted Answer

A)  auto tab 
B)  contextual tab 
C)  object tab 
D)  data tab 
A)  auto tab 
B)  contextual tab 
C)  object tab 
D)  data tab

Question 10

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

Accepted Answer

A)  creating reports using Access 
B)  related databases 
C)  programming tasks 
D)  queries 
A)  creating reports using Access 
B)  related databases 
C)  programming tasks 
D)  queries

Question 11

The default ____________________ provided by Access is the ID field.

Accepted Answer

The answer of The default ____________________ provided by Access is...

Question 12

In the accompanying figure, which number corresponds to the datasheet selector which selects all records in a table?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 13

This icon   represents which Access 2013 object?

Accepted Answer

A)  form 
B)  table 
C)  query 
D)  report 
A)  form 
B)  table 
C)  query 
D)  report

Question 14

When copying and pasting records from one table to another, the records must first be copied to the ____.

Accepted Answer

A)  database 
B)  query 
C)  storage device 
D)  clipboard 
A)  database 
B)  query 
C)  storage device 
D)  clipboard

Question 15

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 16

Match between columns
                        Premises: The Access 2013 view that allows the user to manage files and options.

Accepted Answer

The Answer of primary key and field value and Current is...

Question 17

Case 1-3
   
Main Street Catering has created a database with one table containing customer information. When creating the table, Marissa did not follow recommendations for naming fields in a table. There are a number of changes that would make the field names more useful and follow field naming recommendations. Using the accompanying figure, answer the following questions about the CustomerTable.Which field is the primary key (unique identifier) in the Customer Table?

Accepted Answer

The answer of Case 1-3
   
Main Street Catering...

Question 18

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Accepted Answer

The answer of The process of decreasing the file size...

Question 19

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 20

Which Access 2013 view contains commands used to manage Access files and options?

Accepted Answer

A)  Datasheet view 
B)  Design view 
C)  Backstage view 
D)  Form view 
A)  Datasheet view 
B)  Design view 
C)  Backstage view 
D)  Form view

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?

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

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

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

What is the purpose of the primary key?

An important reference tool available in Access 2013, which may be used to assist a user with problems that might occur, is the ____________________ system.

A question asked about the data stored in a database is called a primary key.

The accompanying figure shows the first dialog box for the ____ Wizard.

In the accompanying figure, the Table Tools tab is an example of this type of tab that appears and provides options for working with a specific object when the object is selected.

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

The default ____________________ provided by Access is the ID field.

In the accompanying figure, which number corresponds to the datasheet selector which selects all records in a table?

This icon represents which Access 2013 object?

When copying and pasting records from one table to another, the records must first be copied to the ____.

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

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

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

Which Access 2013 view contains commands used to manage Access files and options?

Managing Your Files

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 2: Creating a Database

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?

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

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

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

What is the purpose of the primary key?

An important reference tool available in Access 2013, which may be used to assist a user with problems that might occur, is the ____________________ system.

A question asked about the data stored in a database is called a primary key.

The accompanying figure shows the first dialog box for the ____ Wizard.

In the accompanying figure, the Table Tools tab is an example of this type of tab that appears and provides options for working with a specific object when the object is selected.

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

The default ____________________ provided by Access is the ID field.

In the accompanying figure, which number corresponds to the datasheet selector which selects all records in a table?

This icon represents which Access 2013 object?

When copying and pasting records from one table to another, the records must first be copied to the ____.

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

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

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

Which Access 2013 view contains commands used to manage Access files and options?

Managing Your Files

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters