• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Office 2013 Access Advanced - Complete Video Course

Microsoft Office 2013 Access Advanced - Complete Video Course

By John Academy

4.3(43)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 3 hours 47 minutes

  • All levels

Description

Description:

Nowadays data management is absolutely crucial, and there's not much room for error. If you've already taken the basic Microsoft Access 2013 course, or know your way around the program already, then you're ready for this advanced level of Microsoft Access 2013. This Microsoft Office 2013 Access Advanced - Complete Video Course covers advanced functions and features of Access 2013. You will learn about implementing advanced form design, using data validation and using macros to improve user interfacer design. You will also learn how to use advanced database management, distribute and secure a database and manage switchboards. If you want to take your Microsoft Access 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch.

Assessment:
  • At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.

  • Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:
  • After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.

  • Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

Microsoft Office 2013 Access Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our Microsoft Office 2013 Access Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Implementing Advanced Form Design

Add Controls to Forms

FREE

00:22:00

Create Subforms

00:03:00

Organize Information with Tabs Pages

00:05:00

Enhance Navigation of Forms

00:06:00

Apply Conditional Formatting

00:05:00

Using Data Validation

Field and Record Validation

00:23:00

Form Validation

00:08:00

Using Macros to Improve User Interface Design

Create a Macro

00:17:00

Restrict Records Using a Condition

00:05:00

Validate Data Using a Macro

00:06:00

Automate Data Entry Using a Macro

00:06:00

Convert a Macro to VBA

00:05:00

Using Advanced Database Management

Link Tables to External Data Sources

00:05:00

Manage a Database

00:07:00

Determine Object Dependency

00:05:00

Document a Database

00:05:00

Analyze the Performance of a Database

00:05:00

Distributing and Securing a Database

Splitting a Database for Multiple User Access

00:05:00

Implement Security

00:09:00

Set Passwords

00:07:00

Convert an Access Database to an ACCDE File999

00:07:00

Analyze the Performance of a Database

00:04:00

Managing Switchboards

Create a Database Switchboard

00:07:00

Modify a Database Switchboard

00:04:00

Set Startup Options

00:06:00

Mock Exam

Mock Exam- Microsoft Office 2013 Access Advanced - Complete Video Course

00:20:00

Final Exam

Final Exam- Microsoft Office 2013 Access Advanced - Complete Video Course

00:20:00

Certificate and Transcript

Order Your Certificates and Transcripts

00:00:00

About The Provider

Tags

Reviews