This [course_title] will provide you the knowledge of how to Access is constructed and how to use the major objects within it. It allows you to create and manage database for all sorts of different purposes. It will help all novice computer users get up to speed quickly. It will also help more experienced users who have little to no experience with Microsoft Access and databases general.
If you have the general knowledge of working with windows and want to improve your knowledge more you are welcome to join this course.
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
Getting Started with Access | |||
Orientation to Microsoft Access | 01:00:00 | ||
Create a Simple Access Database | 01:00:00 | ||
Get Help in Microsoft Access | 00:30:00 | ||
Working with Table Data | |||
Modify Table Data | 00:30:00 | ||
Work with Records | 01:00:00 | ||
Sort and Filter Records | 00:30:00 | ||
Create Lookups | 01:00:00 | ||
Querying a Database | |||
Join Data from Different Tables in a Query | 01:00:00 | ||
Sort and Filter Data in a Query | 01:00:00 | ||
Perform Calculations in a Query | 00:30:00 | ||
Creating Advanced Queries | |||
Create Parameter Queries | 00:30:00 | ||
Create Action Queries | 00:30:00 | ||
Create Find Duplicate and Find Unmatched Queries | 00:30:00 | ||
Summarize Data | 00:30:00 | ||
Generating Reports | |||
Create a Report | 01:00:00 | ||
Add Controls to a Report | 00:30:00 | ||
Enhance the Appearance of a Report | 00:30:00 | ||
Prepare a Report for Print | 00:30:00 | ||
Customizing the Access Environment | |||
The Access Options Dialog Box | 01:00:00 | ||
Designing a Relational Database | |||
Relational Database Design | 00:30:00 | ||
Create a Table | 01:00:00 | ||
Modify a Table and Fields | 00:30:00 | ||
Create Table Relationships | 00:30:00 | ||
Joining Tables | |||
Create Query Joins | 00:30:00 | ||
Join Tables That Have No Common Fields | 00:30:00 | ||
Relate Data within a Table | 00:30:00 | ||
Work with Subdatasheets | 00:30:00 | ||
Create Subqueries | 00:30:00 | ||
Organizing a Database for Efficiency | |||
Data Normalization | 01:00:00 | ||
Create a Junction Table | 00:30:00 | ||
Sharing Data Across Applications | |||
Import Data into Access | 00:30:00 | ||
Export Data to Text File Formats | 00:30:00 | ||
Export Access Data to Excel | 00:30:00 | ||
Create a Mail Merge | 00:30:00 | ||
Advanced Reporting | |||
Organize Report Information | 00:30:00 | ||
Format Reports | 00:30:00 | ||
Include Charts in a Report | 00:30:00 | ||
Add a Calculated Field to a Report | 00:30:00 | ||
Add a Subreport to an Existing Report | 00:30:00 | ||
Additional Reporting Options | |||
Create a Mailing Label Report | 00:30:00 | ||
Publish a Report as PDF | 00:30:00 | ||
Activities | |||
Activities – Microsoft Access 2016 for Beginners | 00:00:00 | ||
Assessment | |||
Submit Your Assignment | 00:00:00 | ||
Certification | 00:00:00 |
Course Reviews
No Reviews found for this course.