Microsoft Access 2010 - PowerPoint PPT Presentation

jaclyn
microsoft access 2010 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Access 2010 PowerPoint Presentation
Download Presentation
Microsoft Access 2010

play fullscreen
1 / 18
Download Presentation
Microsoft Access 2010
165 Views
Download Presentation

Microsoft Access 2010

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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