exploring microsoft access chapter 1 introduction to microsoft access: what is a database?
TRANSCRIPT
![Page 1: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/1.jpg)
Exploring Microsoft Access
Chapter 1Introduction to
Microsoft Access: What Is A Database?
![Page 2: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/2.jpg)
Objectives (1 of 2)
• Define field, record, table, and database
• Start Access; describe windows and objects
• Add, edit, and delete records
• Explain importance of data validation
![Page 3: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/3.jpg)
Objectives (2 of 2)
• Apply filter; sort on one or more fields
• Explain how PivotTable and PivotChart views display data
• Describe relational database; identify one-to-many relationships
![Page 4: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/4.jpg)
Overview
• Every organization uses data
• Intro to database management
• Operations to maintain a database
• Introduction to Access
• Advantages of multiple tables
![Page 5: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/5.jpg)
Introduction to a Database
• Defining a database
• Database window in Access
• The six items in window: Tables, Queries, Forms, Reports, Macros, Modules
![Page 6: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/6.jpg)
Database Window
Database Window
Object Buttons
Menu Bar
Toolbar
![Page 7: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/7.jpg)
Table Views
• Datasheet view is used to add, edit, or delete records
• Design view is used to create and modify fields
• PivotTable view summarizes groups of data
• PivotChart view charts the data from PivotTable view
![Page 8: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/8.jpg)
Datasheet View
Current Record
Total Number of Records
Triangle indicatesData has been saved to disk
![Page 9: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/9.jpg)
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
![Page 10: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/10.jpg)
Design ViewPrimary Key
Field Names
Field Properties
Data Type
Description
![Page 11: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/11.jpg)
Tables
• Insertion point: where text is entered
• Primary key: unique identifier for each record
• Access automatically saves changes when you move to next record
![Page 12: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/12.jpg)
Forms, Queries, and Reports
• A form is a friendly interface for entering or modifying a table
• A query provides a subset of a table based on a criteria
• A report presents data in an attractive format
![Page 13: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/13.jpg)
Database Form
Table Name
Go To Next Record Go To Last Record
Go To First Record
Field Names
![Page 14: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/14.jpg)
Report
Report Header
Page Header
Close Print Preview
Detail Section
Zoom
![Page 15: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/15.jpg)
Filters and Sorting
• Filter by Selection is easiest
• Filter by Form allows for comparative criterion (e.g. >, <)and allows for or filters (e.g. either cosmetics or shoes)
• Remove Filter button redisplays complete table
![Page 16: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/16.jpg)
Filter By Selection
Only 5 of the 9 Total Records Are Displayed In This Filter
These Records Were Filtered By Selection (Region = WA)
![Page 17: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/17.jpg)
Sorting
The Previous Filtered Records Sorted by City
The Same Records, Only Displayed in a Different Order
![Page 18: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/18.jpg)
PivotTable View
Average Salary of Detroit Engineers
![Page 19: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/19.jpg)
PivotChart View
The Previous PivotTable Displayed as a PivotChart
![Page 20: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/20.jpg)
Relational Database
• Uses multiple tables
• Example of one-to-many table: one publisher owns many books
![Page 21: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/21.jpg)
Relationships WindowTable Names
One To Many Relationship
Field Names
![Page 22: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/22.jpg)
Modifying Related Information
Clicking plus sign displays all employees at L04
Modifying the address information for Location L04 changes the information for all individual employees at L04
![Page 23: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/23.jpg)
Displaying Related InformationRelated information is easily grouped together when creating reports
![Page 24: Exploring Microsoft Access Chapter 1 Introduction to Microsoft Access: What Is A Database?](https://reader035.vdocuments.us/reader035/viewer/2022062517/56649f1c5503460f94c32b20/html5/thumbnails/24.jpg)
Chapter 1 Summary
• Six object types: Tables, Forms, Queries, Reports, Macros, & Modules
• Tables views: Design, Datasheet, PivotTable, or PivotChart
• Data validation is critical
• A filters applies a criteria to display a subset of records
• Databases are related tables