Question 1

What are the three methods for creating a new database?

Accepted Answer

You can create a cus

Question 2

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 3

What is an advantage of using Filter by Form?

Accepted Answer

A)  There is no minimum number of records that can be filtered. 
B)  You can use the AND and OR operators. 
C)  The records are also sorted. 
D)  Access automatically saves the results to storage. 
A)  There is no minimum number of records that can be filtered. 
B)  You can use the AND and OR operators. 
C)  The records are also sorted. 
D)  Access automatically saves the results to storage.

Question 4

You can use the Compact and Repair utility to help improve the performance of a database.

Accepted Answer

A) True 
 B)False

Question 5

A(n) ________ is a collection of organized and meaningful data that can be accessed, managed, stored, queried, sorted, and reported.

Accepted Answer

The answer of A(n) ________ is a collection of organized...

Question 6

Match the following keystrokes to their functions:
I. Ctrl+End
II. Ctrl+Z
II. Shift+Tab
IV. Ctrl+plus sign (+)
V. Ctrl+minus sign (-)
A. moves insertion point to the last field in the last row
B. moves insertion point left one field in the same row
C. reverses the last edit
D. moves to a new record row
E. deletes the current record

Accepted Answer

The answer of Match the following keystrokes to their functions:
I....

Question 7

Match the following terms to their meanings:
I. database
II. table
II. record
IV. field
V. object
A. complete set of fields about one person, place, event, or concept
B. smallest data element of a table
C. collection of organized data
D. the main component used to make a database function
E. an object in which data is stored

Accepted Answer

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

Question 8

A ________ key is the field in the related table that you would use to connect to the primary key in another table.

Accepted Answer

A)  secondary 
B)  foreign 
C)  composite 
D)  merged 
A)  secondary 
B)  foreign 
C)  composite 
D)  merged

Question 9

Use ________ if you have mostly numeric data and may require complex charts and graphs.

Accepted Answer

The answer of Use ________ if you have mostly numeric...

Question 10

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 11

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 12

Match the following terms to their meanings:
I. DBMS
II. Access
II. VBA
IV. RDBMS
V. Web app
A. application platform by Microsoft
B. programming language
C. software that provides tools needed to create, maintain, and use a database
D. can easily combine data from multiple tables to create queries, forms, and reports
E. database management system that is part of Office 2013

Accepted Answer

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

Question 13

Match the following terms to their meanings:
I. query
II. report
III. form
IV. module
V. macro
A. professional-looking formatted information from tables or queries
B. object that allows you to enter data and modify data in a database
C. question you ask about data stored in a database
D. stored series of commands that carry out an action
E. object that adds functionality to a database; written using VBA

Accepted Answer

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

Question 14

A(n) ________ is a number, phrase, or expression used to select records from a table.

Accepted Answer

The answer of A(n) ________ is a number, phrase, or...

Question 15

A table can only be sorted on a single field.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Charms
Start button
Start screen
Windows 8 app
tiles

Accepted Answer

The Answer of designed to run in the Start screen is...

Question 17

How does the Getting Started page help learn about a database?

Accepted Answer

A)  The Getting Started page links you to introductory Access videos. 
B)  The Getting Started page details how to install software. 
C)  The Getting Stated page explains what to do if your system crashes. 
D)  The Getting Stated page shows how to create relationships between tables. 
A)  The Getting Started page links you to introductory Access videos. 
B)  The Getting Started page details how to install software. 
C)  The Getting Stated page explains what to do if your system crashes. 
D)  The Getting Stated page shows how to create relationships between tables.

Question 18

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 19

A primary key:

Accepted Answer

A)  must include letters. 
B)  must contain a unique value for each record within a table. 
C)  has the same value for all records in a relational database. 
D)  is a unique record within a relational database. 
A)  must include letters. 
B)  must contain a unique value for each record within a table. 
C)  has the same value for all records in a relational database. 
D)  is a unique record within a relational database.

Question 20

________ 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

What are the three methods for creating a new database?

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

What is an advantage of using Filter by Form?

You can use the Compact and Repair utility to help improve the performance of a database.

A(n) ________ is a collection of organized and meaningful data that can be accessed, managed, stored, queried, sorted, and reported.

A ________ key is the field in the related table that you would use to connect to the primary key in another table.

Use ________ if you have mostly numeric data and may require complex charts and graphs.

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

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

A(n) ________ is a number, phrase, or expression used to select records from a table.

A table can only be sorted on a single field.

How does the Getting Started page help learn about a database?

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

A primary key:

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

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

What are the three methods for creating a new database?

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

What is an advantage of using Filter by Form?

You can use the Compact and Repair utility to help improve the performance of a database.

A(n) ________ is a collection of organized and meaningful data that can be accessed, managed, stored, queried, sorted, and reported.

A ________ key is the field in the related table that you would use to connect to the primary key in another table.

Use ________ if you have mostly numeric data and may require complex charts and graphs.

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

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

A(n) ________ is a number, phrase, or expression used to select records from a table.

A table can only be sorted on a single field.

How does the Getting Started page help learn about a database?

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

A primary key:

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

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