Access Data Manipulation - Glossary

Action query:
A query which makes changes to your data. Action queries include the Make-Table Query, Update Query, Append Query, and Delete Query." Ascending order "When you sort in ascending order, values appear from smallest to largest, dates and times appear from earliest to latest, and text is sorted from the beginning of the alphabet to the end.
A form created automatically from the fields in one table or query.
Bound controls
A control that is associated with the contents of a field.
Calculated data: Data created as the result of an expression, often an arithmetic or logical expression, i.e. Profit could be calculated as Income-Expenses. Calculations can also be used to summarize data, i.e. Total value of goods sold."
Any object on a report or form. A control can display a line, text, or the contents of a field.
A condition or test. If you want to find addresses in Arizona, then your criteria is that the state must be Arizona.
Criteria expression:
A statement of a condition or text which data must meet. A criteria expression can be as simple as =10 or a more complex arithmetic or logical statement that Access must evaluate.
Crosstab query:
A query that summarizes your data by using values from one field as column labels and values from another field as row labels. The data are summarized according to the method you select.
Pieces of information such as numbers, dates, or text.
Data type:
A category of data. Each field must have a data type such as Number, Text, or Date/Time.
An organized set of related data. In Access, a database is the file that contains the tables, queries, forms, reports, and other objects for one set of related data.
Database window:
The Access window that displays the names of all the objects in the database. This window allows you to open different objects in the database. By closing the database window, you close the open database
Datasheet view:
The view of a table or query that shows the data in rows and columns.
Descending order:
When you sort in descending order, values appear from largest to smallest, dates and times appear from latest to earliest, and text is sorted from the end of the alphabet to the beginning.
Design view:
The view of an object that allows you to refine the object definition.
The results of a query. So called because each time the query is run, it looks at the current data in the database and may produce different results if the contents of the database have changed. Thus the results are dynamic, rather than static.
A column in an Access table. One category of data, i.e., first name.
Display a subset of records in a datasheet by applying a criteria.
Filter by Form:
Filter a datasheet using criteria for multiple fields.
Filter by Selection:
Filter a datasheet to find records that match a value in one field. You must be able to find one record that meets your criteria.
Filter For:
Filter a datasheet by typing in the value you want to find for the selected field. Display the Filter For command by putting the cursor in the field and right-clicking.
Search for text or values.
This Access object is used to enter and display data. Forms can be designed and formatted to present a custom view of the database.
Reports are often used to group data, that is, to put data with identical values in a certain field together. For instance, if you group projects by company, you will see all the projects for one company together
Small black squares around a selected control. Handles can be used to change the size of a control.
Special text that can be clicked to take you somewhere else. Hyperlinks can take you to a new web page or open a file.
Input mask:
Part of a field's definition, where an input mask specifies the number and type of character that can be entered in the field.
Access objects consist of tables, queries, reports, and forms as well as the more advanced objects, Pages, Macros, and Modules.
Symbols (or words) used in expressions to tell Access how to define criteria or calculations. Common operators are =, +, -, *, /, AND and OR.
Primary Key:
The field in an Access Table that uniquely describes each record enabling to select rows and perform updates.
The Access object used to ask questions of your data.
Query definition:
The statement of the question you want to post to your database. Queries are defined in query design view. The query definition can include tables, fields, criteria, expressions to create new fields, summary calculations, and more.
Raw data:
Data entered by the user (as opposed to data calculated by Access).
One row of data in an Access table. A set of related information for one entity, i.e., the name, address, and phone number for one person.
Referential integrity:
You may choose to enforce referential integrity when you create a relationship between fields in different tables. If you select the Enforce Referential Integrity check box, Access will not let you enter data on the many side of the relationship unless it has a corresponding record on the one side of the relationship.
Related data:
Data about the same topic. For instance, an address can be related to a name, if it is the address of the named person. A record of data about a project (such as the description, due date, and expected hours of work) can be related to a record of data about the client for whom the project is being done.
Related fields:
Fields in different tables that contain substantially the same data and are used to define the relationship between the two tables. For instance, the Client ID field in the Clients table uniquely identifies each client, and it is related to the Client field in the Projects table with identifies which client the project is being done for. When these tables are related you can combine data from both tables in queries, forms, and reports.
This Access object is used to present data, usually on paper. Reports can be designed and formatted to display data and aggregate calculations so that they can be easily read and analyzed.
Reports and forms are broken into sections. Sections mainly determine how the form or report is grouped, but they are also used for page headers and footers and report headers and footers.
Put records in order. Usually you will sort using one field, and you may sort in ascending or descending order.
Status bar:
The bottom-most row of the Access window.
A datasheet within a datasheet that displays related data from a related table.
A form within a form, often displaying records from a different table or query than the data displayed in the main form. When there is a one-to-many relationship between the tables that the form is based on, a subform can be used to display many records that are associated with the single record displayed in the main form.
Summary calculations:
Summary calculations provide a calculation like a sum or average for a group of data or all data. Summary calculations can be created using queries, forms (although, not easily) and reports.
The Access object that stores data.
Table Wizard:
This wizard creates common tables. When you select the table name, you see field names that you can select from. When the table is created, each field is given the properties that you are most likely to need.
A model for a database that contains no data but has predefined tables, relationships between tables, queries, forms, and reports.
Unbound controls:
A control that is not associated with the contents of a field--it remains the same no matter what record is displayed, or how data in the database changes. Labels and lines on forms and reports are unbound controls.

Save Time Writing