Was: $20
You Save: $8 (40%)
Make the most of forms and reports in Access 365. Learn how to control the display of your data, create data entry points and menus for your users, and publish reports.
Learn how to best use forms and reports to control and organize the display of your data, as well as gather parameters for queries. Expert starts with the basics of form design and discusses how to leverage controls such as buttons and links, and combines these ideas in a chapter that shows how to build an application-like framework for getting around a database, 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, expert demonstrates how to link forms and reports as he steps through how to create a profit summary report.
Topics include:
1. Making the Most of Forms in Access
The benefit of well-designed forms
Design for the end user
Get to know the H+ Sport database
Create a form with the Form Wizard
Create a form with subforms
Refine the form in Layout view
2. Form Design Basics: Creating an Employee Directory
Organize the form elements
Format objects and the Format Painter
Object alignment
Anchor controls
Modify form properties
Additional form properties
Combine textboxes
Add a form header
3. Form and Report Controls
Label control
Lines and rectangles
Organize screen space with tabs
Button controls
Button properties
Link to external content
Add data with a text box
Select data with a combo box
Edit the display of a combo box
Form controls for Yes/No data types
Control input with option groups
Place images into the form backgrounds
Additional image properties
Embed a subform control
Prepare a query for charting
Display a chart
Link form controls
Connect a query to a combo box
Edit the Tab Stop sequence
4. Getting Around the Database
Create a main menu
Refine button macros
Create a data entry form
Finalize the customer form
5. Report Layout
Organize records with group and sort
Understand report structure
Build a report with the Wizard
Explore the report wizard output
Build a report from a query
Format the report in Design view
Apply conditional formatting rules
Advanced conditional formatting
Create calculation fields
Add a report header
Segment dates into groups
Format date header sections
6. Linking Forms and Reports: Creating a Profit Summary
Build the query
Create the report structure
Add data to the report, part 1
Add data to the report, part 2
Connect the form
Connect the query
Add line numbers to the report
Launch Main Menu form at startup
1. Language: English.
2. Secure download.
Video file format: MP4.
3. Learn anywhere. Switch between
your computer, tablet, or TV.
4. Practice while you learn
with exercise files.
5. Secure payment by PayPal.
6. 30 days refund.
7. No subscription needed.
8. Lifetime access.
9. This course without a sponsored ads.