Question 1

In relational databases, there is a concept known as ________ which means that related tables must be consistent with one another.

Accepted Answer

reverentia

Question 2

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 3

________ sorts a list of text data in reverse alphabetical order from Z to A, or a numeric list in highest to lowest.

Accepted Answer

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

Question 4

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 5

The smallest data element in an Access database is called a(n) ________.

Accepted Answer

The answer of The smallest data element in an Access...

Question 6

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 7

Data in one or more tables can be related to each other by means of a(n) ________ field.

Accepted Answer

The answer of Data in one or more tables can...

Question 8

You can ________ a database to rearrange the data and objects in the database and decrease its file size.

Accepted Answer

The answer of You can ________ a database to rearrange...

Question 9

The ________ organizes and lists the database objects in an Access database.

Accepted Answer

A)  report wizard 
B)  navigation pane 
C)  query tool 
D)  form wizard 
A)  report wizard 
B)  navigation pane 
C)  query tool 
D)  form wizard

Question 10

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

Accepted Answer

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

Question 11

A primary key in one table cannot be used as a foreign key in a different table.

Accepted Answer

A) True 
 B)False

Question 12

Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would:

Accepted Answer

A)  create a query. 
B)  create a new table. 
C)  create a form. 
D)  create a report. 
A)  create a query. 
B)  create a new table. 
C)  create a form. 
D)  create a report.

Question 13

Both Access and Excel contain tools that can be used to extract and analyze information.

Accepted Answer

A) True 
 B)False

Question 14

The ________ is a field or collection of fields whose values uniquely identify each record in a table.

Accepted Answer

The answer of The ________ is a field or collection...

Question 15

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

Accepted Answer

relational

Question 16

You can use ________ to create a relationship between two tables using a common field.

Accepted Answer

A)  join lines 
B)  objects 
C)  forms 
D)  reports 
A)  join lines 
B)  objects 
C)  forms 
D)  reports

Question 17

When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT:

Accepted Answer

A)  you need to create complex charts or graphs. 
B)  you require multiple tables to manage data. 
C)  you are managing a large quantity of data. 
D)  multiple users need to work with data simultaneously. 
A)  you need to create complex charts or graphs. 
B)  you require multiple tables to manage data. 
C)  you are managing a large quantity of data. 
D)  multiple users need to work with data simultaneously.

Question 18

The navigation bar at the bottom of the database window shows the number of records in a table.

Accepted Answer

A) True 
 B)False

Question 19

A form can be used to:

Accepted Answer

A)  select records that meet specific criteria. 
B)  automate the retrieval and update process. 
C)  sort data in ascending or descending order. 
D)  enter, edit, and view records in a database. 
A)  select records that meet specific criteria. 
B)  automate the retrieval and update process. 
C)  sort data in ascending or descending order. 
D)  enter, edit, and view records in a database.

Question 20

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

Accepted Answer

A)  form 
B)  descending 
C)  order 
D)  ascending 
A)  form 
B)  descending 
C)  order 
D)  ascending

In relational databases, there is a concept known as ________ which means that related tables must be consistent with one another.

Access differs from other Microsoft software because it:

________ sorts a list of text data in reverse alphabetical order from Z to A, or a numeric list in highest to lowest.

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.

The smallest data element in an Access database is called a(n) ________.

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

Data in one or more tables can be related to each other by means of a(n) ________ field.

You can ________ a database to rearrange the data and objects in the database and decrease its file size.

The ________ organizes and lists the database objects in an Access database.

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

A primary key in one table cannot be used as a foreign key in a different table.

Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would:

Both Access and Excel contain tools that can be used to extract and analyze information.

The ________ is a field or collection of fields whose values uniquely identify each record in a table.

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

You can use ________ to create a relationship between two tables using a common field.

When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT:

The navigation bar at the bottom of the database window shows the number of records in a table.

A form can be used to:

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

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

Exam 15: Access: Introduction to Powerpoint

In relational databases, there is a concept known as ________ which means that related tables must be consistent with one another.

Access differs from other Microsoft software because it:

________ sorts a list of text data in reverse alphabetical order from Z to A, or a numeric list in highest to lowest.

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.

The smallest data element in an Access database is called a(n) ________.

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

Data in one or more tables can be related to each other by means of a(n) ________ field.

You can ________ a database to rearrange the data and objects in the database and decrease its file size.

The ________ organizes and lists the database objects in an Access database.

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

A primary key in one table cannot be used as a foreign key in a different table.

Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would:

Both Access and Excel contain tools that can be used to extract and analyze information.

The ________ is a field or collection of fields whose values uniquely identify each record in a table.

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

You can use ________ to create a relationship between two tables using a common field.

When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT:

The navigation bar at the bottom of the database window shows the number of records in a table.

A form can be used to:

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

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters