Question 1

Creating a desktop database using a theme saves creation time.

Accepted Answer

A) True 
 B)False

Question 2

What is a relationship?

Accepted Answer

A)  Two Excel spreadsheets with similar data 
B)  A database and a spreadsheet with similar data 
C)  Similar queries applied to the same table 
D)  A connection between two tables with a common field 
A)  Two Excel spreadsheets with similar data 
B)  A database and a spreadsheet with similar data 
C)  Similar queries applied to the same table 
D)  A connection between two tables with a common field

Question 3

Two users cannot work on the same table in a database.

Accepted Answer

A) True 
 B)False

Question 4

When you apply a multiple sort in Access, columns are sorted:

Accepted Answer

A)  from right to left. 
B)  from left to right. 
C)  from top to bottom. 
D)  by primary field and then by secondary field. 
A)  from right to left. 
B)  from left to right. 
C)  from top to bottom. 
D)  by primary field and then by secondary field.

Question 5

Match between columns
                        Premises: double-click
triple-click
press and hold Ctrl while you click to select
press and hold Shift while you press the right arrow key
press and hold Ctrl while you press the letter A

Accepted Answer

The Answer of a sentence and a paragraph and one is...

Question 6

Which view in Excel is most similar to an Excel spreadsheet? What can you do in this view?

Accepted Answer

The Datasheet view is a grid c

Question 7

Match between columns
                        Premises: you write "there" instead of "their"
you write "recieve" instead of "receive"
you leave out a necessary comma
you want it to not stop on your name in the future
you want to bypass all occurrences of "daycare"

Accepted Answer

The Answer of Ignore All and red wavy underline and is...

Question 8

A comparison operator in Access is used to evaluate the relationship between two primary keys.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT an Access comparison operator?

Accepted Answer

A)  = 
D)  = 
A)  = 
D)  =

Question 10

The Filter by Selection returns:

Accepted Answer

A)  only records matching the set criteria. 
B)  results filtered from a selected range. 
C)  specific query results. 
D)  any data with a comparison operator. 
A)  only records matching the set criteria. 
B)  results filtered from a selected range. 
C)  specific query results. 
D)  any data with a comparison operator.

Question 11

Explain a query in Access. Provide an example.

Accepted Answer

A query is a question that you

Question 12

What does a custom Web app enable you to do?

Accepted Answer

A)  Create databases through Access' Web app. 
B)  Create relational tables that can be distributed through the Web. 
C)  Create a database and share with others through the Web. 
D)  Share and distribute database files without the need for Access to be installed on every computer. 
A)  Create databases through Access' Web app. 
B)  Create relational tables that can be distributed through the Web. 
C)  Create a database and share with others through the Web. 
D)  Share and distribute database files without the need for Access to be installed on every computer.

Question 13

Filter by Form uses the AND and OR logical operators.

Accepted Answer

A) True 
 B)False

Question 14

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

Accepted Answer

A) True 
 B)False

Question 15

Objects that are part of an Access database are available from the ________ within Access.

Accepted Answer

The answer of Objects that are part of an Access...

Question 16

The ________ utility of Access helps reduce the size of a database.

Accepted Answer

The answer of The ________ utility of Access helps reduce...

Question 17

Match between columns
                        Premises: Start screen
operating system
Windows 8
SkyDrive
cloud storage

Accepted Answer

The Answer of displays after starting your Windows 8 computer is...

Question 18

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 19

Relationships in a database can be graphically represented by the ________ between the tables.

Accepted Answer

The answer of Relationships in a database can be graphically...

Question 20

Access is known as a(n) ________ system because it allows users to administer groups of data in tables and create relationships.

Accepted Answer

relational

Creating a desktop database using a theme saves creation time.

What is a relationship?

Two users cannot work on the same table in a database.

When you apply a multiple sort in Access, columns are sorted:

Which view in Excel is most similar to an Excel spreadsheet? What can you do in this view?

A comparison operator in Access is used to evaluate the relationship between two primary keys.

Which of the following is NOT an Access comparison operator?

The Filter by Selection returns:

Explain a query in Access. Provide an example.

What does a custom Web app enable you to do?

Filter by Form uses the AND and OR logical operators.

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

Objects that are part of an Access database are available from the ________ within Access.

The ________ utility of Access helps reduce the size of a database.

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

Relationships in a database can be graphically represented by the ________ between the tables.

Access is known as a(n) ________ system because it allows users to administer groups of data in tables and create relationships.

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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

Creating a desktop database using a theme saves creation time.

What is a relationship?

Two users cannot work on the same table in a database.

When you apply a multiple sort in Access, columns are sorted:

Which view in Excel is most similar to an Excel spreadsheet? What can you do in this view?

A comparison operator in Access is used to evaluate the relationship between two primary keys.

Which of the following is NOT an Access comparison operator?

The Filter by Selection returns:

Explain a query in Access. Provide an example.

What does a custom Web app enable you to do?

Filter by Form uses the AND and OR logical operators.

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

Objects that are part of an Access database are available from the ________ within Access.

The ________ utility of Access helps reduce the size of a database.

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

Relationships in a database can be graphically represented by the ________ between the tables.

Access is known as a(n) ________ system because it allows users to administer groups of data in tables and create relationships.

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters