Chapter 1
Chapter 2
Chapter 3
Chapter 4 & 5
Chapter 5 & 7
100
A question you ask about the data stored in a database in responce access displays the specific records and fields that answer your question
QUERY
100
_________ is the value that results from not entering a value for a field; it is not permitted for a peimary key.
What is Null Value
100
A field that displays the results of an expression in a query datasheet ot a form or report but does not exist as a field in the databse
Calculated Field
100
What character would you use if you wanted to search & match a certain pattern??????
Wildcare Character
100
A primary key field from one table that you include as a field in a second table to form a relatioship between the 2 tables
Foreign Key
200
A field or a collection of field whose values uniquely and minimally identily each record in a database table an dwhose values do not change
What is Primary Key
200
Including the contents of a file in a new table or appending the contents to an existing table or including the contents of the file in a form report or file
What is Import
200
A database that displays the records related to the current record.
Subdatasheet
200
What style predefined can you apply to a form or report??
AutoFormat
200
_______ controls the apprance of a control or section in a form or report when printed or previewed
Can Grow Property
300
An access view in which you can make design changes to a form or report while it is displaying data so that you can immdiately see the effects of changing the design
What is Layout View
300
The access view you use to define or modify a table structure or the properties of the fields in a table
Design View
300
A function that performs an artithmetic operation on selected records in a database :)
Aggergate Function
300
A query that displays adialog box to prompt you to enter one or more criteria values when you run the query
Parameter Query
300
_____ appears by itself at the top of a page
Orphaned Footer Section
400
The Access view that shows a table contents as a "datasheet" rows and columns, similar to a table or spreadsheet
What is Datasheet View
400
A relationship between two tables in which each record in the primary table matches zero, one, or many records in the related table and in which each record in the related table matches at most one redord in the primary table
On to many relationship
400
In a query an operator that allows you to combine 2 or more conditions
Logical Operator
400
What lets the user select a value from a list of possible values
A lookup field
400
________ appears on the bottom by itself
Orphaned Headesection
500
A field thay appears in more than one table allowing you to connect the records in the seperate tables.
What is Common Field
500
___________ is a condition that occurs when you store the same data in more than one place it wastes storage space and cause inconsistencies
Data Redundacy
500
To add change an delete records in database tables to keep them current and accurate
Maintain (a database)
500
A function that returns one or two values base on whether the condition being tested is true or false
IIF Function
500
_______ provides an interactive view of a report
Report View
M
e
n
u