A
used to store related data in a database e.g. customer, pupil, sales etc
table
Validation that ensures the data is entered
Presence check
To rank a number from highest to lowest in a database
Sort
The view the user is in when setting up a database table
Design view
Which is an example of field data that has been formatted as text? A. John B. John1
Both A and B
Data entered as the validation rule to ensure a presence check is added to that field
IS NOT NULL
What criterion will result in NASCAR drivers who have led at least 500 laps this season? A.<=500 B.>=500 C.=500 D.<>500
B
View the user is in when entering data into the database table
Datasheet view
Which data type has only two values
Boolean
meaning of the following logical operator <>
Not equal
Select Ascending or Descending: Based on the correct Sort order to solve the statement. The cities with the MOST snow days were listed first.
Descending
Name 5 data types
Text
Integer
Real number
Date/time
Boolean
The name given to the link between tables in a database
Relationship
A number with a decimal or fractional part
Real number
A database feature that provides a more user friendly interface to input data to a table
Form
What allows for retrieval information that meets specific criteria?
Filter/Query/Search
Three types of relationships in a database
1:1
1:M
M:M
Name given to the field that uniquely identifies a record
Primary Key
A data type which is a whole number
Integer
Validation rule to ensure the number entered falls between a lower and upper limit
Field name
What allows information to be arranged in a specific order ascending (A to Z) or descending (Z to A)?
Sort