Description:
There you go the 2nd part of Microsoft Access 2013. It provides thorough intermediate training Access 2013.This Microsoft Office 2013 Access Intermediate – Complete Video Course covers the intermediate functions and feature of Access 2013. By this course you will learn about designing a relational database, split forms, creating and modifying reports, parameter queries, crosstab queries, customizing input forms, creating customs reports, and more, joining tables and advanced reporting, and more detail about Microsoft Access 2013.
You will also learn how to organize a database for efficiency and share data across applications. Here, you will explore Visual Basic and learn how to create a report dialog box so udders can filter report data. 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 Intermediate – 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 Intermediate – 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.
Course Curriculum
| Designing a Relational Database | |||
| Relational Database Design | 00:13:00 | ||
| Create a Table | 00:15:00 | ||
| Create Table Relationships | 00:10:00 | ||
| Joining Tables | |||
| Create Query Joins | 00:10:00 | ||
| Join Tables That Have No Common Fields | 00:04:00 | ||
| Relate Data within a Table | 00:06:00 | ||
| Work with Subdatasheets | 00:05:00 | ||
| Create Subqueries | 00:06:00 | ||
| Organizing a Database for Efficiency | |||
| Data Normalization | 00:13:00 | ||
| Create a Junction Table | 00:07:00 | ||
| Improve Table Structure | 00:05:00 | ||
| Sharing Data Across Applications | |||
| Import Data into Access | 00:12:00 | ||
| Export Data to Text File Formats | 00:06:00 | ||
| Export Access Data to Excel | 00:03:00 | ||
| Create a Mail Merge | 00:11:00 | ||
| Advanced Reporting | |||
| Organize Report Information | 00:19:00 | ||
| Format Reports | 00:17:00 | ||
| Include Control Formatting in a Report | 00:04:00 | ||
| Add a Calculated Field to a Report | 00:05:00 | ||
| Add a Subreport to an Existing Report | 00:06:00 | ||
| Mock Exam | |||
| Mock Exam- Microsoft Office 2013 Access Intermediate – Complete Video Course | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Microsoft Office 2013 Access Intermediate – Complete Video Course | 00:20:00 | ||
Certificate of Achievement
CPD Accredited Certification
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
Course Reviews
No Reviews found for this course.
- PRIVATE
- 1 year
- Intermediate
- Number of Units20
- Number of Quizzes2
- 3 hours, 37 minutes