Fields
Tables & Records
Terms
Forms
Filters
100
this stores letters, symbols, words, and a combination of letters and numbers.
What is a text field
100
A set of data for all fields
What is a RECORD
100
The name of the Database Program we are using
What is Access
100
This is used to create a FORM
What is the WIZARD
100
This limits the records displayed to those that meet certain criteria.
What is a QUERY
200
No Spaces
What should field names not contain
200
This field contains a unique entry for each record.
What is the PRIMARY KEY
200
What is used to enter records
What is a FORM
200
When creating a form the first and most important step is to select the appropriate
What is TABLE
200
A filter is created by selecting the ______________ button
What is FILTER BY FORM
300
This type of field stores several lines of text
What is a MEMO field
300
All fields in a table are __________
What is RELATED
300
This view allows us to see multiple records at once
What is DATASHEET VIEW
300
The record control with the * allows you to do what?
Enter a NEW RECORD
300
These records do not appear when a filter is applied
What are HIDDEN RECORDS
400
This determines how a field is displayed
What is the fields FORMAT
400
A table is created in this
What is DESIGN VIEW
400
A group of related fields
What is a TABLE
400
What 2 locations allow you to enter Records?
What are FORMS & DATASHEET VIEW
400
The data that a record must meet to appear in a filter.
What is CRITERIA
500
There are ____ (number) types of fields that can be placed into a database
What is 6
500
What does RDBMS stand for?
What is a REALATIONAL DATABASE MANAGEMENT SYSTEM
500
Type of field that assigns a value to each new record
What is an AUTO NUMBER FIELD
500
Once the appropriate table is selected you need to decide on what two items for your form? NO NAME is not one of the answers
What is STYLE and LAYOUT
500
This allows us to check for records that contain one of two possible values in filter.
What is the OR TAB
M
e
n
u