Font size
WorksheetsDatabase quiz
Total questions: 16
Worksheet time: 9mins
What application software have we used to create our databases?
Excel
Word
Notepad
Access
A database with one table is called a
Flat file database
Bumpy file database
Relational database
Flat field database
The rows in a table are called the...
Records
Turn tables
Primary Key
Fields
The columns in a table are called...
Rows
Primary Key
Fields
Flat file
The unique identifier is called
Row
Field
Primary Key
Database
A database definition is....
To store data
To search data
To store and search data
To make your head hurt
Which two are relationships within databases?
Father and Son
1 to many
Many to many
Mother and daughter
What do you use to search in a database?
Table
Query
Form
Manually look through records
How many entities (things) should there be in a database table?
1
2
3
It doesn't matter
How do we let the end user select the search criteria?
Parameter queries
We guess what they will want to search for
You can't do this
Do a query for every possible option
What is the first step in creating a database?
Creating a design
Creating a table
Creating a query
Creating a form
Currency, Date/time, number are all examples of what?
Data types
Validation
Data
Information
Which two are types of validation?
Currency
Date/time
Presence check
Format Check
Which operator is less than or equal to?
<=
=<
>=
=>
Which operator is equal?
=
==
"="
<=>
What does AutoNumber do?
Automatically creates a random number that is not duplicated
Puts the same number in the table every time
Automatically creates a random number that can be duplicated
Moves to a random record
