Microsoft Access Database Fundamentals

Flashcards covering the essential vocabulary and concepts of Microsoft Access database management, including table structure, field properties, query types, and form components.

Access

A database management system.

Database (CSDL)

A collection of information organized for a specific purpose, often presented in table format.

Table

The base component of Access used to store data, consisting of columns (Fields) and rows (Records).

Field

The individual columns within a table.

Record

The individual rows within a table.

Forms (Biểu mẫu)

Objects designed for entering or displaying data, facilitating communication between the user and the program.

Queries (Truy vấn)

A tool used to extract data based on specified conditions; extracted data is displayed in a table format.

Reports (Báo biểu)

Objects used to display information from tables in various formats to help users effectively consume the information.

Field Name

The object property used for naming a field in a table structure.

Data Type

The object property used to select the type of data a field will hold.

Description

A property in table design used to provide descriptive text for a field.

Field Properties

A group of settings used to configure various attributes of a field.

AutoNumber

A data type that automatically inserts a numeric value for every record created.

Yes/No

A data type used for logical values.

Caption

A property that allows for a custom label or title for a field.

Field Size

A property that determines the maximum character length allowed for a Text field.

Format

A property used to define how data is displayed.

Input Mask

A property used to create an input template or pattern for data entry.

Required

A property that determines if a field must contain data or if it can be left null.

Default Value

A property used to specify an initial value that is automatically entered in a field when a new record is created.

Validation Rule

A property used to set conditions that must be met before a new record can be saved.

Validation Text

The error message that appears when data entered violates the Validation Rule.

Allow Zero Length

A property that controls whether Text or Memo fields can accept an empty string.

Input Mask '0'

Represents a position for digits $0$ to $9$ where entry is mandatory.

Input Mask '9'

Represents a position for digits $0$ to $9$ where entry is optional.

Input Mask 'L'

Represents a position for letters where entry is mandatory.

One-to-One

A relationship where each record in the first table is associated with exactly one corresponding record in the second table.

One-to-Many

A relationship where one record in the primary table can have many corresponding records in the related table.

Many-to-Many

A relationship where multiple records in the first table relate to multiple records in the second table.

Make-Table Query

A query type that generates a new table to store the results of the query.

Update Query

A query type used to modify existing data within a table.

Append Query

A query type used to add one or more new rows of data to the end of a table.

Delete Query

A query type used to remove one or more rows of data from a table.

Crosstab Query

A query type used for statistical analysis and calculations, displaying data in rows and columns.

Select Query

A query type that retrieves and displays information from tables without altering the source data.

Criteria

A row in the query design grid that holds values or expressions to filter the records.

Form Header

The section where controls appear at the top of the form screen.

Detail Section

The section of a form where record details are displayed.

Form Footer

The section where controls appear at the bottom of the form screen.

Record Source

A property used to identify the specific table or query that serves as the data source for a form.

Label

A form control used to display descriptive text.

Command Button

A form control used to execute actions or commands when clicked.