Access

select query

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

desktop database

A database that does not require a SharePoint server.

parameter query

A query with user-controlled criteria input.

Print Preview

A specific report view that shows how the database report will appear when printed

Stores each unique piece of data in only one table

A well designed database_____

Bound

A(n) ______ text control displays data from a field

CSV

Abbreviation of "comma-separated values," this is a widely-used format for storing data. File format that uses a comma as the delimiter. These files have a .csv file extension

True

Access will not round the values stored in currency fields

False

Autofilter and filter by selection settings are saved with the database

Short text data type

Can hold up to 255 characters. Should be treated as text

grouping

Feature that organizes records into distinct sections within an access report

Datasheet

Table data and query results displayed in datasheet view

Label control

Unbound control that displays the field name or other text

attachment

Which data type should be used to include an image file with each record in a table?

Default Value Property

adds a preset value to the field.

Currency format

displays a $ symbol before the number and two digits to the right of the decimal place.

innermost sort

in a multilevel sort the last field the data are sorted on.

calculated field

A ____ displays a value returned by an expression

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.

subform

A _______ is a form within a form that displays records related to the record in the main form

Calculated

An unbound text box control that contains an expression (formula) is called a(n) _____ control

calculated control

An unbound text control that contains an expression (formula).

bound control

Control that displays data from a specific field.

field

Each column in a table

Input Mask

Ensures that users enter data in a database field in a particular format

Find unmatched query

If you want to create a query that shows records from one table that have no corresponding records another table, use a ____

True

Moving a field in design view also changed the field order in datasheet view

stacked layout

Places the form or report labels at the left side with data to the right

macro

Programming instruction that can be run from within a file. Used to automate data entry and formatting processes and to execute commands from buttons in a database

Message bar

Security warning that displays at the top of the window, below the Ribbon.

criterion

Singular form of the word criteria

Tables

Store all the database data

record source

The associated table or query for a database form or report.

False

The currency field format is the same as the currency data type

Primary Key

The field that contains a unique field value for each record in the table

import

To bring data into the database from another file format.

Orientation

To change the direction a report prints on the page, change the page _______

Field Size Property

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

False

To rename a database object, double click the name in the navigation pane and type the new name

export

To save data in a file format accessible to other applications

Tables

What are the building blocks of a database?

parameter query

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

Report Wizard

Wizard that walks you step by step through the process of creating a report.

Database

a collection of organized data that allows access, retrieval, and use of data

unbound control

a control that is not linked to a field.

calculated field

displays a value returned by an expression (a formula) Calculated each time the query is run

select query

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

record

each row in a table

query

extracts data from one or more database tables according to criteria that you set

find duplicates query

finds duplicate records in a table or a query

Form view

provides a user-friendly interface for entering data. You cannot change the form layout or formatting

Long Text data type

A data type that can store up to 65,535 characters in each record. Can be formatted using rich text formatting

relational database

A database that allows you to relate tables and databases to one another through common fields

subform

A form with the form to display the related records from the "many" table in a one to many relationship

Expressions

A formula used in a calculated field in a table or query or a calculated control in a form or report

relational database

A group of tables related to one another by common fields

one-to-many relationship

A relationship between two database tables where the primary table contains a primary key field that is included as andirons (the foreign key) in the secondary table. This one record in the first table can relate to many records in the second table

delimiter

A specific character that separates the fields in text file with multiple data fields. Common delimiters are commas, tabs, semicolons, and spaces

False

A stacked layout placed labels across from the top with columns of data (similar to a datasheet or a spreadsheet)

Quick Start application parts

A table template that you can use to start building a database.

be unique

A table's primary key must_____

table

All data entered into a form are stored in the underlying______

Forms

Allows database users to input data through a friendly intersurface

Field Properties Pane

Allows you to set field properties in table Design view.

Field List pane

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

control layout

Combines multiple controls in your database form or report into a single layout object in one or two formats: tabular or stacked

5 quick start application parts

Comments, contacts, issues, tasks, and users

criteria

Conditions that the records must meet in order to be included in the query results

Text box control

Control that displays text, numbers, dates, and similar data. Can be bound or unbound

Format field property

Controls the way the data are displayed to the end user

