[Lynda.com] Access 2013 Forms And Reports In Depth [2015, ENG]

Содержание

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

Скриншоты