Microsoft Access 2010

1. MicrosoftAccess 2010 Chapter 5 Multitable Forms

2. Objectives • Add Yes/No, Date/Time, Memo, OLE Object, and Attachment fields • Use the Input Mask Wizard • Update fields and enter data • Change row and column size • Create a form with a subform in Design view • Modify a subform and form design Multitable Forms

3. Objectives • Enhance the form title • Change tab stops and tab order • Use the form to view data and attachments • View object dependencies • Use Date/Time, Memo, and Yes/No fields in a query • Create a form with a datasheet Multitable Forms

4. Project – Multitable Forms Multitable Forms

5. Plan Ahead – pg. 276 • When new fields are needed, determine the purpose of those fields to see if they need special data types • When a form is required, determine whether the form requires data from more than one table • If the form requires data from more than one table, determine the relationship between the tables • If the form requires data from more than one table, determine on which of the tables the form is to be based • Determine the fields from each table that need to be on the form Multitable Forms

6. Housekeeping • Make a Chapter 5 folder • Go to Public\DB Design\Chapter 5 folder and copy Camashly design from there (we are all starting at the CORRECT place) • NOTE: this copies the folder for your labs as well. So go ahead and get ALL of it! • Open the Camashly Design database Multitable Forms

7. Planning for new fields • Do they need an input mask (Like SSN or phone #)? • Can they use a Yes/No data type? • Do you need a date/time field? • Do you need a Memo field? • Do you need an OLE (Object Linking and Embedding) object? • Are there attachments? • Are there hyperlinks? Multitable Forms

8. Adding Fields with New Data Types to a Table Do pages 279-287. You will add the fields shown below! Multitable Forms

9. Entering Data in OLE Object Fields • You must use the Insert Object command on the OLE field’s shortcut menu. • Now we will insert pictures Multitable Forms

10. Entering Data in OLE Object Fields Do pages 288-289 to insert pictures for everyone Multitable Forms

11. Entering Data in Attachment Fields • Use the Manage Attachments command on the Attachment field’s shortcut menu to do this. Multitable Forms

12. Entering Data in Attachment Fields Do pages 290-291 Multitable Forms

13. Creating a Form in Design View • Plan ahead • Which tables do you need? Which table is the MAIN table for the form? • Which fields from each table need to be on the form? Multitable Forms

14. Creating a Form in Design View Do pages 293-317. Multitable Forms

15. Viewing Object Dependencies • Open the Navigation Pane and click the desired table • Click the Object Dependencies button (Database Tools tab | Relationships group) to display the Object Dependencies pane • If necessary, click the ‘Objects that depend on me’ option button to select it • Close the Object Dependencies pane by clicking the Object Dependencies button (Database Tools tab | Relationships group) a second time Multitable Forms

16. Viewing Object Dependencies Multitable Forms

17. Using the Date/Time, Memo, and Yes/No Fields in a Query Do pages 320-322 Multitable Forms

18. Homework • Do Flash Cards for Ch. 5 due next class meeting. • Labs • Philimar on pg. 333 • Make sure to do all 3 parts. • Everyone is starting with a CORRECT Philamar training db, so we are all on the same page! Multitable Forms