Access Quick Tips
Created By
Laurie Ann Ulrich via LinkedIn Learning
- 0
- Less than 1 hour of material
- LinkedIn Learning
- English
Course Overview
Get quick tips for making the most of Microsoft Access.
Microsoft Access is a powerful tool for collecting, querying, and reporting data. This series provides tips on how to do all that more effectively. Laurie Ann Ulrichâauthor of Access for Dummiesâprovides solutions and shortcuts for making your database more logical, your form and queries more useful, your reports more informative and engaging, and your workflow more efficient. From storyboarding your database to setting up input masks and parameter prompts, these tips are perfect for novice and experienced users alike.
Microsoft Access is a powerful tool for collecting, querying, and reporting data. This series provides tips on how to do all that more effectively. Laurie Ann Ulrichâauthor of Access for Dummiesâprovides solutions and shortcuts for making your database more logical, your form and queries more useful, your reports more informative and engaging, and your workflow more efficient. From storyboarding your database to setting up input masks and parameter prompts, these tips are perfect for novice and experienced users alike.
Course Circullum
Introduction
- Making the most of Access
- Storyboarding
- Planning table and field names
- Quick table setups
- Effective naming conventions
- Using input masks
- Making validation rules
- Building lookup tables
- Creating one-to-many relationships
- Type mismatch errors
- Editing relationships
- Fast forms with subforms
- Creating read-only forms
- Find your way with navigation forms
- Create combo and list boxes
- Make bigger buttons to speed data entry
- Adding forgotten fields to an existing form
- Adjusting tab order in forms
- Playing Go Fish with your data
- Finding missing data
- Updating records with a query
- Aligning form and report content
- Resizing field boxes and labels
- Distributing form and report content
- Creating labels for forms and reports
- Drawing straight lines
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Making the most of Access
- Storyboarding
- Planning table and field names
- Quick table setups
- Effective naming conventions
- Using input masks
- Making validation rules
- Building lookup tables
- Creating one-to-many relationships
- Type mismatch errors
- Editing relationships
- Fast forms with subforms
- Creating read-only forms
- Find your way with navigation forms
- Create combo and list boxes
- Make bigger buttons to speed data entry
- Adding forgotten fields to an existing form
- Adjusting tab order in forms
- Playing Go Fish with your data
- Finding missing data
- Updating records with a query
- Aligning form and report content
- Resizing field boxes and labels
- Distributing form and report content
- Creating labels for forms and reports
- Drawing straight lines
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:Less than 1 hour of material
- Language CC: