This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you’ll master more advanced techniques for this powerful database program and build an entire database project from scratch.
From building reports to using conditional formatting, you’ll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you’ll build a navigation form to make it easy for your users to find their way around your database.
What Will I Learn?
- Design Tables for Better Data Entry
- Share Data with Other Applications
- Work with Action Queries
- Advanced Query Techniques
- Automate Processes with Macros
- Advanced Forms
- Advanced Report Techniques
Requirements
- Access 2016 Introduction or equivalent experience.
Who is the target audience?
- Students who want to take Access to the next level and improve their database design skills.
Course Curriculum
| Introduction | |||
| Introduction | FREE | 00:01:00 | |
| Designing Tables for Better Data Entry | |||
| Reviewing Table Design Principles | 00:04:00 | ||
| Setting Field Size, Formats and Captions | 00:06:00 | ||
| Setting Default Value and Required Fields | 00:03:00 | ||
| Restricting Data Entry Using Data Validation | 00:02:00 | ||
| Restricting Data Entry Using Input Masks | 00:06:00 | ||
| Sharing Data with Other Applications | |||
| Exporting Tables and Queries to Excel | 00:03:00 | ||
| Importing Data from a TXT File | 00:03:00 | ||
| Importing Data from Excel | 00:02:00 | ||
| Exporting Data to a TXT File | 00:02:00 | ||
| Linking External Data Sources | 00:03:00 | ||
| Using Word Merge | 00:02:00 | ||
| Working with Action Queries | |||
| What are Action Queries | 00:02:00 | ||
| Creating an Update Query | 00:02:00 | ||
| Creating an Append Query | 00:03:00 | ||
| Creating a Delete Query | 00:02:00 | ||
| Creating a Make Table Query | 00:02:00 | ||
| Changing the Start Number of an Auto Number Field | 00:03:00 | ||
| Advanced Query Techniques | |||
| Creating Query Joins | 00:05:00 | ||
| Creating Find Unmatached and Find Duplicate Queries | 00:03:00 | ||
| Creating Parameter Queries | 00:04:00 | ||
| Using -Like- Keyword in Parameter Queries | 00:02:00 | ||
| Creating a Top X Query | 00:02:00 | ||
| Reviewing Calculated Query Fields | 00:03:00 | ||
| Summarizing Query Data with Totals | 00:03:00 | ||
| Inserting Where Statements in Summary Queries | 00:01:00 | ||
| Creating a Crosstab Query | 00:03:00 | ||
| Automating Processes with Macros | |||
| Understanding Macro Basics | 00:06:00 | ||
| Creating Macros to Open Forms by Record | 00:04:00 | ||
| Validating Data Entry with Macros | 00:04:00 | ||
| Creating a Macro to Automate Data Entry | 00:03:00 | ||
| Advanced Data Entry Using Macros and DLOOKUP Function | 00:06:00 | ||
| Advanced Form | |||
| Using Conditional Formatting | 00:02:00 | ||
| Organizing Form Fields with Tab Controls | 00:03:00 | ||
| Creating a Combo Box Control | 00:02:00 | ||
| Creating an Option Group Control | 00:03:00 | ||
| Using a Subform to Show Data from a Related Table | 00:03:00 | ||
| Advanced Report Techniques | |||
| Inserting a Chart on a Report | 00:03:00 | ||
| Showing Data in Columns | 00:02:00 | ||
| Inserting a Subreport | 00:02:00 | ||
| Configuring Reports with Parameter Queries | 00:04:00 | ||
| Sending Reports | 00:02:00 | ||
| Conclusion | |||
| Course Recap | 00:01:00 | ||
| Course Certification | |||
| Order your Certificate | 00:00:00 | ||
FAQs
This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.
No prior qualifications are needed to take this course.
You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!
Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.
Don’t worry if you fail the test, you can retake it as many times as you want.
You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.
We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.
After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.
