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