acc_02 - Exploring Microsoft Access 2003 Chapter 2- Tables...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Exploring Microsoft Access 2003 Chapter 2- Tables and Forms: Properties, Views, and Wizards Robert Grauer and Maryann Barber Modified by A. Clark (USA) Committed to Shaping the Next Generation of IT Experts. 1 Exploring Office 2003 - Grauer and Barber Objectives Describe table design Describe data types and properties; set a primary key Use Table Wizard; Modify a table design Discuss data validation importance 2 Exploring Office 2003 - Grauer and Barber Objectives (continued) Use Form Wizard; modify a form design Distinguish between bound, unbound, and calculated controls Add combo box and command buttons Use a form to add, edit, and delete records 3 Exploring Office 2003 - Grauer and Barber Table Design Basics Include necessary data Store data in its smallest parts Avoid calculated fields 4 Exploring Office 2003 - Grauer and Barber Creating a Table Two ways to create a table: Table Wizard Design a table yourself Every field has a field name Every field has a data type Primary key Makes each record unique Views: Datasheet or Design Properties characteristics of an object 5 Exploring Office 2003 - Grauer and Barber Data Types Number field Text field Memo field Date/Time field Currency field Yes/No field OLE field AutoNumber Hyperlink field 6 Exploring Office 2003 - Grauer and Barber New Table Screen Click on New Button Select view for new table 7 Exploring Office 2003 - Grauer and Barber Table Design View Primary Key Field Names Data Type Field Properties Field Descriptions 8 Exploring Office 2003 - Grauer and Barber Table Wizard Screen Click Create table using wizard Select Fields Click to add selected field Select from Sample Tables 9 Exploring Office 2003 - Grauer and Barber Table Wizard Screen (continued) Enter name for table Let Table Wizard set the primary key 10 Exploring Office 2003 - Grauer and Barber Properties Field size Format Input Mask Caption Default Value Validation Rule Validation Text Required Allow Zero Length 11 Exploring Office 2003 - Grauer and Barber Create an Input Mask Select Social Security Number Use Try It box Select Input Mask Click Build button Select Yes for Required property 12 Exploring Office 2003 - Grauer and Barber Forms Form view Displays completed form Used to enter or modify data in underlying table Design view Used to create or modify the form Parts of the form 13 Exploring Office 2003 - Grauer and Barber What They Look Like 14 Exploring Office 2003 - Grauer and Barber Creating a Form Controls Bound control -- has data source Unbound control -- no data source Calculated control -- expression as data source 15 Exploring Office 2003 - Grauer and Barber Form Design View Unbound control Sizing handles Bound Control 16 Exploring Office 2003 - Grauer and Barber Form View Unbound control Bound Control 17 Exploring Office 2003 - Grauer and Barber Form Wizard Click New button Click Form Wizard Select Table 18 Exploring Office 2003 - Grauer and Barber Form Wizard (continued) Click >> to select all fields for form Click Next > 19 Exploring Office 2003 - Grauer and Barber Sophisticated Forms Additional controls to use on forms Drop-down list box (using Lookup Wizard) Check box Option group Command buttons 20 Exploring Office 2003 - Grauer and Barber Lookup Wizard Enter the Majors Select Lookup Wizard Select to type the values 21 Exploring Office 2003 - Grauer and Barber Add New Controls Click and drag field from field list to form design grid Major is then added as a combo box 22 Exploring Office 2003 - Grauer and Barber Option Group Wizard Drag the Option Group button onto the form to enable the Option Group Wizard Type the label names Accept the default values Store the values in a field 23 Exploring Office 2003 - Grauer and Barber Command Button Wizard Drag the Command Button tool onto the form to enable the Command Button Wizard Select Category and Action Select Text Display Add a name to the button Creates a command button 24 Exploring Office 2003 - Grauer and Barber Chapter 2 Summary Information depends on underlying data Divide data into smallest units Database design is critical Table Wizard: creates tables easily 25 Exploring Office 2003 - Grauer and Barber Chapter 2 Summary (continued) A form provides easy way to enter and display data A form consists of objects called controls A property is a characteristic or attribute of an object 26 Exploring Office 2003 - Grauer and Barber Questions? 27 Exploring Office 2003 - Grauer and Barber ...
View Full Document

Ask a homework question - tutors are online