Database Study Guide

Document Sample
Database Study Guide Powered By Docstoc
					Database Study Guide

      By Mr. Free
               Question
   What is a database?
                 Answer
   A database is an organized collection
    of information.
               Question
   What are some advantages of a
    database?
Some Advantages of Database
 1. Data can be added and edited
  easily.
 2. Records can be accurately and

  easily sorted.
 3. A person may use a database to
  keep track of names and addresses
  of friends.
                Question
   What are the four parts of a
    database?
                Answer
 1.   File
 2.   Field
 3.   Record
 4.   Entry
                Question
   What is a database file?
                  Answer
   A file is one set of related records in
    a database.
                 Question
   What is a field?
                 Answer
   A field is a category of information
    on a record.
                Question
   What is the first thing to do when
    changing the appearance or format
    of a field in a database?
                  Answer
   Select the field.
                Question
   What is the type of data that shows
    a monetary value in a database?
               Answer
   Currency
                Question
   What is a record?
                  Answer
   A record is a collection of fields and
    entries on one topic.
                Question
   What is an entry?
                 Answer
   An entry is the information entered
    in a field.
               Question
   What is a template?
              Answers
 A template is a pattern or form that
  is used repeatedly for each record in
  a database.
 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.
               Question
   What else do I need to know about
    database templates?
                Answer
   A template arranges data in a
    database in a way that makes it easy
    for anyone to setup and manipulate
    records.
                Question
   What is a report?
              Answers
 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.
               Question
   What does it mean to sort?
                 Answer
   To sort is to arrange information in a
    specific order: ascending or
    descending.
               Question
   What is ascending order?
                  Answer
   Ascending order is sorting:
    • ABC order (A-Z)
    • Numerical order (0-100)
    • Smallest to biggest
    • Least to most
    • Shortest to tallest
               Question
   What is descending order?
                  Answer
   Descending order is sorting:
    • Reverse ABC order (Z-A)
    • Reverse numerical order (100-0)
    • Biggest to smallest
    • Most to least
    • Tallest to shortest
                Question
   What does it mean to search or filter
    when using a database program?
                  Answer
   Search or filter is to look for specific
    informtion.
               Question
   What are connectors?
                 Answer
   Connectors are words such as “and”
    and “or” that join certain conditions
    that meet more than one criteria
    when performing a search or filter.
               Question
   What do the connectors “and” and
    “or” mean?
               Answer
 And is used to connect all criteria
  being used for.
 Or is used to search for any of the

  criteria.
              For Example
   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
    criteria.
                Question
   What is a wildcard?
                 Answer
   A wildcard is a character, such as an
    asterisk (*) or a question mark (?) in
    a search that permits any character
    to be specified.
           Two Examples
 (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.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:10/21/2011
language:English
pages:41