Question 1

What are the three methods for creating a new database?

Accepted Answer

You can create a custom Web app,a blank desktop database,or a database from a template.

Question 2

In relational databases,there is a concept known as ________ that ensures that data cannot be entered into a related table unless it first exists in a primary table.

Accepted Answer

referential integrity

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

Which of the following is NOT a main object type in an Access database?

Accepted Answer

A) Template 
B) Query 
C) Table 
D) Module 
A) Template 
B) Query 
C) Table 
D) Module

Question 5

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 6

What is an Access Web app?

Accepted Answer

An Access Web app is a new type of datab

Question 7

You can create a Web app from a Web app template from the Backstage view.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

relational

Question 10

Which of the following is FALSE about the Undo feature in Access?

Accepted Answer

A) You can click Undo to reverse the most recent change to a single record. 
B) You can use Undo to reverse multiple edits in Access. 
C) In Access,the Undo feature works the same as it does in other Office programs. 
D) You can click Undo to redo a change that you made previously. 
A) You can click Undo to reverse the most recent change to a single record. 
B) You can use Undo to reverse multiple edits in Access. 
C) In Access,the Undo feature works the same as it does in other Office programs. 
D) You can click Undo to redo a change that you made previously.

Question 11

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 12

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

Accepted Answer

A) Database 
B) Query 
C) Table 
D) Report 
A) Database 
B) Query 
C) Table 
D) Report

Question 13

When you ________,you ensure that data entered into a related table first exists in the primary table.

Accepted Answer

A) create a foreign key 
B) create a primary key 
C) filter by selection 
D) enforce referential integrity 
A) create a foreign key 
B) create a primary key 
C) filter by selection 
D) enforce referential integrity

Question 14

________ a database rearranges data and objects in a database to make its size smaller.

Accepted Answer

A) Backing up 
B) Compressing 
C) Compacting 
D) Fragmenting 
A) Backing up 
B) Compressing 
C) Compacting 
D) Fragmenting

Question 15

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 16

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

Accepted Answer

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

Question 17

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 18

SharePoint is an add-on program for Access.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Access can sort records by more than one field.

Accepted Answer

A) True 
 B)False

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

What are the three methods for creating a new database?

In relational databases,there is a concept known as ________ that ensures that data cannot be entered into a related table unless it first exists in a primary table.

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

Which of the following is NOT a main object type in an Access database?

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

What is an Access Web app?

You can create a Web app from a Web app template from the Backstage view.

Access differs from other Microsoft software because it:

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

Which of the following is FALSE about the Undo feature in Access?

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.

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

When you ________,you ensure that data entered into a related table first exists in the primary table.

________ a database rearranges data and objects in a database to make its size smaller.

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

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

SharePoint is an add-on program for Access.

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

Access can sort records by more than one field.

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