1 / 34

Databases & Access 2000

Databases & Access 2000. Today’s Topic: Databases. Define: Database Software Examine the different uses of database software Define the four components of database software: Tables Queries Forms Reports. Database Software.

phillipa-mark
Download Presentation

Databases & Access 2000

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Databases & Access 2000

  2. Today’s Topic: Databases • Define: Database Software • Examine the different uses of database software • Define the four components of database software: • Tables • Queries • Forms • Reports

  3. Database Software Software designed to store, sort, sift through, manipulate, and display large amounts of data.

  4. Database Software • A Database table looks very similar to a spreadsheet, it has rows and columns, and data is entered into cells, but databases have a different purpose.

  5. Postal Code Country Phone EC1 4SD UK (171) 555-2222 70117 USA (100) 555-4822 48104 USA (313) 555-5735 100 Japan (03) 3555-5011 33007 Spain (98) 598 76 54 545 Japan (06) 431-7877 3058 Australia (03) 444-2343 M14 GSD UK (161) 555-4448 S-345 67 Sweden 031-987 65 43 Spreadsheet software is used to store and run calculations on numeric data Database software is used for storing and manipulating large amounts of data of any kind Jane Strickland's Income Jan Wages $ 699.00 Loans $ 260.00 Misc. $ - Monthly Totals $ 959.00 Yearly Total $11,678.00 Database Software

  6. Spreadsheet Spreadsheet Spreadsheet Spreadsheet Database Database Database Database Student Transcripts & GPA’s FSU’s Schedule of Classes Financial Aid Reports Amazon.com’s product catalogue Consider This…. • What software would logically be used to store the following data:     

  7. The registrar might use a spreadsheet to calculate a student’s GPA Then transfer the results to the student’s database record. Solution Not Always Apparent • Often times users will transfer data between a spreadsheet and database to accommodate different needs.

  8. Database Components Tables: Store the data. For example, the Customers table will store customer-related data for all customers MS Access Object Bar

  9. Database Components Queries: Allow you to sift through the data stored in Tables to find useful information. For example, you might query your Customer Table to find your 10 best customers. MS Access Object Bar

  10. Database Components Forms: allow users to easily and securely enter new records into a Table. MS Access Object Bar

  11. Database Components Reports: provide tools to create attractive output from Tables and Queries. MS Access Object Bar

  12. Database Components: Tables

  13. File or Table Fields(Attributes) Records (Entities) Database Components: Tables • A collection of data organized to meet user’s needs.

  14. Database Tables are created and Fields defined using Design View. • Database Tables are viewed and used using Datasheet View. Database Components: Tables

  15. Database Components: Tables Creating a Table 2. Set each field’s data type by selecting it from the list. 1. Type field names in this column. 3. Set one or more fields to act as the primary key……

  16. Database Components: Tables Primary Keys • The Primary Key field must contain unique data for each record. Data used to identify that record. • Example: SSN’s are used as primary keys in IRS records

  17. Consider This…. • What data field could be used as primary key for the following database tables? Table Primary Key A credit card company’s customer records. Account number FSU student records Social Security Number or FSUCard Number A personal address book Combined first name and last name

  18. Relationships • Databases typically consist of several related tables. Fields are selected to define how the tables are related.

  19. Relationships • In this example the CardNumber field is used to relate these tables so that the identity of the customer can be established.

  20. Relationships • This is called a one to many relationship since the primary key guarantees that their will be only one customer with any specified cardnumber.

  21. Relationships • …and each customer can make many –even and infinite amount of, purchases.

  22. Database Components: Queries

  23. Database Components: Queries Select the table(s) you wish to query Creating a Query using Design View

  24. Database Components: Queries Creating a Query using Design View Select the fields that you wish to include in the query along with the table to which they belong

  25. Database Components: Queries Creating a Query using Design View Specify the Criteria used to filter the data. In this query, only records with the Course Number CGS2060 will be displayed.

  26. Database Components: Queries Creating a Query using Design View Define which field(s) will be used to sort the data

  27. Database Components: Queries Creating a Query using Design View Check the fields that you would like to display in the query

  28. Database Components: Queries Viewing the results of a query with Datasheet View Only records for CGS2060 are displayed.

  29. Database Components: Forms

  30. Database Components: Forms Forms provide an attractive and secure interface for entering data into a table.

  31. Database Components: Reports

  32. Database Components: Reports Create a report to present data from a table or query in an attractive and meaningful manner.

  33. Summary • Tables store the data. • Queries sort and filter data in one or more tables • Forms are used to input data into a table. • Reports are used to output the data. • Tables and Queries are best created using Design View • Forms and Reports are easiest created using Wizards

  34. Time to Practice

More Related