Database Queries Flashcards

The position of items in a document in relation to each other or the grid.

A query that allows the user to create a new table from specified data in applied tables.

<p>Prebuilt combinations of tables, queries, forms, and reports that are easily added to a database.</p> Signup and view all the answers

<p>Important options for managing files and the data in them, including creating new documents and editing document properties.</p> Signup and view all the answers

<p>A copy of a database that is saved in a different location from the original database.</p> Signup and view all the answers

<p>A button, drop-down box, or other interface tool designed to enhance the functionality of a form.</p> Signup and view all the answers

<p>A row in the Design grid that allows the user to enter data to be placed in a query.</p> Signup and view all the answers

<p>Queries that allow the user to calculate aggregate functions such as sum and average in a query.</p> Signup and view all the answers

<p>A collection of data organized into tables which may be used to keep track of information.</p> Signup and view all the answers

<p>A view that shows a clear table of the information that has been specified in the Design View.</p> Signup and view all the answers

<p>A query that allows the user to delete records as specified in entered criteria.</p> Signup and view all the answers

<p>A view setting that allows a user to make changes to a form; provides a more structural look at a form.</p> Signup and view all the answers

<p>The area of a form where data is entered; also known as a text box.</p> Signup and view all the answers

<p>A field that relates to a primary key in another table.</p> Signup and view all the answers

<p>An Access document which allows users to add and delete information from the database.</p> Signup and view all the answers

<p>The process of creating a form to fulfill organizational purposes for specific data.</p> Signup and view all the answers

<p>A program within Access that provides a step-by-step guide to creating a form.</p> Signup and view all the answers

<p>A set of instructions that performs mathematical operations using entered data.</p> Signup and view all the answers

<p>Combine more than one OR statement in a single criteria row.</p> Signup and view all the answers

<p>A table join that combines information from the tables if the linked value is in both applied tables.</p> Signup and view all the answers

<p>A function that conforms input information to a specified format.</p> Signup and view all the answers

<p>The area that designates the type of information to be entered into a corresponding field.</p> Signup and view all the answers

<p>A more realistic view of the form than Design View, showing real data from tables.</p> Signup and view all the answers

<p>An action query that allows the user to move records in the applied tables.</p> Signup and view all the answers

<p>An Access relationship between two foreign keys.</p> Signup and view all the answers

<p>The term describing the border around a page; the white space around a page.</p> Signup and view all the answers

<p>Allow users to search for related records in more than one query.</p> Signup and view all the answers

<p>Search applied tables for an opposite of any criteria.</p> Signup and view all the answers

<p>A set of rules regarding the naming of Access objects.</p> Signup and view all the answers

<p>The pane which appears when a project or database is opened.</p> Signup and view all the answers

<p>A static variable that represents the value of an empty field.</p> Signup and view all the answers

<p>An Access relationship between a primary key and a foreign key.</p> Signup and view all the answers

<p>An Access relationship between two primary keys.</p> Signup and view all the answers

<p>A table join that shows all the data in specified fields of a specified table.</p> Signup and view all the answers

<p>The bottom portion of a database form or report which may contain information such as title or page number.</p> Signup and view all the answers

<p>The uppermost portion of a database, form, or report which may contain information such as title or author.</p> Signup and view all the answers

<p>A placeholder in an expression or formula for user input.</p> Signup and view all the answers

<p>A field in a table whose values are unique to each record.</p> Signup and view all the answers

<p>An Access inquiry about the data stored in a table.</p> Signup and view all the answers

<p>A function used to create queries, specifying data from a database.</p> Signup and view all the answers

<p>An individual entry in a table made up of multiple fields.</p> Signup and view all the answers

<p>A setting that ensures records are entered in one table before being used in another.</p> Signup and view all the answers

<p>An Access database object where users can print organized information from tables.</p> Signup and view all the answers

<p>A view of a form that provides two different views at once: form view and datasheet view.</p> Signup and view all the answers

<p>The basic unit of data storage in an Access database.</p> Signup and view all the answers

<p>A set of predesigned formats and layouts applied to a document for a specific purpose.</p> Signup and view all the answers

<p>A function which ensures that input information meets a certain criteria.</p> Signup and view all the answers

<p>Search for a partial match in the database.</p> Signup and view all the answers