Random 1 - Unit 1
Random 2 - Unit 1
Random 3 - Unit 1
Random 4 - Unit 2
Random 5 - Unit 2
100
A collection of data that has a name and is stored in a computer
What is File
100
Making a copy of a database file to protect your database against loss or damage
What is Backing up
100
Reduces the file size
What is compacting
100
A unique value in a record
What is Primary key
100
A field that appears in more than one table, allowing you to connect or join the records
What is Common field
200
A database object that can be created that makes it easier to maintain, view, and print records in a database in different and useful ways
What is Form
200
A process that rearranges the data and objects in a database to decrease file size, thereby making more space available on your disk and letting you open and close the database more quickly
What is Compacting
200
A single characteristic or attribute of a person, place, object, event or idea
What is Field
200
Define the field's characteristics and behavior, such as data type, field size, etc.
What is Field properties
200
To relate tables through a common field
What is Join
300
Information in a database
What is Data
300
A collection of related tables stored in the same file
What is Database
300
A single piece of information in a database
What is Entry
300
Is a set of rules enforced to maintain consistency between related tables when you update data in a database
What is Referential integrity
300
A relationship between two tables in which each record in the first table matches at most one record in the second table, and each record in the second table matches at most one record in the first table
What is One-to-one relationship
400
A collection of fields that describe a person, place, object, event or data displayed in columns and rows
What is Table
400
A collection of related tables stored in the same file
What is Relational database
400
A formatted printout (or screen display) of the contents of one or more tables in a database
What is Report
400
A referential integrity rule that when a record in the primary table is deleted or changed, the records in the related tables are also deleted or changed
What is Cascade delete/update
400
A field property you add with a predefined format for entering and displaying data. For example you can insert an input mask for phone numbers, zip codes, social security numbers and the like, so that when you are keying in the data you do not have to key in the (), - , etc.
What is Input mask
500
A software program used to create and then manipulate data in it
What is Database Management System (DBMS)
500
A question that can be asked about the data stored in a database, in response, displays the specific records and fields that answer the question
What is Query
500
A folder on a drive or network that can be designated as trusted where databases are stored and considered safe
What is Trusted folder
500
A relationship between two tables in which each record in the first table matches zero, one or many in the second table, and each record in the second table matches at most one record in the first table
What is One-to-many relationship
500
A field property value that displays the rule for the acceptable values for that field. For example, if your database only has students 10-12th grade, your rule would be: Only enter grades 10 through 12
What is Validation text
M
e
n
u