Access Chapter 01

Access Chapter 01 - MS Access Chapter 1 Carlotta Eaton...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 8

Access Chapter 01 - MS Access Chapter 1 Carlotta Eaton...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online