Access

Field Property

Characteristic that helps define a field. -Field size 5, caption, format -Field name can be up to 64 characters.

Relational Database

Contains multiple tables that can be linked by a common field.

Subdatasheet

Data table within a main data table, contains info that is related or joined to main table. Easily view and edit related data.

Form

Database object used to display records onscreen to make it easier to enter new records and change existing ones. Based on an underlying table.

Relationship

Establishes the association between common fields in two tables. Must be the same data type and contain same type of info, can have different field names.

Query Criteria

Expressions that are used to restrict the results of a query.

Primary Key

Field that uniquely identifies each record, prevents duplicates. -employee ID, unique for each.

Expression

Formula consisting of a combination of symbols that will produce a single value Combining Identifiers, Operators, Constants and Functions. "m"

Constants

Numbers, dates, character strings (are in "quotes" )

Object

Objects make up a database (unity of a database), they can be created, selected, and manipulated. - Table- sort data - Query- Find and display selected data - Form- View, add, and update data in tables. - Report- Analyze and print data in a specific layout.

Controls

Objects that display information, perform actions, or enhance the design of a form or report. -Different fields in a record (Zip Code label, Zip code box, Gender label, Gender fill in box) -Text and label controls are most common

Theme

Predefined set of formatting choices that can be applied to all objects in a database in one step.

Report

Professional appearing output generated from tables or queries that may include design elements, groups, and summary information.

Lookup Field

Provides a list of values from which a user can choose when entering data. -Lookup wizard

Find and Replace

Quickly find specific information and auto replace with new info

Sorting

Rearranges order of records based on the value in each field

Query

Request for specific data contained in a database. Used to view, analyze and change data. Based on tables... you can use a query as the source of a form or report.

Filter

Restriction placed on records in the open table to quickly isolate and display a subset of records.

Validation Rule

Specifies certain data values that are allowed for a particular field "f" or "m" for a gender field

Operator

Symbol/word indicates a certain operation. = equal to <> not equal to < less than > greater than

Data Type

Type of data that the field will contain. -short text, long text, number, currency, attachment

Navigation Pane

Used to open and manage database objects.

Join

An association that is created in a query between a field in one table and a field of the same data type in another table

Identifier

An element that refers to the value of a field. - [Sales Amount] + [Sales Tax], both in brackets are identifiers bc they refer to the amounts that are in the sales amount and tax fields.

Views

1. Datasheet- row and column view of data in tables or query results. 2. Form 3. Report 4. Design- can create a table, form, report or query. Displays underlying design structure, not data. 5. Layout- displays data during design process

Database

A database is an organized collection of related information. This info is typically stored in a table consisting of multiple rows and columns. Each row contains a record (all the info about one person; collection of related fields). Each column contains a field (smallest unit of info about a record).

Default Value Property

To specify a value that is automatically entered in a field when a new record is created. "CA" for state

Format Property

To specify the way that something (numbers, dates, times and text) in a field are displayed. > uppercase < lowercase