Databases Scales by 4lc4z0

VIEWS: 5 PAGES: 25

									Databases

Ms. Scales
      What is a Database?
 Database
 A collection of data organized for
  fast search and retrieval
 Examples:
    Telephone  Directories
    Hospital Records

    Catalog Mailing Lists

    Online Encyclopedias

    Google
    Who Uses Computer Databases?

•   Stores use them to        • Customers
    keep track of inventory   online when
                              shopping
    • Travel Agents
    can keep up with
    their customers           • Students online
    and reservations          when Researching
                              information for
    •Hospitals track          school
     patient information
Advantages of Computerized
Databases
   Can find a specific file quickly
   Can alphabetize and sort data faster than
    people
   Is as accurate as the data that is entered
   Can make many different types of reports
             Databases
 Database   application
 A program used to create
  databases and programs to track
  and manage information
 Ex. Microsoft Access
 Database   Objects
 The  parts of a database, such as
  tables, forms, reports and queries
                 Databases
   Table
    a collection of data about specific subjects
     arranged in rows and columns
   Query
    aset of instructions that retrieves data from
     one or more tables
                 Databases
   Form
     anonscreen display where data can be added
     or changed
   Report
    a presentation of data formatted and
     organized for printing
        Parts of a Database
File
    A collection of records
Record
 Isa database file, containing
  multiple fields.
Parts of a Database
   Field
    A   category of information, the label at the top
      of the column that describes the kind of
      information to be stored in the column
   Entry
     theinformation that is entered in the fields in a
      database
   Layout
     refersto the specific order and manner in
      which information is presented
           Parts of a Database

COMPUTER PROCESSOR          MGHZ   RAM
 BRAND
  Dell        Pentium III    2     256

 Gateway      Pentium II    550    128

  IBM            486         66    16

 Compaq       Pentium I      75    24
         Parts of a Database
 Record   Number
 the number that identifies the
   sequence of a record in a database
 Data   Type
  defines the type of information
   which may be stored in a field.
             Data Types
 Date   and Time
  used  for storing dates and times in a
   specific format to allow you to know the
   age of an account or the time of an
   event
 Logical
  canbe one of two entries, Ex. YES or
   NO, TRUE or FALSE, ON or OFF
             Data Types
 Memo
 used    for information that does not
   fit easily into a category, such as
   notes or comments
 Numeric
 stores   only numeric information
             Data Types
 Text
  stores alphanumeric information,
   also called a character field
 Object
  stores media information such as a
   picture, clip art, a sound file, or any
   other non-text information
 Database
 Files
    Records
     Fields        Data Types
           Entry        Logical
                         Memo
                         Date and Time
                         Numeric
                         Text
                         Object
          Using a Database
 Data   Entry
 the  process of manually inputting
   data into a database program.
 Can create field names and data
  types
 Add and delete fields as needed
 Organize information as desired
           Searching a Database
   Search
     toask the database to look at all records
      which contain certain information or meet
      certain criteria.
   Retrieve
     to   find one or more specific records
   Sort
     organizesthe information in either ascending
      or descending order
      Mathematical Operators
> Greater than
< Less than
= Equal to
>= Greater than or equal to
<= Less than or equal to
<> Not equal to
               How to Search
   Boolean
    Aparticular way of searching a database.
     Boolean uses the words AND, OR, NOT. Ex.
     Cat AND Maine Coon
   Keywords
     theterms you are searching for when you use
     a database
               How to Search
   Criteria
     Conditions   that are set in a Query
   Filter
     To separate out and show records that have a
      specific value
       Creating a Database
 Create Field Names and Data Types
 Enter Data
 Adjust Fields widths as needed
 Add or Delete Fields as needed
 Save the Database
      Manipulating a Database
 Retrieve a Database File
 Sort the Database File
 Filter/Query/Search the Database
     Use  questions that involve one to three
      criteria
     Use questions that change the connecter from
      AND to NOT to OR
    Manipulating a Database
 Create a Report
 Name a Report
 Choose a Layout
 Choose Fields to Include
 Determine Sort Order
 Create a Filter
              Database Views
   Datasheet/List View – displays the table data in
    a row-and-column format.
     Used  to enter data.
     Displays several records at one time.
   Design View – place to create field names and
    data types for a database.
   Form view – used to display/design one record
    at a time and/or to enter information.
     Can include pictures, borders, or special
      formatting.
           Printing a Database
 Print   the Database
  Choose   page orientation
  Choose whether you desire to print
   gridlines, record, and field labels
  Preview and adjust as needed
  Print the database

								
To top