Database Review

Document Sample
Database Review Powered By Docstoc
					   Database Review
     North Carolina
Computer Competency Test
The 1st Look at the Database


•What’s it about
               Read all field names/ skim data within

•Which tool buttons
               Quickly locate commonly used buttons for DB

•Which commands
               If tool buttons missing, look at different menus.

•Different views
               Know how to change from form to list view.
What is the database about?
 What are the field names?


  What data is contained within the fields?




            Tab across, looking at each field name and contents.

 How many records are in the database?
            Located bottom right of screen.
            Equal numbers means all records are displayed.
                   Know Your
                 Toolbar Buttons
                      AND
              Menus with Commands




Tools          View       Records           Records
    Filters       Lists      Show            Sort records…
                               1 All records
More than 1 way to view the database!

                            List




 Switching Views

                     Form
   Know how to
  move from one
  view to another.
Database Questions
   General Info
Read the entire question.
General Information
Concerning The Test Questions
• Less than 8 questions to answer.
• Start easy, become more difficult.
• Short answer, multiple choice, and 2-3
  require writing an explanation of the steps
  to obtain the correct answer.
• You must decide whether to filter, sort,
 or do a combination of both for each
 question.
Continue…..

• Notice the different styles of the questions.
• To answer ALL the questions a filter, sort,
  or combination must be done.
• Do not attempt to scroll through the
  database to find the answers.
• Carefully reading the question cannot be
  over emphasized.
Look for these things……

• Questions can be awkwardly worded.

• Field names appear in all caps.

• Some questions contain specific
  information and others seem rather
  general.
Moving from one question
to the next.
 After answering a filter question, all the
 database records should be displayed before
 moving to the next question.




                              Records
                                 Show
                                   1 All records
 Deciding if question is a
• The question contains the name of a field, but     Last
  no “real” data that is contained with the field.   First
• General terms will be found to indicate the way
                                                     Greatest
  you will need to sort the data. :
                                                     Least
 Ascending
                                                     Lowest
 A-Z, 0-9
                                                     Highest
                                                     Most
                                                     Longest
 Descending                                          Shortest
 Z-A, 9-0
Deciding if questions is a
The question ALWAYS contains data that will be located within a
  field and as a general rule the field name is included within
  the question.

Questions can be single criterion or multiple criteria, look for
  AND or OR to determine if the filter will contain more than
  one set of criteria to be included in the search.
Set up the filter.
                   Select the
                   comparison using
Select the field
                   the drop down arrow,
using the drop                              Here type,
                   =/>, =/<, >, <, = are
down arrow,                                 information that
                   usually used with
NEVER type in                               is given in the
                   NUMBERS.
this box.                                   question.
            1st    Is equal to, contains,   It must be
                   begins with are used     EXACT, just as it
                   with TEXT.               appears in the
                                 3rd        field.
                                                   2nd
     Comparisons
Area                       Services
(Sq.                       Provided
Miles)
  22.5 pet kennel, strollers, photo developing, first aide
       station
  10.3 photo developing, wheel chairs, airport shuttle
       services
  10.0 hiking trail
  62.0 golf course, boating docks
  10.0 ATM
            Fields with multiple data tend to require the
            comparison Contains.
  Error message after apply filter!

• Re-read your question; is the correct information in the
  filter?
• Does the data in “compare to” also appear in the field?
• Check the “compare to” field for correct spelling
• Is the correct “comparison” is being used?
• Is the correct “connector” being use – and / or?
Keep answers short and simple
Avoid unnecessary words.
Write legible and spell correctly.
It is okay to use abbreviations like
      >, < , , , and =.
       Example Questions
       50 States Database
            These questions are in your packet study guide




Are they short answer or
discussion/short answer or
multiple choice?
1. Which state calls the Iris its FLOWER?
                                  Short answer
2. Which state has the last admission (ADMITTANCE)?
                              Short answer
3. Which group of states are producers of peanuts
(AGRICULTURE)?
a. Alabama, Washington, South Carolina, North Carolina
b. Washington, Wisconsin, Alabama, Georgia
c. Georgia, North Carolina, Georgia, Alabama
Explanation Use database terms to describe the steps
Explanation:
you took to find your answer.
                                 Multiple Choice/
_____________________________________________
                                 Discussion
