Included Exercise Files
Skill Level : Intermediate
Duration : 4h 20m
Language : English
Released : 12/10/2018
Size : 703,61 Mb
Learn how to best use forms and reports to control and organize the display of your data, as well as gather parameters for queries. Access expert Adam Wilbert starts with the basics of form design and discusses how to leverage controls such as buttons and links. He combines these ideas in a chapter that shows how to build an application-like framework for getting around a database. He then dives into reports, showing how to create efficient and readable layouts, build a report from a query, and use conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports as he steps through how to create a profit summary report.
Topics include:
Creating forms with the Form Wizard
Formatting and aligning form objects
Combining text boxes
Adding a form header
Organizing screen space with tabs
Controlling input
Adding images
Linking form controls
Creating menus and data entry forms for the database
Building reports
Creating calculation fields
Linking forms and reports
