Transcript ch1
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) • Explain importance of data validation • Apply filter and sort on one or more fields • Describe relational database; identify one-to-many relationships Overview Every organization uses data Intro to database management Introduction to Access Operations to maintain a database Database power with multiple tables Introduction to a Database • Defining a database • Database window in Access • The seven items in window: Tables, Queries, Forms, Reports, Pages, Macros, Modules Database Window Menu Bar Toolbar Database window Object button 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 Design View Primary key Field names Data type description Field property Tables • Record selector symbol next to current record shows status • Triangle indicates saved to disk • Pencil indicates you are typing • Asterisk appears next to last blank record in table Tables • Insertion point: where text is entered • Primary key: unique identifier for each record • Access automatically saves changes when you move to next record Datasheet View Triangle indicates Data has been saved to disk Current Record Total Number of Records Introduction to Access Hands-On Exercise 1 • • • • Welcome to Windows Obtain the Practice Files Start Microsoft Access Open the Books Table Introduction to Access Hands-On Exercise 1 Continued • • • • • Moving Within a Table Add a Record Add a Second Record Print the Table Exit Access Maintaining a Database • Replace command • Find command • GIGO (Garbage In, Garbage Out) • Data Validation • Delete record • Add record • Undo command • Office assistant Maintaining a Database Hands-On Exercise 2 • • • • • Open the Bookstore Database The Find Command The Undo Command The Delete Command Data Validation Maintaining a Database Hands-On Exercise 2 continued • • • • • Open the Books Form The Replace Command Run a Query Print a Report Office Assistant Relational Database • A relational database uses multiple tables • Example of one-to-many table: • One publisher owns many books Database Form Command Buttons Go To First Record Go To Next Record Report Filter By Selection These Records Were Sorted in Descending Order by Salary Only part of the records are displayed Relationships Window Field Names Table names One To Many Relationship 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 record status • Data validation is critical Practice with Access 1. Employee database 2. Bookstore database 3. United States database 4. Super Bowl database 5. Look Ahead database 6. Companion Website Case Studies • Planning for Disaster • The Common User Interface • Garbage In, Garbage Out • Changing Menus and Toolbars