• LOGIN
  • No products in the cart.

There you go the 2nd part of Microsoft Access 2013. It provides thorough intermediate training Access 2013.This [course_title] 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

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: Edukite

 

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
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.9

4.9
6 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

470 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
EduKite is a part of Ebrahim College, Charity commission reg no. 1108141