Access 2019: Forms and Reports
Offered By: LinkedIn Learning
Course Description
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.
Syllabus
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
Taught by
Adam Wilbert
Related Courses
Fundamentos de Excel para NegociosUniversidad Austral via Coursera Excel Skills for Business: Essentials
Macquarie University via Coursera مهارات برنامج Excel للعمل: المبادئ الأساسية
Macquarie University via Coursera Spreadsheets for Beginners using Google Sheets
Coursera Project Network via Coursera Build and Utilize Forms in LibreOffice Base
Coursera Project Network via Coursera