Question 1

You can click the ________ button on the table toolbar to sort records in alphabetical order,from A to Z.

Accepted Answer

A)  Sort 
B)  Descending 
C)  Order 
D)  Ascending 
A)  Sort 
B)  Descending 
C)  Order 
D)  Ascending

Question 2

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 3

Match between columns
                        Premises: Shift+Tab
Ctrl+Z
Ctrl+plus sign (+)
Ctrl+minus sign (-)
Ctrl+End

Accepted Answer

The Answer of moves insertion point left one field in is...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: ascending
primary key
AutoNumber
descending
field properties

Accepted Answer

The Answer of generated by Access and is automatically incremented is...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Access differs from other Microsoft software because it:

Accepted Answer

A)  works primarily from memory. 
B)  works primarily from storage. 
C)  does not save your work as soon as changes are made. 
D)  does not allow more than one user to work on a file at a time. 
A)  works primarily from memory. 
B)  works primarily from storage. 
C)  does not save your work as soon as changes are made. 
D)  does not allow more than one user to work on a file at a time.

Question 8

Backing up a database rearranges the data and objects in a database to decrease its file size,thereby making more space available on your disk and letting you open and close the database more quickly.

Accepted Answer

A) True 
 B)False

Question 9

A(n)________ is the smallest data element of a table.

Accepted Answer

The answer of A(n)________ is the smallest data element of...

Question 10

Click the File tab to begin the process of compacting and repairing a database.

Accepted Answer

A) True 
 B)False

Question 11

Rather than displaying records based on a question as in a query,a(n)________ hides records that do not match a set criteria.

Accepted Answer

The answer of Rather than displaying records based on a...

Question 12

Access can create relationships between two tables; Excel cannot.

Accepted Answer

A) True 
 B)False

Question 13

________ sorts a list of numeric data from highest to lowest.

Accepted Answer

The answer of ________ sorts a list of numeric data...

Question 14

A relational database has the ability to create relationships between two:

Accepted Answer

A)  forms. 
B)  fields. 
C)  files. 
D)  tables. 
A)  forms. 
B)  fields. 
C)  files. 
D)  tables.

Question 15

Access allows you to save a database as a PDF or ________ file,which preserves the object's formatting and looks the same on most computers.

Accepted Answer

The answer of Access allows you to save a database...

Question 16

Filter by Selection displays only records that match a criterion that you select.

Accepted Answer

A) True 
 B)False

Question 17

________ view is a grid containing fields and records.

Accepted Answer

The answer of ________ view is a grid containing fields...

Question 18

A number,phrase,or expression used to select records in a table is called:

Accepted Answer

A)  a primary key. 
B)  a criterion. 
C)  a query. 
D)  referential integrity. 
A)  a primary key. 
B)  a criterion. 
C)  a query. 
D)  referential integrity.

Question 19

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 20

Tables,queries,reports,and forms are all examples of ________.

Accepted Answer

The answer of Tables,queries,reports,and forms are all examples of ________....

You can click the ________ button on the table toolbar to sort records in alphabetical order,from A to Z.

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

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

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

Access differs from other Microsoft software because it:

Backing up a database rearranges the data and objects in a database to decrease its file size,thereby making more space available on your disk and letting you open and close the database more quickly.

A(n)________ is the smallest data element of a table.

Click the File tab to begin the process of compacting and repairing a database.

Rather than displaying records based on a question as in a query,a(n)________ hides records that do not match a set criteria.

Access can create relationships between two tables; Excel cannot.

________ sorts a list of numeric data from highest to lowest.

A relational database has the ability to create relationships between two:

Access allows you to save a database as a PDF or ________ file,which preserves the object's formatting and looks the same on most computers.

Filter by Selection displays only records that match a criterion that you select.

________ view is a grid containing fields and records.

A number,phrase,or expression used to select records in a table is called:

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

Tables,queries,reports,and forms are all examples of ________.

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

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

You can click the ________ button on the table toolbar to sort records in alphabetical order,from A to Z.

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

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

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

Access differs from other Microsoft software because it:

Backing up a database rearranges the data and objects in a database to decrease its file size,thereby making more space available on your disk and letting you open and close the database more quickly.

A(n)________ is the smallest data element of a table.

Click the File tab to begin the process of compacting and repairing a database.

Rather than displaying records based on a question as in a query,a(n)________ hides records that do not match a set criteria.

Access can create relationships between two tables; Excel cannot.

________ sorts a list of numeric data from highest to lowest.

A relational database has the ability to create relationships between two:

Access allows you to save a database as a PDF or ________ file,which preserves the object's formatting and looks the same on most computers.

Filter by Selection displays only records that match a criterion that you select.

________ view is a grid containing fields and records.

A number,phrase,or expression used to select records in a table is called:

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

Tables,queries,reports,and forms are all examples of ________.

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