Microsoft Access: Forms and Reports

Focused View

4:12:09

336 View

01 - Introduction

01 - Collecting and displaying data in Access.mp4

00:51

02 - Trust the exercise files.mp4

01:25

02 - 1. Making the Most of Forms in Access

01 - The benefit of well designed forms.mp4

05:09

02 - Design for the end user.mp4

01:54

03 - Get to know the Red30 Tech database.mp4

02:20

04 - Create a form with the form wizard.mp4

05:48

05 - Create a form with subforms.mp4

06:07

06 - Refine the form design in layout view.mp4

08:34

03 - 2. Form Design Basics Creating an Employee Directory

01 - Organize the form design.mp4

08:11

02 - Format objects and the Format Painter tool.mp4

06:22

03 - Anchor controls.mp4

05:06

04 - Modify form properties.mp4

08:46

05 - Combine text boxes.mp4

03:01

06 - Add a form header.mp4

05:40

04 - 3. Form and Report Controls

01 - Label control.mp4

07:48

02 - Lines and rectangles.mp4

05:02

03 - Organize screen space with tabs.mp4

04:04

04 - Button controls.mp4

09:38

05 - Linking to external content.mp4

06:45

06 - Add data with a text box.mp4

06:44

07 - Select data with a combo box.mp4

04:56

08 - Edit the display of a combo box.mp4

03:41

09 - Control input with option groups.mp4

05:04

10 - Add images to a form.mp4

06:50

11 - Edit the tab stop sequence.mp4

06:12

12 - Embed a subform control.mp4

07:23

13 - Display a chart.mp4

07:34

05 - 4. Getting Around the Database

01 - Create a main menu.mp4

05:54

02 - Refine button macros.mp4

07:26

03 - Create a data entry form.mp4

06:12

06 - 5. Report Layout

01 - Organize records with group and sort.mp4

07:07

02 - Understand report structure.mp4

04:44

03 - Add a section header to the report.mp4

03:51

04 - Build a report with the wizard.mp4

04:33

05 - Edit the report's data source.mp4

03:12

06 - Build a report from a query.mp4

05:53

07 - Format the report in design view.mp4

04:17

08 - Apply conditional formatting rules.mp4

04:21

09 - Create calculation fields.mp4

05:39

10 - Add a report header.mp4

05:07

07 - 6. Linking Forms and Reports Creating a Profit Summary

01 - Build the query.mp4

04:29

02 - Create the report structure.mp4

04:25

03 - Style the report for legibility.mp4

09:55

04 - Design the form controls.mp4

06:03

05 - Connect the query.mp4

02:31

06 - Add line numbers to the report.mp4

02:25

07 - Launch Main Menu form at startup.mp4

01:53

08 - Conclusion

01 - Next steps.mp4

01:17

Description

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, giving you the skills you need to build an application-like framework for getting around a database. Explore the full power of Access reports and 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. Adam demonstrates how to link forms and reports as he walks you through how to create a profit summary report.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Access

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.