Access 2016 Comprehensive

A grid that enables you to add, edit, and delete the records of a table

Datasheet View

What is the difference between a Selection filter and a Filter By Form?

A Selection filter displays only the records that match a criterion you select Filter By Form is a more versatile method of selecting data because it enables you to display records based on multiple criteria

What is a comparison operator and how is it used in a filter?

A comparison operator such as equal (=), not equal ( <>), greater than(> ), less than (<),greater than or equal to {>=). and less than or equal to ( <=) A record is included if the criterion is met.

What is a custom web app, and what is required to build a custom web app?

A database that you can build and then use and share with others through the Web Access to a host server

What is the purpose of creating a filter?

A filter allows you to specify conditions to display only those records that meet those conditions

What are the benefits of sorting records in a table?

Access can sort records by more than one field

Which of the following would be matched if you use a Selection ftlter's exact match option for the name Ann?

Ann, ANN, and ann

If you want to add a component to an existing database (such as a Contacts table), what would you use?

Application Part

A set of common Access components that can be added to an existing database

Application part

To add a predefined table to an existing database, you should use which of the following?

Application part

Which of the following utilities is used to recover in the event of loss or damage?

Back Up Database

Which of the following is true regarding table views?

Changes made in Datasheet view are automatically saved when you move the insertion point to a different record.

A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported

Database

A software system that provides the tools needed to create, maintain, and use a database

Database Management System (DBMS)

What is the difference between Datasheet view and Design view in a table?

Datasheet view is a grid containing fields (columns) and records (rows). You can view, add, edit, and delete records in Datasheet view Design view gives you a detailed view of the table's structure and is used to create and modify a table's design by specifying the fields it will contain

View that enables you to create and modify a table design

Design View

Which of the following conditions is available through a Selection filter?

Equal condition

Which of the following is not true of an Access database?

Every table in a database contains the same number of records as every other table.

A piece of information stored in a table, such as a company name or city

Field

Enables you to specify conditions to display only those records that meet certain conditions

Filter

A filtering method that displays records based on multiple criteria

Filter By Form

An Access object that simplifies entering, modifying, and deleting table data

Form

Which of the following is an example of an Access object?

Form

An Access interface element that organizes and Lists database objects in a database

Navigation Pane

A main component that is created and used to make a database function, such as a table or form

Object

The field (or combination of fields) that uniquely identifies each record in a table

Primary Key

A question you ask about the data in your database

Query

Complete set of all the fields about one person, place, event, or concept

Record

You edit several records in an Access table. When should you execute the Save conmand?

Records are saved automatically; the save command is not required

A connection between two tables using a common field

Relationship

An object that contains professional-looking formatted information from underlying tables or queries

Report

A filtering method that displays only records that match selected criteria

Selection Filter

A method of listing records in a specific sequence (such as alphabetically)

Sort

An object used to store data, organizing data into columns and rows

Table

Where is data in a database stored?

Table

Name the four main types of objects in an Access database and briefly describe the purpose of each.

Table - where all data is stored in your database Query (or queries, plural) - a question you ask about the data in your database Form - allows simplified entry and modification of data Report - contains professional-looking formatted information from underlying tables or queries

A predefined database that includes professionally designed tables, forms, reports and other objects

Template

How do relationships benefit a database user?

The benefit of a relationship is the ability to efficiently combine data from related tables for the purpose of creating queries, forms, and reports

All of the following statements are true about creating a database except:

The objects provided in a template cannot be modified

What are two benefits of using a template to create a database?

Using a template to start a database saves you a great deal of creation time

How does Access handle saving differently than other Office programs such as Excel?

Word, Excel, and PowerPoint all work primarily from memory (RAM). In those applications, your work is not automatically saved to your storage location. Access, on the other hand, works primarily from storage (i.e., the hard drive). As you enter and update the data in an Access database, the changes are automatically saved to the storage location you specified when you saved the database