This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: MS Access Chapter 1 Carlotta Eaton Committed to Shaping the Next Generation of IT Experts. Chapter 1 Introduction to Access: What is a Database? Exploring Office 2003 - Grauer and Barber 2 Objectives z Define field, record, table, and database z Describe the objects in Access database z Add, edit, and delete records in a table z Use existing forms and reports z Explain importance of data validation z Apply filter by form or selection z Sort a table on one or more field z Identify one-to-many relationships Exploring Office 2003 - Grauer and Barber 3 Case Study: Natalie’s Cuppa Joe z The case requires students to: z Use a form to enter data about themselves z Print the completed form z Print two reports Exploring Office 2003 - Grauer and Barber 4 Database Window Menu bar Toolbar Database window Object Buttons MS Access Chapter 1 Carlotta Eaton Exploring Office 2003 - Grauer and Barber 5 Introduction to a Database z Field – a basic data element z Examples: name, phone number, title z Record – a set of fields z Examples: All fields for one person z Table – a set of records z Database – one or more tables Exploring Office 2003 - Grauer and Barber 6 Fields and Records Field – A basic fact listed above each column Record is an entire row of information Field = columns Record = rows Exploring Office 2003 - Grauer and Barber 7 Table Views z Datasheet view is used to add, edit, or delete records z Design view is used to create and modify fields z PivotTable view summarizes groups of data z PivotChart view charts the data from PivotTable view Exploring Office 2003 - Grauer and Barber 8 Datasheet View Triangle indicates data has been saved to disk Current record Total number of records MS Access Chapter 1...
View Full Document
This note was uploaded on 04/15/2011 for the course BCIS 3610 taught by Professor Koh during the Spring '08 term at North Texas.
- Spring '08