Description

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.

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
Resources
	Resources - Access 2016 Intermediate		00:00:00
Course Certification

Course Images

Access 2016 Intermediate

By iStudy UK

Booking options

Highlights

Description

About The Provider

Tags

Reviews