2015
Lynda
Adam Wilbert
4:58
English
Make the information in your Access database more transparent and easier to navigate with forms and reports. This course demonstrates how you can use forms and reports to control and organize the display of your data, as well as gather parameters for queries. Author Adam Wilbert starts with the basics of form design and leveraging controls such as buttons, links, and macros. He combines these ideas in a chapter that shows how to build an application-like framework for getting around the database.
Then the course dives into reports: creating efficient and readable layouts, grouping data into categories, tying reports to queries, and using conditional formatting rules to highlight key takeaways from the data. Finally, Adam demonstrates how to link forms and reports together and print your results, and introduces unique ways to save time filling out paperwork and generating form letters.
Introduction
Welcome
Using the exercise files
Using challenges
1. Introduction to Forms
Introducing forms
Designing for the end user
Exploring the database
Creating a form with the Form Wizard
Refining the form in Layout view
2. Form Design Basics: Creating an Employee Directory
Organizing the form elements
Formatting and the Format Painter
Aligning controls
Modifying the form through its properties
Adding a header and some polish
Challenge: Exploring properties
Solution: Exploring properties
3. Form and Report Controls
Introducing form controls
Using lines and rectangles
Organizing screen space with tabs
Adding buttons
Linking to external content
Entering and selecting data
Controlling input with option groups
Attaching documents
Attaching images
Understanding the subform control
Adding charts
Linking controls
Setting default properties
4. Getting around the Database
Creating a main menu
Creating a customer form
Setting tab stops
Challenge: Creating navigation
Solution: Creating navigation
5. Report Layout
Grouping and sorting data
Understanding report structure
Building reports from wizards
Building reports from queries
Formatting data based on their values
Calculating fields
Adding header information
Segmenting your data into groups
Challenge: Creating a report
Solution: Creating a report
6. Linking Forms and Reports: Creating a Profit Summary
Selecting the desired parameters
Creating the report
Connecting the form
Connecting the query
Adding line numbers to the report
Hiding repeating values
7. Printing and Exporting Reports
Printing reports
Automating the workflow with macros
8. Populating Business Documents
Preparing the scanned template
Selecting a record from the database
Constructing the report
Creating a form letter
Conclusion
Next steps
Download File Size:674.21 MB