1 / 18

Committed to Shaping the Next Generation of IT Experts.

Exploring Microsoft Access 2003. Chapter 2- Tables and Forms: Properties, Views, and Wizards Robert Grauer and Maryann Barber. Committed to Shaping the Next Generation of IT Experts. Table Design Basics. Include necessary data Store data in its smallest parts E.g., first name, last name

gloriahunt
Download Presentation

Committed to Shaping the Next Generation of IT Experts.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exploring Microsoft Access 2003 Chapter 2- Tables and Forms: Properties, Views, and Wizards Robert Grauer and Maryann Barber Committed to Shaping the Next Generation of IT Experts. Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  2. Table Design Basics • Include necessary data • Store data in its smallest parts • E.g., first name, last name • Avoid calculated fields • E.g., birth date rather than age • E.g., employee’s date of hire rather than employee’s length of service Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  3. Creating a Table • Two ways to create a table: • Table Wizard is easiest • 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 Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  4. New Table Screen Click on New Button Select view for new table Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  5. Field Names Table Design View Primary Key Data Type Field Properties Field Descriptions Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  6. Table Wizard Screen Click Create table using wizard Select Fields Click to add selected field Select from Sample Tables Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  7. Table Wizard Screen (continued) Enter name for table Let Table Wizard set the primary key Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  8. Create an Input Mask Select Social Security Number Use Try It box Select Input Mask Click Build button Select Yes for Required property Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  9. Forms • Form view • Displays completed form • Used to enter or modify data in underlying table • Design view • Used to create or modify the form Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  10. What They Look Like Form View Design View Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  11. Creating a Form Controls • Bound control — has data source • Unbound control — no data source • Calculated control — expression as data source Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  12. Form Design View Unbound control Sizing handles Bound Control Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  13. Form View Unbound control Bound Control Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  14. Form Wizard Click New button Click Form Wizard Select Table Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  15. Form Wizard (continued) Click >> to select all fields for form Click Next > Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  16. Sophisticated Forms • Additional controls to use on forms • Drop-down list box (using Lookup Wizard) • Check box • Option group • Command buttons Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  17. Lookup Wizard Enter the Majors Select to type the values Select Lookup Wizard Exploring Office 2003 Vol 1 2/e- Grauer and Barber

  18. Add New Controls View->Field List Click and drag field from field list to form design grid Major is then added as a combo box Exploring Office 2003 Vol 1 2/e- Grauer and Barber

More Related