MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .SRT | + Exercise FilesLevel: Intermediate | Duration: 4h 20m | 812 MBLearn 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 WizardFormatting and aligning form objectsCombining text boxesAdding a form headerOrganizing screen space with tabsControlling inputAdding imagesLinking form controlsCreating menus and data entry forms for the databaseBuilding reportsCreating calculation fieldsLinking forms and reports