Access Chapter 02

Access Chapter 02 - MS Access Chapter 2 Chapter 2 Tables...

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

View Full Document Right Arrow Icon
MS Access Chapter 2 Carlotta Eaton Committed to Shaping the Next Generation of IT Experts. Chapter 2 Tables and Forms: Properties, Views, and Wizards Exploring Office 2003 - Grauer and Barber 2 Objectives z Describe table design z Describe data types and properties; set a primary key z Use Table Wizard; Modify a table design z Discuss data validation importance z Use Form Wizard; modify a form design z Distinguish between bound, unbound, and calculated controls z Add combo box and command buttons z Use a form to add, edit, and delete records Exploring Office 2003 - Grauer and Barber 3 Case Study: Kahakai Villas z The case requires students to: z Create a database; set field properties z Create a form to enter the data z Modify the form to include command buttons and clip art z Use the form to enter data Exploring Office 2003 - Grauer and Barber 4 Table Design Basics z Include necessary data z Store data in its smallest parts z Avoid calculated fields
Background image of page 1

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

View Full DocumentRight Arrow Icon
MS Access Chapter 2 Carlotta Eaton Exploring Office 2003 - Grauer and Barber 5 Creating a Table z Two ways to create a table: z Table Wizard is easiest z Design a table yourself z Every field has a field name z Every field has a data type z Primary key – Makes each record unique z Views: Datasheet or Design z Properties – characteristics of an object Exploring Office 2003 - Grauer and Barber 6 Data Types z Number field z Text field z Memo field z Date/Time field z Currency field
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the 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 02 - MS Access Chapter 2 Chapter 2 Tables...

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