Question 1

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 2

Match between columns
                        Premises: Home
F11
Esc
F2
Tab

Accepted Answer

The Answer of toggles the Navigation Pane on and off is...

Question 3

What is one limit to two users working on the same database file at the same time?

Accepted Answer

Student answers may vary.One limit is th

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

________ view is a grid containing fields and records.

Accepted Answer

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

Question 6

Which of the following is an object that adds functionality to a database and is written using VBA?

Accepted Answer

A) Macro 
B) Module 
C) Query 
D) Report 
A) Macro 
B) Module 
C) Query 
D) Report

Question 7

Custom Web app is available in the Backstage view of Access.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: module
macro
form
report
query

Accepted Answer

The Answer of object that allows you to enter data is...

Question 9

A primary key may use a(n)________ data type--a generated primary key that is automatically incremented each time a record is added.

Accepted Answer

The answer of A primary key may use a(n)________ data...

Question 10

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 11

Match between columns
                        Premises: RDBMS
DBMS
Web app
Access
VBA

Accepted Answer

The Answer of software that provides tools needed to create,maintain,and is...

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A filter and a sort always produce the same results in an Access database.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Alice is working in a database containing the names,service locations,and services offered by landscapers.She needs to find landscapers that offer services in the Phoenix area and that service rare plants.The best way for her to search for this data is to perform a:

Accepted Answer

A) Filter by Form. 
B) Filter by Selection. 
C) Sort Ascending. 
D) Sort Descending. 
A) Filter by Form. 
B) Filter by Selection. 
C) Sort Ascending. 
D) Sort Descending.

Question 18

When you make a change to the content of a record in an Access table,when are the changes saved?

Accepted Answer

A) When you click the Save or Save As button from the File tab or the button on the Quick Access Toolbar 
B) When you press F11 or click the Save button on the Quick Access Toolbar 
C) When you move the insertion point to a different record 
D) When you move the insertion point to a different table,form,query,or report in the database 
A) When you click the Save or Save As button from the File tab or the button on the Quick Access Toolbar 
B) When you press F11 or click the Save button on the Quick Access Toolbar 
C) When you move the insertion point to a different record 
D) When you move the insertion point to a different table,form,query,or report in the database

Question 19

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 20

A relationship is a connection between:

Accepted Answer

A) two tables using a field that is common to both. 
B) two or more database files with a common primary field. 
C) two records within the same database. 
D) two or more tables using a common record. 
A) two tables using a field that is common to both. 
B) two or more database files with a common primary field. 
C) two records within the same database. 
D) two or more tables using a common record.

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

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

What is one limit to two users working on the same database file at the same time?

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.

________ view is a grid containing fields and records.

Which of the following is an object that adds functionality to a database and is written using VBA?

Custom Web app is available in the Backstage view of Access.

A primary key may use a(n)________ data type--a generated primary key that is automatically incremented each time a record is added.

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

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

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

A filter and a sort always produce the same results in an Access database.

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

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

Alice is working in a database containing the names,service locations,and services offered by landscapers.She needs to find landscapers that offer services in the Phoenix area and that service rare plants.The best way for her to search for this data is to perform a:

When you make a change to the content of a record in an Access table,when are the changes saved?

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

A relationship is a connection between:

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