_____________________________________________
_____________________________________________
_____________________________________________
4. What is the capitol of the state that is in the Midwest
REGION with its HIGHEST POINT greater than 7200 feet,
and is know for MANUFACTURING medical equipment?
Explanation: Use database terms to describe the steps
you took to find your answer.
_____________________________________________
                                        Short Answer/
_____________________________________________
                                        Discussion
_____________________________________________
5. What is the nickname of the state gaining STATEHOOD
in 1850 with a POPULATION (POP 1990) of greater than
25000000
Explanation: Use database terms to describe the steps
you took to find your answer.
                                       Short Answer/
_____________________________________________
                                       Discussion
_____________________________________________
_____________________________________________
6. You have been assigned to do a project on one of
the states that has greater than 30 ELECTORAL
votes or population (POP 1990) greater than
10000000. Of the states you can research which one
has the most state representatives (STATE REPS)?
                                    Short answer
7. There were 2 projects in the class that received
grades of an A. The states used in the projects met
the following criteria:
a. AREA more than 80500                          Not
b. GOVERNOR - TERM 4 years
c. Midwest REGION                             Multiple
Which state had the last ADMITTANCE?           Choice
                   Short answer
Guaranteed
 Success
                                           They will work!
1.   Find the “W” word. (what, when, who, where,
     which, how many)
2.   Circle the “W” word phrase and FORGET IT FOR NOW.
     Read it after you have finished the sort or filter!
3.   Focus on the remaining words.
4.   Can you find field names??? Underline them!
5.   Do you see any “AND” or “OR” words??? Box them!
6.   Find any specific words that would appear as data within
     the field(s)??? Link with arrows to the field!
7.   Find any general words indicating a sort???
     Triangle them!
8.   Decide if this question require a filter, a sort, or
     both filtering and sorting???
NETWORK TELEVISION
PROGRAM DATABASE
QUESTIONS These questions are in your packet study guide
                     How to work the problems!
1. What is the network, the show the

Adventures of Rin Tin Tin appeared on for
              =
many years (PROGRAM)?
                  ABC
Filter

PROGRAM = Adventures of Rin Tin Tin

Look for answer in NETWORK field




                                      1
2. Which program lasted for the greatest

number of YEARS ON TV?
      Walt Disney Productions

Sort by YEARS ON TV descending order

Look for answer in PROGRAM field




                                       2
3. For which group of programs is their

        =
GENRE an adventure?

a. Northwest Passage, Encounter, Yancy
Derringer
b. Yancy Derringer, Steve Canyon, Perry
Mason
c. Northwest Passage, Steve Canyon,
Yancy Derringer
4. What is the favorite ride in parks
                               
established (YEAR ESTAB) after 1970
or   having greater than 70 rides
(AMUSEMENT RIDES)?         
          C
Filter

GENRE = Adventure
Look for the answers in the
PROGRAM field that matches the
multiple choice answer



                                 3
4. Which program had a
                        > than 150
MONTHS EXISTED number greater

                           <
months and YEARS ON TV number less than 5?

Use database terms to describe the steps you

took to find your answer:
    Adventures of Ellery Queen
Filter
MONTHS EXISTED > 150      month
AND
YEARS ON TV < 5 Years

Look for the answer in PROGRAM field


                                       4
5. Which program, FIRST TELECAST in

                 =
October 1954 had the greatest number

of MONTHS EXISTED? Use database

terms to describe the steps you took to

find your answer:
         Walt Disney Presents

Filter

FIRST TELECAST = October 1954

Then Sort the filter results
MONTHS EXISTED descending

Look for answer in PROGRAM field


                                   5
6.One group of students has decided to
                   = shown on ABC -
research the programs
                              >
NETWORK or TIME STARTED was after 8:00.

Of the programs you can use, which genre is

the greatest MINUTES LONG?
           Sports
Filter

NETWORK = ABC
OR
TIME STARTED greater than 8:00

Then Sort MINUTES LONG descending

Look for answer in GENRE field

                                    6
7.Your Social Studies teacher assigned you to
do a report on a program that meets the
following criteria:
                   =
a. Shown on ABC NETWORK

b. TIME STARTED > 7:00
                   after
                    = FIRST TELECAST
c. October 1957 program

