Course 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 00:01:00
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Course Recap 00:01:00
-
Resources – Access 2016 Intermediate
Course Reviews
No Reviews found for this course.
or
Get all courses for only £492000+ Globally Recognised Premium Courses
This course includes:
