1 / 24

Access 2000 – Level 1

Access 2000 – Level 1. Michael Young SoftTechTraining.com 416 425-8997. Lesson 1: Introduction to Databases. What is a Database? What is Microsoft Access? Database Terminology Database Planning and Design Relational Databases. What is a Database?. A collection of related information

thom
Download Presentation

Access 2000 – Level 1

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. Access 2000 – Level 1 Michael Young SoftTechTraining.com 416 425-8997 Instructor: Michael Young

  2. Lesson 1: Introduction to Databases • What is a Database? • What is Microsoft Access? • Database Terminology • Database Planning and Design • Relational Databases Instructor: Michael Young

  3. What is a Database? • A collection of related information • organized for analytical and reporting purposes. • Examples: • telephone book, personnel directories, inventory control sheets, and customer account listings Instructor: Michael Young

  4. What is Microsoft Access? • Microsoft Access is a Database Management program. • Where the information is stored in data tables • Has a variety of components (Objects) to help you enter, store, view, report & print the data in a variety of ways. • Every table has a structure that provides for the collection, organization, storage, and retrieval of data. • These tables are contained in a database file. • Each database file can have numerous data tables. Instructor: Michael Young

  5. Database Terminology (cont.) • Basic Terminology • Field • Record • Table • Form • Query • Report • Object Instructor: Michael Young

  6. Database Terminology (cont.) • Field – A unique Category of information. Examples: Name, Address, and Phone Number. Instructor: Michael Young

  7. Database Terminology (cont.) • Record – All of the fields pertaining to one entry in the table. Example: an employee record. Instructor: Michael Young

  8. Database Terminology (cont.) • Table – A collection of fields and records, organized logically into rows and columns. Instructor: Michael Young

  9. Database Terminology (cont.) • Form – A vehicle for entering and displaying the data in a table. Instructor: Michael Young

  10. Database Terminology (cont.) • Query – A means of extracting specific data from a table. Example: “Show me all records from the employee table where the employee’s name is Sam Jones.” Instructor: Michael Young

  11. Database Terminology (cont.) • Report – A formatted printout of the data from a table or query. Instructor: Michael Young

  12. Database Terminology (cont.) • Object – • A generic term that refers to the components of an Access database. Instructor: Michael Young

  13. Database Terminology (cont.) • Objects in an Access 2000 Database Instructor: Michael Young

  14. Database Planning and Design • Planning • Gather existing reports. • Interview database users. • Sketch out new reports and share with users. • Work closely with users when developing and testing. Instructor: Michael Young

  15. Database Planning and Design • Design • Is the database to be • A Single Table (Non-Relational) or • A Multi-Table (Relational) database system Instructor: Michael Young

  16. Database Planning and Design • Non-Relational database • is a database that usually only has one table • where the information table(s) is not used or combined with any other table within the database. • A simple address and phone list is an example. Instructor: Michael Young

  17. Database Planning and Design • Relational database – What - • is a database with more than one table • where there may be some relationship between the tables,  • Keyed off one or more fields, (for example Name or Social Security Number).  • Why & Examples on following screens Instructor: Michael Young

  18. Design: Relational Databases • - Why - • Prevents duplicate data entry and data redundancy. • Minimizes use of disk space. • Allows quicker updates. Instructor: Michael Young

  19. Design:Relational Databases Examples • ABC trading company sells various items through a mail order catalog. Sean Jones recently ordered some items from ABC, which were stored in our non-relational order-entry database. Instructor: Michael Young

  20. Design:Relational Databases Examples(cont.) • Oops! We misspelled Shawn’s name. We will have to go back and change it in all of his order records. Instructor: Michael Young

  21. Design:Relational Databases Examples(cont.) • Shawn ordered another item. But he has a new address and phone number! We now must go back and change his address and phone number in all of the old order records. Instructor: Michael Young

  22. Design:Relational Databases Examples(cont.) • PCOE trading company uses a relational database to store order information. Customer information and order information are store in two different tables. Instructor: Michael Young

  23. Design:Relational Databases Examples(cont.) • When customer information changes, PCOE only needs to change it in one place. • PCOE doesn’t need to re-enter Shawn’s address for every order. Instructor: Michael Young

  24. Lesson 1: Introduction to Databases: Review • What is a Database? • What is Microsoft Access? • Database Terminology • Database Planning and Design • Relational Databases Instructor: Michael Young

More Related