Of the programs, which has the least YEARS

ON TV?
              Zorro
Filter

NETWORK = ABC
TIME STARTED greater than 7:00
FIRST TELECAST = October 1957

Then Sorted YEARS ON TV ascending

Look for answer PROGRAM field

                                    7
Next set of questions are just for
   looking at on the screen.
                        Descending

1. What park has the most rides

(AMUSEMENT RIDES) for the public?
2. Who owns the park with ticket
                 
(COST ADULTS) more than $25 and
                  
opened (YEAR ESTAB) in 1978?
                            Descending
3. What is the name of the oldest theme
park established (YEAR ESTAB) in
        
Alabama (LOCATION) and has more
than 60 rides (AMUSEMENT RIDES)?
                  
Method      Which field
Sort the amusement rides field in
  How
descending order.
              Source
Look in the name field for the

answer___________.
           Answer
         Method
Create a filter.

Cost Adults = $25 Filter Information

AND Connector

Year Estab = 1978 Filter Information
            Source
Look in Owner field for the

answer__________.
          Answer
        Method
Create a filter
Location = Alabama Filter Information
AND Connector
Amusement Rides > 60 Filter Information
     Method
Then sorted the filter results.
     Which field     How
Sort Year Estab ascending
           Source
Look in Name field for the
answer__________. Answer
        Method
Create a filter
Year Estab > 1970 Filter Information
OR Connector
Amusement Rides > 70 Filter Information
                  Source
Look in the Favorite Ride field for the
answer_________________.
                  Answer
Questions can be all mixed up!
Simple sort
Simple filter 1 criterion
Simple filter 2 criteria
1 criterion filter and then a sort
2 criteria filter and then a sort
3 criteria filter
2 criteria filter followed by
       1criterion filter of the first filter
             Database Short
You must allow for enough time to finish the last
part of the database section of the computer test.
As the test begins…. Find the questions for
database short. Look at the time written on the
board. Know you must start the database short
section at least 5 minutes before time will be called.
Always double check each question for accuracy
before moving to the next question so you will not
have to go back if time runs short. This is a timed
test, pace yourself.
A very small database with
less than 5 fields and less
than 10 records.
           EASY Section
Make sure you
  do this part of
  the test.
It is easy and
  you should get
  all the points
  for this section.
You will open a small database with a few fields
and records. 4 steps involved.

A new field will need to be created.
     Record (on menu bar)
         Insert Field ► 1 Before….

                        2 After…..

   1
                            It makes no
                            difference
                            which you
                            choose.
2
                                        Spell and
    New Information Here
                                        capitalize
                                        correctly,
                                        then Add!


       3




                           Another Insert Field window
                           appears. ONLY select Done.
4




    Add new record data
    into the field. Avoid
    spelling and
    capitalization errors!
                      Double clicking on
Adjust field width    the field name with
so field names and    the left mouse button
                      will adjust the field
data in the records   width to display all
are completely        data within the field.
displayed.
         Printing Instructions
You will be given directions to print
It is a good idea to look at the print window
   and be familiar with printing commands
  – landscape
  – gridlines
  – print record and field labels
                   File
                    Page Setup……




DO NOT CHANGE THE
MARGINS SETTINGS.

Source, Size & Orientation – should be
Landscape




                                         Other Options
                         Check
                         both
                         boxes.




USE THE MENU COMMANDS TO ACTUALLY PRINT.
File
   Print
Opening up the Database
         Short
  Your name never
goes on the test, you
   will be given a
number on your test
   booklet to use.
 Close the database file you have been using to
     answer the first questions and open the
     database file called DBSHORT.
     Follow the instructions below:
 1. Add a new field named BROADCAST DAY


Record (on menu bar)
       Insert Field ►       After


                        Avoid spelling and
                        capitalization errors!
In the new field BROADCAST DAY, enter
  the following day for each program:
    • Wednesday (for Bat Masterson)

    • Sunday (for the Ed Sullivan Show)

    • Thursday (for Leave It To Beaver)

    • Monday (for This Is Music)

 Type the correct information in the
 field, the data in parenthesis just tells
 which record will contain the new data.
• Print your final DBSHORT file.
        Good Luck
come see me for any help you
       need. Ms. C

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:9/11/2012
language:Unknown
pages:65