False

Creating a backup of the database removes unnecessary file space and hidden temporary objects from your database

cascading options

Delete and update options that may be applied to relationships between tables. When they are enforced, actions in one table affect records In the related table.

Calculated field data type

Displays a value returned by an expression (a formula)

Control

Displays data or allows user to enter and edit data in a form or report. Controls be bound, unbound, or calculated

report

Displays database info for printing or viewing on screen

Comma style format

Displays the , symbol within the number and two digits to the right of the decimal

field

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

True

Each form and report in a database can have its own theme

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 ____

AutoNumber data type

Fields with this data type are automatically assigned its value by access. Database users cannot edit or enter data in an autonumber fields. AutoNumber fields are often used as a primary key if no other unique field exists in the table

Number Data Type

Fields with this data type hold a numerical value

Date and Time Data

Fields with this data type store a numerical value that is displayed as a date and time. The format in which the date and it time displays is controlled by the format property

Currency Data Type

Fields with this data type store a numerical value with a high degree of accuracy (up to four decimal places to the right of the decimal).

Yes/No Data Type

Fields with this data type store a true/false value as -1 for yes and 0 for no

Hyperlinks Data Type

Fields with this data type store a web address or email address

Find unmatched query

Finds records in one table that do not have related records in another table

Input Mask

Forces users to input data in a consistent format

Single-record form

Form that displays one record at a time

Datasheet form

Form that reproduces the exact look and layout of the table datasheet

Report Footer section

Grand totals in a report are added to the _____

find duplicates query

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 ____

outermost sort

In a multilevel sort, the first field the data are sorted on.

Foreign Key

In a one to many relationship, the field in the secondary table that relates to the primary key in the primary table

filter

Limits the database records displayed to only those that meet specific criteria. They are temporary and are not saved with the database object unless they are defined in the objects properties

Access Web App

Online database that requires a share point server

False

Page numbers can be added only to a footer section

Navigation Pane

Pane that organizes all the objects for a database. Left side of the screen

tabular layout

Places the form or report lanes across the top, with columns of data

Structured Query Language (SQL)

Programming language used in access and other relational database management systems to define queries

Quick Start field

Provide an easy way to add address fields and other common field groups to your table

Report View

Shows a static view of the database report. You cannot change the layout or formatting of the report.

SQL view

Shows the code used to build the query.

padding

Space between the layout rows and columns in a form or report

Wildcard

Special characters used in criteria to substitute for any character * replaces any string of characters ? Replaces a single character

table

Stores all the database data. Basic building blocks of data

Attachment Data Type

Stores files as attachments to records

Rich Text Format (rtf)

Text format can be used with any word processing program

False

The format field property affects the data stored in the table

Query Grid

The lower pane in Query Design View. Where the fields and criteria for the query are defined

referntial integrity

The policy that ensures that related database records remain accurate. If enforced, no modification can be made to either table that would violate the relationship structure

Form Header

The section directly above the detail section where the data are displayed in a form

Form footer

The section directly below the detail section where the data are displayed in a form

False

The upper pane in query design view shows the query grid where you specify which fields to include in a query

True

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"

Linked Table Manager

Took that allows you to update the connection to linked data

Compact and Repair Database

Tool that eliminates hidden temporary objects that take up database space unnecessarily

False

Users can enter and edit data in an auto number field

Data sheet view

View to use when entering data in a table or to sort and filter data. By default tables open in datasheet view

Layout view

View where you can modify some (but not all) structural elements in a form or report.

Design View

View where you establish the table primary key and table properties as well as specific properties or formatting for individual fields. Use design ire when you want to change the structure or properties of the table

outermost

When sorting a datasheet in more than one field, apply the _____ first

Undo the entire record at once

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

Relationships window

Window that provides a visual representation of the relationships in your database

Form Wizard

Wizard that walks you through the steps of creating the form, including selecting fields and a layout. Used to create a form combining fields from multiple related tables

False

You can undo a record deletion

True

You cannot change any properties in the linked table

False

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

split form

combines the convenience of a continuous datasheet form with the usability of a single form displaying one record at a time

Field Size Property

limits the number of characters that can be entered in a text field.