Microsoft Access 2002

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

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

30. Saving and Closing a Table

31. Saving and Closing a Table

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

33. Records to Add

41. Closing a Table and Database

42. Opening a Database

43. Opening a Database

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

48. Previewing and Printing the Contents of a Table

49. Previewing and Printing the Contents of a Table

50. Previewing and Printing the Contents of a Table