1 / 24

Exploring Microsoft Access 2003

Exploring Microsoft Access 2003. Chapter 1 Introduction to Microsoft Access: What Is A Database?. Objectives (1 of 2). Define field, record, table and database Start Access, describe windows and objects Add, edit, and delete records Describe record selector. Objectives (2 of 2).

doctor
Download Presentation

Exploring Microsoft Access 2003

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. Exploring MicrosoftAccess 2003 Chapter 1 Introduction to Microsoft Access: What Is A Database?

  2. Objectives (1 of 2) • Define field, record, table and database • Start Access, describe windows and objects • Add, edit, and delete records • Describe record selector

  3. Objectives (2 of 2) • Explain importance of data validation • Apply filter and sort on one or more fields • Describe relational database; identify one-to-many relationships

  4. Overview • Every organization uses data • Intro to database management • Introduction to Access • Operations to maintain a database • Database power with multipletables

  5. Introduction to a Database • Defining a database • Database window in Access • The seven items in window: Tables, Queries, Forms, Reports, Pages, Macros, Modules

  6. Database Window Menu Bar Toolbar Database window Object button

  7. Tables • Design view used to create fields • Datasheet view used to add, edit,or delete records • Each column represents a field • Records are recorded in rows

  8. Design View Primary key Field names Data type description Field property

  9. Tables • Record selector symbol next tocurrent record shows status • Triangle indicates saved to disk • Pencil indicates you are typing • Asterisk appears next to last blankrecord in table

  10. Tables • Insertion point: where text isentered • Primary key: unique identifier foreach record • Access automatically saveschanges when you move to next record

  11. Datasheet View Triangle indicatesData has beensaved to disk Current Record Total Number of Records

  12. Introduction to Access Hands-On Exercise 1 • Welcome to Windows • Obtain the Practice Files • Start Microsoft Access • Open the Books Table

  13. Introduction to Access Hands-On Exercise 1 Continued • Moving Within a Table • Add a Record • Add a Second Record • Print the Table • Exit Access

  14. Maintaininga Database • Delete record • Add record • Undo command • Office assistant • Replace command • Find command • GIGO (Garbage In, Garbage Out) • Data Validation

  15. Maintaining a Database Hands-On Exercise 2 • Open the Bookstore Database • The Find Command • The Undo Command • The Delete Command • Data Validation

  16. Maintaining a Database Hands-On Exercise 2 continued • Open the Books Form • The Replace Command • Run a Query • Print a Report • Office Assistant

  17. Relational Database • A relational database uses multiple tables • Example of one-to-many table: • One publisher owns many books

  18. Database Form Command Buttons Go To First Record Go To Next Record

  19. Report

  20. Filter By Selection These Records Were Sorted in Descending Order by Salary Only part of the records are displayed

  21. Relationships Window Field Names One To Many Relationship Table names

  22. Chapter 1 Summary • Databases are multiple, related tables • Six object types: Tables, Forms,Queries, Reports, Macros, and Modules • Tables: Design view or Datasheet view • Record Selector Symbol for recordstatus • Data validation is critical

  23. Practice with Access 1. Employee database 2. Bookstore database 3. United States database 4. Super Bowl database 5. Look Ahead database 6. Companion Website

  24. Case Studies • Planning for Disaster • The Common User Interface • Garbage In, Garbage Out • Changing Menus and Toolbars

More Related