1 / 98

Microsoft Access 2002

Microsoft Access 2002. Project 1. Objectives. Describe databases and database management systems Describe the speech recognition capabilities of Access Start Access Describe the features of the Access Desktop Create a Database Create a table and define the fields in a table.

estherhunt
Download Presentation

Microsoft Access 2002

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. Microsoft Access 2002 Project 1

  2. Objectives • Describe databases and database management systems • Describe the speech recognition capabilities of Access • Start Access • Describe the features of the Access Desktop • Create a Database • Create a table and define the fields in a table

  3. Objectives cont… • Open a table • Add records to a table • Close a table • Close a database and quit Access • Open a database • Print the contents of a table • Use a form to view data

  4. Objectives cont… • Create a custom report • Use the Access Help system to answer your questions • Design a database to eliminate redundancy

  5. What is Microsoft Access? • A powerful database management system • Key Features • Data entry and update • Queries (questions) • Forms • Reports • Web Support

  6. Project One – Alisa Vending Services • You will be creating a database for Alisa Vending Services • Database terms: • Database • Records • Fields • Primary key – unique identifier

  7. Database Example

  8. Starting Access • Go to Start Menu, Programs, Microsoft Access

  9. Starting Access • Now Access is open

  10. Speech Recognition

  11. Speech Recognition

  12. Creating a New Database

  13. Creating a New Database

  14. Creating a New Database

  15. Creating a New Database

  16. The Access Desktop and the Database Window

  17. Creating a Table • Define structure • Field name • Data type • Description

  18. Creating a Table

  19. Creating a Table

  20. Creating a Table

  21. Creating a Table

  22. Creating a Table • Defining the Fields

  23. Creating a Table • Correcting Errors in the Structure • Check entries for correctness • Use BACKSPACE key • Click entry and correct • Select field that will follow and press INSERT key • Select field to delete and press DELETE key • Reset Primary key if necessary using Primary Key button • If too many errors, close table, say no to saving changes and start again

  24. Saving and Closing a Table

  25. Saving and Closing a Table

  26. Adding Records to a Table • Create a table • Change to Datasheet view • Add records

  27. Records to Add

  28. Closing a Table and Database

  29. Opening a Database

  30. Opening a Database

  31. Adding Additional Records • Adding Additional Records • Correcting Errors in the Data • Go to Datasheet View and fix errors by retyping or deletion

  32. Previewing and Printing the Contents of a Table

  33. Previewing and Printing the Contents of a Table

  34. Previewing and Printing the Contents of a Table

More Related