Session 1

• Use multiple workbooks
• Link worksheets with 3-D formulas
• Link workbooks
• Manage workbooks
• Use special number formats
• Use functions to format text
• Work with styles
• Work with themes

Session 2

• Create query joins to retrieve data
• Join two unrelated tables and relate data within a table
• Set Select query properties
• Create queries that accept criteria from the user
• Create action queries to modify records in a table

Session 3

• Design form layout, and add text and graphics to the form
• Restrict data entry in forms by adding controls
• Add a command button to a form
• Create a subform

Session 4

• Organize information in a report
• Format a report
• Control white space between records and manual page breaks
• Summarize report information
• Add a subreport to a report
• Create a mailing label report
• Import and export data
• Merge data from Access with an existing Word document