Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Describe how Access sorts multiple criteria in a database.

Accepted Answer

Access sorts multiple criteria

Question 3

Good database design begins with grouping data into correct tables, a practice known as ________.

Accepted Answer

The answer of Good database design begins with grouping data...

Question 4

Why would you enforce referential integrity?

Accepted Answer

A)  To avoid accidental deletion of macros 
B)  So data cannot be entered into a related table until the data is entered in the primary table 
C)  To confirm error free data 
D)  To determine which software to use Excel or Access 
A)  To avoid accidental deletion of macros 
B)  So data cannot be entered into a related table until the data is entered in the primary table 
C)  To confirm error free data 
D)  To determine which software to use Excel or Access

Question 5

Match the following tabs to their features:
I. File tab
II. Home tab
III. Create tab
IV. External Data tab
V. Database Tools tab
A. provides access to the Compact and Repair Database button
B. access to Backstage view
C. contains basic editing functions and formatting tools
D. contains tools used to make new objects
E. facilitates data import and export

Accepted Answer

The answer of Match the following tabs to their features:
I....

Question 6

Why is there a need to filter records?

Accepted Answer

A)  Filters scan for viruses. 
B)  Filters hide records that do match the criteria. 
C)  Filters speed up the CPU. 
D)  Filters reduce the file size. 
A)  Filters scan for viruses. 
B)  Filters hide records that do match the criteria. 
C)  Filters speed up the CPU. 
D)  Filters reduce the file size.

Question 7

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 8

Match the following terms to their meanings:
I. Access Web app
II. SharePoint
II. Office 365
IV. Access
V. XPS file
A. new in Access 2013
B. Web app platform developed by Microsoft
C. cloud service edition of SharePoint
D. preserves an object's formatting
E. part of Office 2013

Accepted Answer

The answer of Match the following terms to their meanings:
I....

Question 9

You can use Access to create a Web app for sharing data with others through the Internet.

Accepted Answer

A) True 
 B)False

Question 10

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

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

Describe how Access sorts multiple criteria in a database.

Good database design begins with grouping data into correct tables, a practice known as ________.

Why would you enforce referential integrity?

Why is there a need to filter records?

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

Match the following terms to their meanings: I. Access Web app II. SharePoint II. Office 365 IV. Access V. XPS file A. new in Access 2013 B. Web app platform developed by Microsoft C. cloud service edition of SharePoint D. preserves an object's formatting E. part of Office 2013

You can use Access to create a Web app for sharing data with others through the Internet.

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.

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

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

Describe how Access sorts multiple criteria in a database.

Good database design begins with grouping data into correct tables, a practice known as ________.

Why would you enforce referential integrity?

Why is there a need to filter records?

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

Match the following terms to their meanings: I. Access Web app II. SharePoint II. Office 365 IV. Access V. XPS file A. new in Access 2013 B. Web app platform developed by Microsoft C. cloud service edition of SharePoint D. preserves an object's formatting E. part of Office 2013

You can use Access to create a Web app for sharing data with others through the Internet.

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.

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