- 4-5 hours worth of material
- LinkedIn Learning
- English
Course Overview
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.
Course Circullum
Introduction
- Collect and display data in Access
- Trust the exercise files
- 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
- 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
- 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
- Create a main menu
- Refine button macros
- Create a data entry form
- Finalize the customer form
- 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
- 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
- Next steps
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Collect and display data in Access
- Trust the exercise files
- 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
- 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
- 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
- Create a main menu
- Refine button macros
- Create a data entry form
- Finalize the customer form
- 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
- 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
- Next steps
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:4-5 hours worth of material
- Language CC: