• LOGIN
  • No products in the cart.

This [course_title] builds on the skills and concepts taught in Access 2010: Basic. In this series, you will learn about relational databases, related tables, complex queries, advanced form design, reports and printing, charts, and PivotTables and PivotCharts. 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 discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier.

Do you want to take your Microsoft Access skills to the next level? In this course, you’ll master more advanced techniques for this powerful database program and build an entire data project 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

Relational Databases
Database Normalization 00:14:00
Table Relationships 00:13:00
Referential Integrity 00:12:00
Related Tables
Creating Lookup Fields 00:11:00
Modifying Lookup Fields 00:06:00
Using Subdatasheets 00:04:00
Complex Queries
Joining Tables in Queries 00:26:00
Using Calculated Fields 00:09:00
Summarizing and Grouping Values 00:08:00
Advanced Form Design
Adding Unbound Controls 00:08:00
Adding Graphics 00:04:00
Adding Calculated Values 00:06:00
Adding Combo Boxes 00:04:00
Advanced Form Types 00:10:00
Reports and Printing
Customized Headers and Footers 00:17:00
Calculated Values 00:08:00
Printing 00:03:00
Labels 00:05:00
Charts
Charts in Forms 00:08:00
Charts in Reports 00:06:00
PivotTables and PivotCharts
PivotTables 00:05:00
Modifying PivotTables 00:07:00
PivotCharts 00:04:00
PivotTable Forms 00:01:00
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.7

4.7
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

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