Details

Title: Access chapter 11-12

Description: Business software applications

Total Flash Cards: 11

Created: 04/02/2009 16:03:08

New Users: To study from this flashcard set, or to create your own your own study flash cards, REGISTER HERE.

Existing Users: CLICK HERE.

Additional Business Flashcards

Cards in this set:

Term
Cross tab query
 Definition
calculates a sum, average, count, or other type of total on records and then groups the results by two types of info: one down the left side of the datasheet and the other across the top.
Term
Subquery
 Definition
is a statement that is inside another select or action query
Term
A Select Statement
 Definition
is a SQL command that instructs the Microsoft Access database engine to return info from the database as a set of records.
Term
action query
 Definition
Changes the data in its datasource or creates a new table.
Term
Append query
 Definition
adds the records in the query's result set to the end of an existing table
Term
Delete query
 Definition
removes rows matching the criteria that you specify from one or more tables.
Term
Update query
 Definition
changes a set of records according to criteria that you specify
Term
Make table query
 Definition
creates a new table and then creates records in it by copying records from an existing table.
Term
inner join
 Definition
includes rows in the query only when the joined field matches records in both tables
Term
outer join
 Definition
includes all of the rows from one table in the query results and only those rows from the other table that match the join field in the first table
Term
cross join
 Definition
each row from one table is combined with each row from another table