Question 1

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 2

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

Accepted Answer

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

Question 3

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 4

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 5

An Access database can MOST accurately be described as a structured collection of:

Accepted Answer

A) tables. 
B) objects. 
C) records. 
D) modules. 
A) tables. 
B) objects. 
C) records. 
D) modules.

Question 6

Access is preferred over Excel in managing mostly numeric data.

Accepted Answer

A) True 
 B)False

Question 7

The ________ Database utility in Access creates a duplicate copy of a database.

Accepted Answer

The answer of The ________ Database utility in Access creates...

Question 8

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

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 11

Explain a query in Access.Provide an example.

Accepted Answer

A query is a question that you

Question 12

The Undo button does not reverse the most recent change in Access 2013.

Accepted Answer

A) True 
 B)False

Question 13

Access can create relationships between two tables;Excel cannot.

Accepted Answer

A) True 
 B)False

Question 14

A ________ is a question you ask about data stored in a database.

Accepted Answer

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

Question 15

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 16

When forming relationships in a relational database,the ________ from one table must be joined to the foreign key of another table.

Accepted Answer

The answer of When forming relationships in a relational database,the...

Question 17

Access' ________ feature creates a duplicate copy of a database.

Accepted Answer

A) Back Up Database 
B) RDBMA 
C) Compact and Repair 
D) Relationship 
A) Back Up Database 
B) RDBMA 
C) Compact and Repair 
D) Relationship

Question 18

Which of the following is TRUE about Access' Compact and Repair feature?

Accepted Answer

A) It fragments a fragmented relational database file. 
B) It defragments a fragmented database file if needed. 
C) It removes objects and stores them in a secondary file. 
D) You should compact your database no more than once a week due to the time required. 
A) It fragments a fragmented relational database file. 
B) It defragments a fragmented database file if needed. 
C) It removes objects and stores them in a secondary file. 
D) You should compact your database no more than once a week due to the time required.

Question 19

What is a foreign key? Provide an example.

Accepted Answer

A foreign key is a field in one table th

Question 20

Information is what is typically entered into a database.Data is the finished product of the database.

Accepted Answer

A) True 
 B)False

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

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

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

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

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.

An Access database can MOST accurately be described as a structured collection of:

Access is preferred over Excel in managing mostly numeric data.

The ________ Database utility in Access creates a duplicate copy of a database.

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

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

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

Explain a query in Access.Provide an example.

The Undo button does not reverse the most recent change in Access 2013.

Access can create relationships between two tables;Excel cannot.

A ________ is a question you ask about data stored in a database.

What does a custom Web app enable you to do?

When forming relationships in a relational database,the ________ from one table must be joined to the foreign key of another table.

Access' ________ feature creates a duplicate copy of a database.

Which of the following is TRUE about Access' Compact and Repair feature?

What is a foreign key? Provide an example.

Information is what is typically entered into a database.Data is the finished product of the database.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

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

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

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

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters