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
No Reviews found for this course.