0
  • LOGIN

  • No products in the cart.

Login

Forgot Password?

Course Curriculum

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:00: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:08:00
Using -Like- Keyword in Parameter Queries 00:02:00
Creating a Top X Query 00:01:00
Reviewing Calculated Query Fields 00:03:00
Summarizing Query Data with Totals 00:02: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:04: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:00:00

MS Access 2016 Intermediate

0( 0 REVIEWS )
353 STUDENTS
$ 249.00
TAKE THIS COURSE
MS Access 2016 Intermediate

Description

MS Access 2016 Intermediate Course is designed to teach the learners about some complex features and functionalities of MS Access. You’ll learn how to create and manage a database more effectively by taking your introductory knowledge to the next level.

  • Learning outcome
  • Grasp over the intermediate functions of the Microsoft Access 2016 database management program.
  • Working with Action Queries and Advanced Query Techniques.
  • Automate Processes with Macros and the use of Advanced Forms.
  • Improved knowledge in forms and reports using more complex functionalities and Design View.
  • Practical knowledge needed to fast track your career.

Requirements

  • Learners will need regular access to a computer with an internet connection.
  • High speed broadband access (LAN, Cable or DSL) is highly recommended for the optimal learning experience.
  • This course is available to all learners, of all academic backgrounds.
  • Why should I take this course?
  • 2+ hours of quality e-Learning content.
  • Certificate upon completion of the course.
  • Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes.
  • You’ll learn about more advanced features and functionalities of database management.
  • You’ll be able to build a comprehensive understanding of database management and strengthen your skills to advance your career.

Testimonial

Hear what our happy students want to say
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
It was a pleasure to do a course in SkillUp. The course is well organized and I could study at my own pace.
Super varied course content. From Healthcare and fitness to Therapeutic courses. What I particularly like are the course modules and the way they are arranged gradually. With my nutritional background, I have come to know and love completely different perspectives.
Recommendable! A unique experience, the courses have every detail covered. Enjoyed the course through and through.
The price is reasonable, and you know upfront of your costs. I would recommend Skill Up to learners who want to excel their skills or looking for self-development.
The modules are easy to understand and there is help available if required. Besides great collection of exciting topics which make you come back for more.
Previous
Next

Related Courses

Setup Menus in Admin Panel