Udemy - Access.2013 Tips & Tricks: Time Saving Questions Answered

[caovantan 42]

Udemy - Access 2013 Tips & Tricks: Time Saving Questions Answered

MP4 | Video: 1280x720 | 82 kbps | 44 KHz | Duration: 5 Hours | 536 MB

Genre: eLearning | Language: English

 

Tips, Tricks, &Time Savers to Help You Get Better at Microsoft Access. Tables to Forms, Queries to Database Maintenance.

Learning Microsoft Access tips can make your workday easier. 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?

Lessons 14 & 15 have you covered!

 

Do you want to create drop-down boxes that display information based off of data in another drop-down box?

Lesson 20 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.

 

Enroll now because you will save time in just a matter hours.

 

What are the requirements?

 

Download the Northwind database to follow along with examples in this course. The Northwind database is available through the Access application. Please see Lecture 3 for details.

What am I going to get from this course?

 

Over 61 lectures and 4 hours of content!

Import and Export Data Using Microsoft Excel

Set Field Validations

Format Fields

Create Cascading Combo Boxes

Conditionally Format Forms & Reports

Create Parameter Queries

Create Action Queries

Create Simple Macros

Customize the Access Environment

Understand Database Maintenance Tools

What is the target audience?

 

This Microsoft Access Tips & Tricks course is for anyone who wants to go beyond the basics of using Access. It is not for brand new users of Access or of databases. It can serve as a refresher for advanced users of Access, but is not designed to be an advanced level course.

Please look over the course curriculum when making your decision on enrolling in this course.

 

 

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.