Access: Time Saving Tips That Will Boost Your Productivity
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4.5 Hours | Lec: 76 | 600 MB
Genre: eLearning | Language: English
How to work faster in your Access databases, even if you have been using Access for years.
Imagine a Monday morning. You've just gotten in the office, said your "Hellos", your "How was your weekends", and you sit at your desk and start your computer.
You push your cup of green tea, or coffee to the side. You start up Access, and you pause.
You have data to enter, or reports to run and e-mail, or both.
Maybe you need to write queries.
If you have ever hesitated because you thought it would take too long, or it was just too cumbersome, you might be surprised on the amount of time that can be saved, the data entry errors that will never happen, with the knowledge of just a few tips and tricks.
Here's how to get started:
Do you or your co-workers use Microsoft Excel, but need your data imported into Access?
Take a look at Section 2: Tables.
Are users entering in data that is not appropriate for the fields, or do they need extra help knowing what data to enter?
Do you want to create drop-down boxes that display information based off of data in another drop-down box?
This course will show you how.
Grouping, totaling, and setting page breaks for reports in Access can, at times, be difficult.
Watch the lectures in Section 4: Reports to help you.
From wildcards, to parameter queries, to action queries, go beyond the basics with Section 5: Queries.
Macros will save you time with Access databases. Get an introductions to the Macro Builder Window, and learn to create a few macros in Section 7.
Learn how to help users quickly navigate to the tables, forms, and reports that they need most by completing the lectures in Section 8: Start up & Navigation.
Maintenance is so important to the life of your database, so take a look at Section 9, for an introduction to the tools that you need to know to keep your database running smoothly.
This course can be completed in hours, but the information can last a lifetime.
So if you are beyond the beginner stage in Access, and want a convenient way to learn Access Tips & Tricks, I invite you to enroll.
This is not an advanced Access course, though advanced users are welcome, and might benefit from lectures within the course.
Take a look at the course curriculum to help decide if this informative, easy-to-follow course is for you.