SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

BUSINESS COMPUTER TECHNOLOGY

zenda avatar
zenda
19 diapositives · 329 Views · Jul 11, 2014

A database is an organized collection of related information, essential for managing data effectively. Unlike traditional printed databases like telephone directories and encyclopedias, computerized databases offer advantages such as quick searches, data sorting, and report generation. Users from various sectors including retail, healthcare, and law enforcement utilize databases for tracking inventory, patient information, and criminal records. This guide explores database components, including fields and records, and outlines the process of creating, manipulating, and printing databases for various applications.

BUSINESS COMPUTER TECHNOLOGY - slide 1
01 / 19BUSINESS COMPUTER TECHNOLOGY
1 / 17

Télécharger la présentation

BUSINESS COMPUTER TECHNOLOGY
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. BUSINESS COMPUTER TECHNOLOGY 006 Utilize Database Software

  2. WHAT IS A DATABASE? A database is an organized collection of related information.

  3. Familiar Printed Databases • Telephone Directories • Address Books • Encyclopedias & Dictionaries

  4. Familiar Computerized Databases • SIMS (Student Information Management System) • Automated Card Catalog • CD-Rom Encyclopedias

  5. 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

  6. WHO USES COMPUTERIZED DATABASES? • Stores use them to keep track of inventory • Travel Agents can keep up with their customers and reservations • Hospitals track • patient information

  7. Uses… • Police use them to keep track and criminals and previous arrests • You use databases everyday, Contacts in your phone and facebook!

  8. PARTS OF A DATABASE Fields Record Entry

  9. Database Views • Design View – place to create field names and data types for a database. • Datasheet/List View – displays the table data in a row-and-column format. • Used to enter data. • Displays several records at one time. • Form view – used to display/design one record at a time and/or to enter information. • Can include pictures, borders, or special formatting.

  10. PARTS OF A DATABASE • Data Type (Format) – the different types of data entered in a database; for example: number, text, date/time, etc. • Date and Time – used for storing dates and times in a specific format to allow you to do such things as aging an account or time an event. • Logical – can be one of two entries, basically YES or NO (ON or OFF -TRUE or FALSE). • Memo – used for information that does not fit easily into a category such as notes or comments.

  11. Parts of a Database - cont’d • Numeric – used to store purely numeric information. • Object – used for other media types that might include a picture of an employee or product, a sound file, a clip-art image, or any other type of non-text entry. • Text – used to store alphanumeric information. May also be called a character field. • Field – a category of information.

  12. Parts of a Database - cont’d • Field Name – A label at the top of a database column that describes the kind of information to be stored in the column. • Entry – the information that is entered in the fields in a database. • Record – a complete set of field entries. • Record number – the number that identifies the sequence of a record in a database. • File – a group of records. Also known as a table in some database programs.

  13. DATABASE FUNCTIONS • Database Report – allows one to organize, summarize, and print selected portions of a database. • Sorting – arranging information in alphabetical or numerical order. • Ascending – sorting from smallest to largest. Example: A – Z or 0 – 9. • Descending – sorting from largest to smallest. Example: Z – A or 9 – 0. • Filter/Query/Search – a feature that displays records that meet one or more specific criteria. • Connectors – words like OR and AND used in searching databases which indicate whether records must satisfy one rule (OR) or if both rules must be satisfied (AND).

  14. MATHEMATICAL OPERATORS < Less than <= Less than or equal to = Equal to < > Not equal to > Greater than >= Greater than or equal to

  15. Creating a Database • Create field names and data types • Enter data • Adjust field widths as needed • Add and delete fields as needed • Save the database

  16. Manipulating a Database • Retrieve a database file • Sort the database file • Use questions that involve ascending and descending order • Filter/Query/Search the database file • Use questions that involve one, two, and three criterion • Use questions that change the connector term from and to or

  17. Manipulating continued • Create a Report • Name Report • Choose Layout and Format • Choose Fields to Include • Determine a Sort Order • Create a Filter

  18. 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