Access - CIS
A view that enables you to add, edit, and delete the records of a table.
A view that enables you to create tables, add and delete fields, and modify field properties; or to change advanced design settings not seen in Layout view, such as a background image.
The smallest data element in a table, such as first name, last name, address, or phone number.
Displays a subset of records based on a specified criterion.
A database object that is also a primary key of another table.
A connection between two tables using a common field.
The field (or combinations of fields) that uniquely identifies each record in a table.
An interface element that organizes and lists database objects.
Enables you to ask questions about the data stored in a database and then provides the answers to the questions by providing subsets or summaries of data.
A group of related fields representing on entity, such as data for one person, place, event, or concept.
An object that contains professional-looking formatted information from underlying tables or queries.
The process of listing records or text in a specific sequence, such as alphabetically by last name.
A number, text phrase, or an expression used to select records.
An object used to store and organize data in series of records.
Produces a value from an expression or function that references one or more existing fields.
Used to create a more readable label that appears in the top row in Datasheet View and in forms and reports.
A row in the Query Design view that determines which records will be selected.
Rules in a database that are used to preserve relationships between tables when records are changed.
Determines the type of data that can be entered and the operations that can be performed on that data.
The term Access uses to describe a blank field.
Simple Query Wizard
Provides dialog boxes to guide you though the query design process.
A relationship established when the primary key value in the primary table can match many of the foreign key values in the related table.
Prevents invalid data from being entered into a field.
Any data needed to produce output for a function.
Order of Operations
Determines the sequence by which operations are calculated in an expression.
Enables you to change settings such as number format, number of decimal places, and caption, among many others.
A formula used to calculate new fields from the values in existing fields.
An Access tool that helps you create more complicated expressions.
A predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments.
A value that does not change.
The rules that dictate the structure and components required to preform the necessary calculations in an equation or to evaluate expressions.
A predefined formula in Excel that calculates he periodic loan payment.
A table row that displays below the last row of records in an Excel table, or in Datasheet view of a table or query, and displays summary or aggregate statistics, such as a sum or an average.
Makes an additional row available in the query design grid. Used to display aggregate data when the query is run.
The text boxes, buttons, boxes, and other tools you use to add, edit, and display the data in a form or report.
Enables you to see what a printed report will look like in a continuous page layout.
Used to instantly create a tabular based on the table or query currently selected.
Asks you questions and uses your answers to generate a customized report.
The table or query that supplies the records for a form or report.
Used to create data entry forms for customers, employees, products, and other primary tables.
A simplified interface primarily used for data entry. Does not allow you to make changes to the layout.
Enables users to make changes to a layout while viewing the data on the form or report.
Provides guides to help keep controls aligned horizontally and vertically and give your form a uniform appearance.
Combines two views of the same record source--one section is displayed in a stacked layout, and the other section is displayed in a tabular layout.
Displays fields in a vertical column.
Displays data horizontally.
A collection of design choices that includes colors, fonts, and special effects used to give a consistent look to a document, workbook, database form or report, or presentation.