Access Ch1 & Ch2

Which of the following would be matched if you use a Selection filter's exact match option for the name Ann? (a) Ann, ANN, and ann (b) Danny, Ann, and Anny (c) Ann (but not ANN) (d) Both a and b

(a) Ann, ANN, and ann

To add a predefined table to an existing database, you should use which of the following? (a) Application part (b) Blank desktop database (c) Custom web app (d) Database template

(a) Application part

Which of the following conditions is available through a Selection filter? (a) Equal condition (b) Delete condition (c) AND condition (d) OR condition

(a) Equal condition

Which of the following is not true of an Access database? (a) Each field has a data type that establishes the kind of data that can be entered. (b) Every record in a table has the same fields as every other record. (c) Every table in a database contains the same number of records as every other table. (d) A primary key uniquely identifies a record.

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

Which of the following is an example of an Access object? (a) Database (b) Field (c) Form (d) Record

(c) Form

You edit several records in an Access table. When should you execute the Save command? (a) Immediately after you edit a record (b) Once at the end of the session (c) Records are saved automatically; the save command is not required (d) When you close the table

(c) Records are saved automatically; the save command is not required

Which of the following is true regarding table views? (a) You can add, edit, and delete records using Design view. (b) Datasheet view shows a detailed view of the table design. (c) Datasheet view provides access to more field properties than Design view. (d) Changes made in Datasheet view are automatically saved when you move the insertion point to a different record.

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

Where is data in a database stored? (a) Form (b) Query (c) Report (d) Table

(d) Table

All of the following statements are true about creating a database except: (a) Creating a custom web app requires that you use a server (such as SharePoint). (b) When creating a blank desktop database, Access opens to a blank table in Datasheet view. (c) Using a template to create a database saves time because it includes predefined objects. (d) The objects provided in a template cannot be modified.

(d) The objects provided in a template cannot be modified.

Returns only records that meet all criteria.

AND condition

T/F: Data can be sorted as only ascending

False; ascending or descending

Returns records meeting any of the specified criteria.

OR Condition

T/F: A selection filter can find exact matches or partial matches

True

T/F: Creating a custom web app enables you to create a database that you can build and use and share with others through the Web.

True

T/F: Filter by form is based on multiple criteria and allows for logical operators and comparison operators

True

T/F: If you require a certain type of table (such as Contacts) you can add them using an application part.

True

T/F: The Back Up Database utility creates a duplicate copy of the database. This may enable users to recover from failure.

True

T/F: The Compact and Repair utility reduces the size of a database and fixes any errors that may exist in the file.

True

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

application part

A number that automatically increments each time a record is added.

autonumber

Used to create a more understandable label than a field name label that displays in the top row in Datasheet view and in forms and reports.

caption property

When the primary key value is deleted in a primary table, Access will automatically delete all foreign key values in a related table.

cascade delete related records

An option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table.

cascade update related fields

Uses greater than (>), less than (<), greater than or equal to (>=), and less than or equal to (<=), etc. to limit query results that meet these criteria.

comparison operators

A row in the Query Design view that determines which records will be selected.

criteria row

The unnecessary storing of duplicate data in two or more tables.

data redundancy

Determines the type of data that can be entered and the operations that can be performed on that data.

data type

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

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

datasheet view

View that enables you to create and modify a table design.

design view

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

field

Characteristic of a field that determines how it looks and behaves.

field properties

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

A field in one table that is also the primary key of another table.

foreign key

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

form

Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database.

multitable queries

An Access interface element that organizes and lists database objects in a database.

navigation pane

The term Access uses to describe a blank field.

null

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

object

When the primary key value in the primary table can match many of the foreign key values in the related table.

one to many relationship

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

Enables you to ask questions about the data stored in a database and provides answers to the questions in a datasheet.

query

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

record

To delete a record, click the record selector and click Delete in the ________ group on the Home tab.

records

Rules in a database that are used to preserve relationships between tables when records are changed.

referential integrity

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

Provides a step-by-step guide to help you through the query design process.

simple query wizard

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

sort

Access works primarily from _______. Records can be added, modified, or deleted in the database, and as the information is entered, it is automatically saved. Undo cannot reverse edits made to multiple records.

storage

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

table

The foundation of a database is its _______, the objects in which data is stored.

tables

An Access database is a structured collection of four major types of objects—

tables, forms, queries, and reports.

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

template

Special character that can represent one or more characters in the criterion of a query.

wildcard