You must be logged in to take this course → LOGIN | REGISTER NOW
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
No Reviews found for this course.