Term
| Tables, Queries, Forms, Reports |
|
Definition
| What are the four most common elements of a database? |
|
|
Term
|
Definition
| A collection of tables that are related. |
|
|
Term
|
Definition
| A set of field values in a table. Also known as a row. Horizontal. |
|
|
Term
|
Definition
| A single attribute of a table. Also known as a column. Vertical. |
|
|
Term
|
Definition
| The contents within a field. |
|
|
Term
|
Definition
| A field that appears in multiple tables, and is used as an endpoint of a join. |
|
|
Term
|
Definition
| A unique attribute used to identify individual records in a table. No two records with this attribute can contain the same value. |
|
|
Term
|
Definition
| A primary key from another table that is used to link multiple tables together. |
|
|
Term
|
Definition
| A combination of two or more fields in a table that contain a primary key and are used to uniquely identify each record; similar to a primary key. |
|
|
Term
|
Definition
| Given when no data is entered into a field. |
|
|
Term
|
Definition
| A collection of fields within a database. |
|
|
Term
|
Definition
| The table in a one-to-many relationship that contains only one record. |
|
|
Term
|
Definition
| A “many” table in a one-to-many relationship; it usually contains more than one record. |
|
|
Term
|
Definition
| A database object used to display records individually for easily inputting data. |
|
|
Term
|
Definition
| Specific fields and records from different parts of a database that are merged together after asking to find the data containing those specific attributes. |
|
|
Term
|
Definition
| A formatted summary of some or all of the contents of a database that is used to neatly summarize and view data. |
|
|
Term
|
Definition
| A relationship between tables that have a common field. This relationship is represented by lines between the fields. |
|
|
Term
|
Definition
| Determines the kind of information that can be entered into a particular field. |
|
|
Term
|
Definition
| A property that deletes a record in the primary table and all matching foreign key records. |
|
|
Term
|
Definition
| A property that changes the primary key along with any matching foreign key values in related tables. |
|
|
Term
|
Definition
| A property on a join that prevents orphans. |
|
|
Term
|
Definition
| A relationship between two tables when one record in the first table matches record(s) in the second table, but the second table matches only one record in the first table. |
|
|
Term
| Many-To-Many Relationship |
|
Definition
| A relationship in which more than one record matches between two tables. In order for this relationship to exist, a third table must be created that shares one-to-many relationships with both tables. |
|
|
Term
|
Definition
| A “child record” with a foreign key to a “parent record” that has been deleted or changed its primary key. |
|
|
Term
|
Definition
| Used to enhance the performance of the database. Using this decreases the file size of the database and fixes any damage to the database. |
|
|
Term
|
Definition
| A datasheet that displays records in a table related to the current record. Appears after performing a join. |
|
|
Term
|
Definition
| Used to assign various attributes to objects and values within the database. |
|
|
Term
|
Definition
| A property for a long text field that, when set to "yes", keeps a historical record of all versions of the field value along with timestamps of when the edit occurred. |
|
|
Term
|
Definition
| A field property that specifies how the field name is displayed in database objects. This does not change the name of the field. |
|
|
Term
|
Definition
| When fields of data in a file to be imported are separated by a character such as a comma. |
|
|
Term
|
Definition
| The process of joining multiple text fields or characters into a single item by using an operator between strings encapsulated in quotes. |
|
|
Term
|
Definition
| A field used for customizing how data is displayed that lets a user select a value from a list of possible values to enter data into a field. |
|
|
Term
|
Definition
| This function tests a condition and returns one of two values based on whether the tested condition is true or false. |
|
|
Term
|
Definition
| A function that tests a field value or expression for a null value. The function returns true if the field value or expression is null; otherwise it returns false. |
|
|
Term
|
Definition
| Calculates the total of an expression. |
|
|
Term
|
Definition
| Calculates the number of occurrences of an expression. |
|
|
Term
|
Definition
| A value or expression used to limit which results should be displayed in a query. |
|
|
Term
|
Definition
| A query in which fields are selected and the results are returned in the form of a datasheet. |
|
|
Term
|
Definition
| A select query that finds all records in a table or query that have no related records in a second table or query. Often used to find orphan records. |
|
|
Term
|
Definition
| A query that displays a dialog box that prompts the user to enter information to display certain values. |
|
|
Term
|
Definition
| A query that summarizes data by using aggregate functions to perform arithmetic operations on selected records and then grouping the results by headings on the side and top like a spreadsheet. |
|
|
Term
|
Definition
| Used to limit query results to only those matching the range within a certain integer or percentage. |
|
|
Term
|
Definition
| When a change to the properties of one object affects the properties of another object. |
|
|
Term
|
Definition
| A field created with an expression that displays the results of the expression in a datasheet, form, or report. |
|
|
Term
|
Definition
| Visual changes applied to certain field values depending on the specified conditions. |
|
|
Term
|
Definition
| A function that performs an arithmetic operation on selected records. |
|
|
Term
|
Definition
| A symbol that specifies the type of calculation to be performed within an expression. |
|
|
Term
|
Definition
| Plain text that is displayed when quotation marks are placed around a value. |
|
|
Term
|
Definition
| A statement containing a combination of fields, constants, and operators that are defined in a query to perform a calculation. |
|
|
Term
|
Definition
| A field property that is used to set a predefined format to enter and display data in a field. |
|
|
Term
|
Definition
| A field property value that specifies the valid values that users can enter in a field. |
|
|
Term
|
Definition
| A field property value that will be displayed in a dialog box if a user enters an invalid value for the field. |
|
|
Term
|
Definition
| Used to highlight an entire row in a form. Should always be disabled on the final product of the form. |
|
|
Term
|
Definition
| A form based on related tables. Often contained within another form. |
|
|
Term
|
Definition
| An item, usually on a form or report, that can be manipulated to modify the object's appearance. |
|
|
Term
|
Definition
| An unbound control that displays text. |
|
|
Term
|
Definition
| A set of controls grouped together in a form or report that can be manipulated as a single control. |
|
|
Term
|
Definition
| A control based on using an existing field as a data source. |
|
|
Term
|
Definition
| A control without a source from the database. Used to display custom information such as labels and graphics. |
|
|
Term
|
Definition
| A control that uses an expression as a data source. |
|
|
Term
|
Definition
| A label that allows various types of data to be displayed in a form. |
|
|
Term
|
Definition
| A control that displays a scrollable list of values. |
|
|
Term
|
Definition
| A control that combines both the features of a text box and a list box. It is used to either choose a value from a list or type an entry. |
|
|
Term
|
Definition
| A property that specifies whether users can use the tab key to navigate between controls on a form. |
|
|
Term
|
Definition
| The order in which the controls will be navigated when moving between different controls in a form using the tab key. |
|
|
Term
|
Definition
| View in which design changes can be made to a form or report while data is being displayed. Used to immediately see the effects of the visual changes. |
|
|
Term
|
Definition
| A type of form that contains all fields in a table or query and visually resembles a table or query. |
|
|
Term
|
Definition
| A form that simultaneously displays data in both form view and datasheet view. |
|
|
Term
|
Definition
| A type of form that displays many records from a source table or query and is displayed in a datasheet format. |
|
|
Term
|
Definition
| Sets the spacing around text that is inside of a control. |
|
|
Term
|
Definition
| Sets the spacing around the outside of a control. |
|
|
Term
|
Definition
| Specifies the default control used to display a field. |
|
|
Term
|
Definition
| Specifies the data source for a control in a form or report, or for a field in a table or query. |
|
|
Term
|
Definition
| Places a control into a specific position on a form. |
|
|
Term
|
Definition
| Area in form design view with dots and lines that is used to precisely position controls in a form. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A tool used to generate detailed information about selected database objects. |
|
|
Term
|
Definition
| A section that appears by itself at the bottom of a page of a report. The keep together property should be used to avoid this. |
|
|
Term
|
Definition
| A section that appears by itself at the top of a page of a report. The keep together property should be used to avoid this. |
|
|
Term
|
Definition
| Property of a report that prints a group header on a page only if there is enough room on the page to print the first detail record. |
|
|
Term
|
Definition
| When set to "yes", expands a text box vertically to fit the field value when the report is printed. |
|
|
Term
| To enclose an expression, or parts of an expression if in a statement with many operators. |
|
Definition
| When are parentheses () used? |
|
|
Term
| To specify the name of a field, table, or other object. |
|
Definition
| When are square brackets [] used? |
|
|
Term
| Between the names of two or more bracket enclosed field names, table names, or other object names in order to specify use of the object in an expression. When searching, can also be used as a wildcard character to match any character that is not within brackets. |
|
Definition
| When is an exclamation point (or bang) ! used? |
|
|
Term
| To refer to the property of an object. It goes between the name of the object and the object's property. |
|
Definition
When is a period (or dot) . used? |
|
|
Term
| To enclose a literal. Also used in concatenation. |
|
Definition
| When are quotation marks "" used? |
|
|
Term
| To name an expression. This will always be the beginning part of an expression in a query. |
|
Definition
|
|
Term
| To concatenate two or more objects. |
|
Definition
| When is an ampersand & used? |
|
|
Term
| As a wildcard character. All or part of the criteria specified before this symbol will be returned in the query result. |
|
Definition
| When is an asterisk (or star) * used? |
|
|
Term
| To enclose number strings, usually those containing non-numeric characters such as dates, in order to distinguish them separately from the rest of the expression. When searching, can also be used as a wildcard character to match any number in the place of the symbol. |
|
Definition
| When is a pound sign (hash mark) # used? |
|
|
Term
| At the beginning of an expression to specify an operation or constant to be performed. Also can be used within an expression to determine if multiple values are equal. |
|
Definition
| When is an equal sign = used? |
|
|
Term
| When searching, as a wildcard character to match any single alphabetic character. |
|
Definition
| When is a question mark ? used? |
|
|
