Access 2013: Forms and Reports

Make the information in your Access database more transparent and easier to navigate with forms and reports. This course demonstrates how you can use forms and reports to control and organize the display of your data, as well as gather parameters for queries. Author Adam Wilbert starts with the basics of form design and leveraging controls such as buttons, links, and macros. He combines these ideas in a chapter that shows how to build an application-like framework for getting around the database.

Then the course dives into reports: creating efficient and readable layouts, grouping data into categories, tying reports to queries, and using conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports together and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.

Topics include:

• Creating forms with the Form Wizard
• Aligning form controls
• Adding buttons, links, and attachments to forms and reports
• Building database navigation elements
• Grouping and sorting data in reports
• Building reports from queries or wizards
• Calculating fields
• Linking forms and reports
• Printing and exporting reports