Question 1

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 2

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.Field names may have up to 64 characters. However, one of the recommendations is to use concise field names. Which field names could be changed to be more concise?

Accepted Answer

All fields except Cu

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Accepted Answer

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

Question 7

What function does compacting an Access database perform other than reducing the file size?

Accepted Answer

A)  sorting the database 
B)  querying the database 
C)  saving the database 
D)  repairing the database 
A)  sorting the database 
B)  querying the database 
C)  saving the database 
D)  repairing the database

Question 8

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

Accepted Answer

A) True 
 B)False

Question 9

Case 1 -2
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 Case 1 -2
Green Thumb Nursery is analyzing...

Question 10

Each record in a table is uniquely identified by a foreign key.

Accepted Answer

A) True 
 B)False

Question 11

Which Ribbon group allows you to add fields to an Access table with defined data types?

Accepted Answer

A)  Properties 
B)  Formatting 
C)  Field Validation 
D)  Add & Delete 
A)  Properties 
B)  Formatting 
C)  Field Validation 
D)  Add & Delete

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Which data type allows field values to contain letters, digits, and other characters?

Accepted Answer

A)  Short Text 
B)  AutoNumber 
C)  Currency 
D)  Date/Time 
A)  Short Text 
B)  AutoNumber 
C)  Currency 
D)  Date/Time

Question 14

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 15

Access reports are based on a selected ____________________ or ____________________.

Accepted Answer

The answer of Access reports are based on a selected...

Question 16

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

Accepted Answer

A)  scroll the vertical scroll bar 
B)  scroll the horizontal scroll bar 
C)  cllick on the Navigation Pane 
D)  right click 
A)  scroll the vertical scroll bar 
B)  scroll the horizontal scroll bar 
C)  cllick on the Navigation Pane 
D)  right click

Question 17

A database or a relational database is a collection of related tables.

Accepted Answer

A) True 
 B)False

Question 18

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 19

The query results are stored in the database in which the query has been created. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

This icon represents which Access 2013 object?

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

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.

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

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

What function does compacting an Access database perform other than reducing the file size?

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

Each record in a table is uniquely identified by a foreign key.

Which Ribbon group allows you to add fields to an Access table with defined data types?

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

Which data type allows field values to contain letters, digits, and other characters?

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

Access reports are based on a selected or .

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

A database or a relational database is a collection of related tables.

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

The query results are stored in the database in which the query has been created. _________________________

This icon represents which Access 2013 object?

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

This icon represents which Access 2013 object?

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

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.

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

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

What function does compacting an Access database perform other than reducing the file size?

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

Each record in a table is uniquely identified by a foreign key.

Which Ribbon group allows you to add fields to an Access table with defined data types?

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

Which data type allows field values to contain letters, digits, and other characters?

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

Access reports are based on a selected ____________________ or ____________________.

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

A database or a relational database is a collection of related tables.

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

The query results are stored in the database in which the query has been created. _________________________

This icon represents which Access 2013 object?

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

Access reports are based on a selected or .