Access

select

(n) ____________ query displays a subset of data from one table based on specified criteria. A. select B. variable C. operational D. join

join

A ____________ query displays a subset of data from two or more tables using a common field. A. select B. complex C. table D. join

record

A group of related fields in a database is called a(n): A. record. B. object. C. memo. D. table.

table

A group of related records in a database is called a(n): A. column. B. object. C. key. D. table.

relations

A relational database organizes data by logically grouping similar data into ____________, or tables that contain related data. A. keys B. relations C. fields D. records

Must be unique for every field

A tables primary key must

Stores one unique piece of data in only one table

A well-designed database...

object-oriented

A(n) ____________ database stores data in objects, not in tables. A. object-oriented B. relational C. multidimensional D. object-relational

query

A(n) ____________ enables users to have the database select and display records that match a certain criteria. A. query B. sort C. operation D. join

Calculated field

A_______ displays a value returned by an expression.

Select query

A_______ displays data from one or more tables or queries, based on the fields that you select.

bound

A________ text control displays data from a field.

Subform

A_________ is a form within a form that displays records related to the record in the main form.

Split Form

A__________ combines the convenience of a continuous Datasheet form with the usability of a single record form displaying one record at a time.

Table

All data entered into a form are stored in the underlying

Forces users to enter data in a consistent format.

An input mask..

Calculated

An unbound text box control that contains an expression (formula) is called a _______ control.

Tables

Are the basic building blocks of a database

field list

Click and drag fields from the ______ to add controls to a blank report

Field

Each column in a table represents a specific data value called a

Record

Each row in a table contains all the data for a single

Not equal to.

Entering<>80 as the criteria for a query will return results that are______________.

Report footer section

Grand totals in a report are added to the_________.

You cannot add a record to the secondary table without an associated record in the primary table, AND you cannot make changes to the primary table that would cause records in the secondary table to become unmatched.

If two tables have referential integrity enforced,

uppercase

If you enter .> in the field format property, all text will appear in which format?

Field validation rule

If you require a value in a field to always be less than 25, which of the following you use?

Record Validation Rule

If you require the value in one field in a table to always be greater than the value of another field in the table, which of the following would you use?

Unmatched Query Wizard

If you want to create a query that shows record from one table that have no corresponding records in another table use a________.

Duplicates

If you wanted to display records of all employees who live in the same city (from the city field in the table), you would use a __________.

field

In a database, a category of information is stored in a(n) ____________.

key

In a relational database, tables are logically linked to each other by a: A. key. B. hyperlink. C. field type. D. field size.

input form

In addition to keying data directly into the database, data entry can be done from a(n): A. input form. B. table. C. field. D. data dictionary.

relationships

The premise behind a relational database is that ____________ are established among the tables. A. relationships B. schema C. consistencies D. normalizations

layout

To change the direction a report prints on the page, change the page____________.

The field Size Property

To control the number of characters a user can enter into a table field.

attachment

To include a photo image with each record in a table, use a field with this data type...

false- compact and repair

True or False, Creating a backup of the database removes unnecessary file space and hidden

True

True or False, The input mask "ID"00999;0;_ will store the literal text "ID" in the database?

False-auto number is automatically assigned its value by access and they are often used as a primary key if no other unique field exists in the table

True or False, Users can enter and edit data in an Autonumber field

False- is ONLY temporary, if you want a more permanent filter apply it to criteria in design view.

True or false, Auto filter and Filter selection settings are saved with the database object.

True???

True or false, Page numbers can only be added to a footer section.

True

True or false, To Limit query results to only records that meet all the criteria, enter criteria for multiple fields on the criteria row, or enter multiple criteria for the same field separated by the word AND.

False- the UPPER pane shows the tables referenced in the query, the LOWER pane shows the query grid where you specify which fields to include in the query.

True or false, the upper pane in query Design view shows the query grid where you specify which fields to include in the query.

true

True/false Before working with a new blank database, you must save it as a new file.

Extracts data from a table or related tables. Also can update values or delete data. THE DATA IS NOT STORED PERMANENTLY.

What is a Query?

A primary key field from one table that you include as a filed in a second table to form a relationship between the two tables.

What is a foreign key?

A field, or a collection of fields, whose values uniquely and minimally identity each record in a database table and whose values do not change.

What is a primary key?

(*) (?) and "like" to find inexact text matches. The * wildcard replaces any string of characters. The ? replaced a single character. To include all record type Like "laskdbflksjbdf?"

What is a wildcard?

Quick start

What is the easiest way to add address fields and other common field groups to your table?

validation rules

When entering data, violations of ____________ usually result in error messages. A. data entry B. validation rules C. arithmetic operators D. computation

true

When importing data into access, you can identify a column or field from the imported data as the primary key

Undo the entire record at once

When you are entering data in a new record in a form, the undo command will

Parameter Query

When you create a ________, you specific the field or fields that the query will use, but you don't specify the exact criteria.

Page numbers

Which design elements is not available in forms?

contacts

Which of these Quickstart application parts would be most useful in a database that manages customers?

PDF

You can export Access data to which of the file formats?

Word

You cannot import data into access from which of these file types?

True

You must manually save the record each time you enter data in a table or form

Criteria

________ are conditions that the records must meet in order to be included in the query results.

Double-click the column header and type the new field name OR right-click the column header and select Rename field and type the new field name.

to rename a field...

False- right click

true or false, To rename a database object, double-click the name in the Navigation Pane and type the new name.

False

true or false, the currency field format is the same as currency data type

False- ex: .05 displays as 5, and 5 displays as 500.

true or false, the percent field format displays the % symbol in the data table.

false

true or false, you can undo a record deletion