Question 1

Use ________ if you have a large amount of data and may need to group,sort,and total the data based on various parameters.

Accepted Answer

The answer of Use ________ if you have a large...

Question 2

Access can sort records by more than one field.

Accepted Answer

A) True 
 B)False

Question 3

What are the three methods for creating a new database?

Accepted Answer

You can create a cus

Question 4

The navigation buttons in Access allow you to step through a table record by record,or to quickly go to the first or last record in the table.

Accepted Answer

A) True 
 B)False

Question 5

Irene is working in a database that organizes city court case information.Irene must find court cases in either Jackson county or Jefferson county.Irene should use the Filter by Form ________ condition.

Accepted Answer

A)  query 
B)  sort 
C)  OR 
D)  AND 
A)  query 
B)  sort 
C)  OR 
D)  AND

Question 6

Like Access,Excel can be used to manage large quantities of data.

Accepted Answer

A) True 
 B)False

Question 7

The ________ displays the number of the current record as well as the total number of records in a table.

Accepted Answer

The answer of The ________ displays the number of the...

Question 8

Match between columns
                        Premises: Create tab
Database Tools tab
External Data tab
File tab
Home tab

Accepted Answer

The Answer of facilitates data import and export and access is...

Question 9

Enforce referential integrity is one of only two options available when setting a database relationship with another database.

Accepted Answer

A) True 
 B)False

Question 10

You may choose Access over Excel in all of the following situations EXCEPT when you:

Accepted Answer

A)  require multiple related tables to store your data. 
B)  need to group data based on various parameters. 
C)  need to create complex charts. 
D)  have a large amount of data. 
A)  require multiple related tables to store your data. 
B)  need to group data based on various parameters. 
C)  need to create complex charts. 
D)  have a large amount of data.

Question 11

The F2 key puts you in Edit mode when in Access.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is FALSE about the navigation bar in Access 2013?

Accepted Answer

A)  It is located at the bottom of the Access window. 
B)  It contains buttons to go to a first, previous, next, or last record of a database. 
C)  It enables you to find a record based on a single search word. 
D)  It is toggled on and off with the F11 key. 
A)  It is located at the bottom of the Access window. 
B)  It contains buttons to go to a first, previous, next, or last record of a database. 
C)  It enables you to find a record based on a single search word. 
D)  It is toggled on and off with the F11 key.

Question 13

When you are ready to sort a database,click in the field that you want to sort and click the ________ tab.

Accepted Answer

The answer of When you are ready to sort a...

Question 14

The ________ view in Access looks similar to an Excel spreadsheet.

Accepted Answer

A)  Report 
B)  Form 
C)  Datasheet 
D)  Design 
A)  Report 
B)  Form 
C)  Datasheet 
D)  Design

Question 15

A primary key from one table that is used to form a relationship with a second table is called a(n)________.

Accepted Answer

The answer of A primary key from one table that...

Question 16

When you make a change to the content of a record in an Access table,when are the changes saved?

Accepted Answer

A)  When you click the Save or Save As button from the File tab or the button on the Quick Access Toolbar 
B)  When you press F11 or click the Save button on the Quick Access Toolbar 
C)  When you move the insertion point to a different record 
D)  When you move the insertion point to a different table, form, query, or report in the database 
A)  When you click the Save or Save As button from the File tab or the button on the Quick Access Toolbar 
B)  When you press F11 or click the Save button on the Quick Access Toolbar 
C)  When you move the insertion point to a different record 
D)  When you move the insertion point to a different table, form, query, or report in the database

Question 17

Describe comparison operators in Access.

Accepted Answer

A comparison operator is used to evaluat

Question 18

Of the following,which is NOT a main object type in an Access database?

Accepted Answer

A)  Report 
B)  Form 
C)  Macro 
D)  Record 
A)  Report 
B)  Form 
C)  Macro 
D)  Record

Question 19

A filter and a sort always produce the same results in an Access database.

Accepted Answer

A) True 
 B)False

Question 20

What is an Access Web app?

Accepted Answer

An Access Web app is a new type of datab

Exam 11: Introduction to Access: Finding Your Way Through an Access Database

Use ________ if you have a large amount of data and may need to group,sort,and total the data based on various parameters.

Access can sort records by more than one field.

What are the three methods for creating a new database?

The navigation buttons in Access allow you to step through a table record by record,or to quickly go to the first or last record in the table.

Irene is working in a database that organizes city court case information.Irene must find court cases in either Jackson county or Jefferson county.Irene should use the Filter by Form ________ condition.

Like Access,Excel can be used to manage large quantities of data.

The ________ displays the number of the current record as well as the total number of records in a table.

Enforce referential integrity is one of only two options available when setting a database relationship with another database.

You may choose Access over Excel in all of the following situations EXCEPT when you:

The F2 key puts you in Edit mode when in Access.

Which of the following is FALSE about the navigation bar in Access 2013?

When you are ready to sort a database,click in the field that you want to sort and click the ________ tab.

The ________ view in Access looks similar to an Excel spreadsheet.

A primary key from one table that is used to form a relationship with a second table is called a(n)________.

When you make a change to the content of a record in an Access table,when are the changes saved?

Describe comparison operators in Access.

Of the following,which is NOT a main object type in an Access database?

A filter and a sort always produce the same results in an Access database.

What is an Access Web app?

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters