Author
Laurie Ann Ulrich
Released
2/27/2019- Planning your database
- Building tables
- Setting field properties
- Creating relationships
- Creating forms for data entry
- Finding data with queries
- Updating records with queries
- Building better reports
Skill Level Intermediate
Duration
Views
- [Laurie] Hello, and welcome to Access Tips and Tricks. I'm Laurie Ulrich, coauthor of the perennially top selling book, Access for Dummies, bringing you just what the name of this course promises. Solutions, shortcuts and bright ideas for harnessing the power of the formidable Microsoft Access. Whether you're a veteran Access user or a starry eyed Access beginner, you're bound to have several "I wish I'd known "this sooner" moments. You'll discover ways to make your database setup more logical, your data entry forms more useful, your queries more revealing and your reports more informative and polished.
There's something here for everyone who wants to make Access their own.
-
Introduction
-
1. Planning
-
Storyboarding1m 6s
-
-
2. Building a Table
-
3. Field Properties
-
Using input masks1m 19s
-
-
4. Relationships
-
Editing relationships1m 4s
-
5. Data Entry
-
Fast forms with subforms1m 12s
-
Create combo and list boxes1m 27s
-
Adjusting tab order in forms1m 15s
-
-
6. Queries
-
Finding missing data1m 7s
-
7. Reports
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Making the most of Access