Database Study Guide
By Mr. Free
What is a database?
A database is an organized collection
What are some advantages of a
Some Advantages of Database
1. Data can be added and edited
2. Records can be accurately and
3. A person may use a database to
keep track of names and addresses
What are the four parts of a
What is a database file?
A file is one set of related records in
What is a field?
A field is a category of information
on a record.
What is the first thing to do when
changing the appearance or format
of a field in a database?
Select the field.
What is the type of data that shows
a monetary value in a database?
What is a record?
A record is a collection of fields and
entries on one topic.
What is an entry?
An entry is the information entered
in a field.
What is a template?
A template is a pattern or form that
is used repeatedly for each record in
When creating a database, the
template is the blank form that
comes up each time a person adds a
new record to the database file.
What else do I need to know about
A template arranges data in a
database in a way that makes it easy
for anyone to setup and manipulate
What is a report?
A report is a printable summary of
the information in a database.
A report is a display of records or
parts of records that satisfy a
particular search or sort.
What does it mean to sort?
To sort is to arrange information in a
specific order: ascending or
What is ascending order?
Ascending order is sorting:
• ABC order (A-Z)
• Numerical order (0-100)
• Smallest to biggest
• Least to most
• Shortest to tallest
What is descending order?
Descending order is sorting:
• Reverse ABC order (Z-A)
• Reverse numerical order (100-0)
• Biggest to smallest
• Most to least
• Tallest to shortest
What does it mean to search or filter
when using a database program?
Search or filter is to look for specific
What are connectors?
Connectors are words such as “and”
and “or” that join certain conditions
that meet more than one criteria
when performing a search or filter.
What do the connectors “and” and
And is used to connect all criteria
being used for.
Or is used to search for any of the
If a school principal has a database
of 725 names and addresses of
students enrolled at the school and
wanted to know the phone numbers
of one particular student, he/she
would perform as search or filter
using the student’s name as a
What is a wildcard?
A wildcard is a character, such as an
asterisk (*) or a question mark (?) in
a search that permits any character
to be specified.
(1) A criteria al* will find Alabama,
already, or Albert.
(2) The most efficient method when
searching in a database for all
students with the first name of
M*chael is wildcard.