- 0
- 3-4 hours worth of material
- LinkedIn Learning
- English
Course Overview
Shows how to manage data entry and reporting tasks using Access 2007.
Discover how to manage data entry and reporting tasks more efficiently with Access 2007. Author Adam Wilbert presents lessons designing forms, organizing and displaying data with form controls, creating flexible queries, and building a form-based navigation system. The course also shows how to build reports from wizards and queries, highlight important data with conditional formatting, and automate reporting processes with macros.
Discover how to manage data entry and reporting tasks more efficiently with Access 2007. Author Adam Wilbert presents lessons designing forms, organizing and displaying data with form controls, creating flexible queries, and building a form-based navigation system. The course also shows how to build reports from wizards and queries, highlight important data with conditional formatting, and automate reporting processes with macros.
Course Circullum
Introduction
- Welcome
- Using the exercise files
- Introducing forms
- Designing for the end user
- Exploring the database
- Creating a form with the wizard
- Refining the form in Layout view
- Organizing the form elements
- Formatting the form
- Modifying the form through its properties
- Adding a header and some polish
- 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
- Creating the main menu
- Adding a splash screen with startup options
- Creating a customer form
- Grouping and sorting data
- Understanding report structure
- Building reports from wizards
- Building reports from queries
- Formatting conditionally
- Calculating fields
- Adding the finishing touches
- Populating pre-printed documents
- Printing reports
- Tweaking the design
- Automating the workflow with macros
- Next steps
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Welcome
- Using the exercise files
- Introducing forms
- Designing for the end user
- Exploring the database
- Creating a form with the wizard
- Refining the form in Layout view
- Organizing the form elements
- Formatting the form
- Modifying the form through its properties
- Adding a header and some polish
- 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
- Creating the main menu
- Adding a splash screen with startup options
- Creating a customer form
- Grouping and sorting data
- Understanding report structure
- Building reports from wizards
- Building reports from queries
- Formatting conditionally
- Calculating fields
- Adding the finishing touches
- Populating pre-printed documents
- Printing reports
- Tweaking the design
- Automating the workflow with macros
- Next steps
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:3-4 hours worth of material
- Language CC: