MS Access Vocabulary PT 2

Report type in which filed names are located above the fields for each record in blocks

• Relationship Report

• Columnar Report

• Tabular Report

• Justified Report

Report type in which each row is a record and each column is a field

• Relationship Report

• Columnar Report

• Tabular Report

• Justified Report

Report type in which all fields for each record appear together followed by the fields for the next record

• Relationship Report

• Columnar Report

• Tabular Report

• Justified Report

Copy or printout of the relationships between the tables in a database

• Relationship Report

• Columnar Report

• Tabular Report

• Justified Report

Query which extracts certain fields and records based on criteria specified from a table or query in a specific order

• Select Query

• Action Query

• Update Query

• Parameter Query

Query used to change the data in existing tables or make new tables based on the query’s results

• Select Query

• Action Query

• Update Query

• Parameter Query

Query used to change existing data in a database

• Select Query

• Action Query

• Update Query

• Parameter Query

Query which asks for input each time the query is run

• Select Query

• Action Query

• Update Query

• Parameter Query

Query which is based on more than one table

• Multi-Table Query

• Make Table Query

• Append Query

• Control

Query which creates a table containing the fields specified in the query design

• Multi-Table Query

• Make Table Query

• Append Query

• Control