• LOGIN
  • No products in the cart.

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

4.7

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

No Reviews found for this course.

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