About Course

This course gives you the in-depth understanding of Microsoft Access and it brings out the concept of database designing, as you may be aware Databases are used to store information in a structured way. and currently technology rides on databases.

For instance, Computerized databases can enable you to store large amounts of information.  You can then search for any piece of information or sort the information by any criteria.  You can cross reference the data easily, and extract data to be viewed on screen or printed out in a variety of different formats.

For example, if you have a database of staff working at a company, you can extract the names of all staff who work at a certain location and have been with the company for over 5 years.  You can then sort the extracted list alphabetically by surname and print it out.

Show More

What Will You Learn?

  • Database Management System (DBMS)
  • What is Database
  • Data processing
  • Database applications
  • Elements of a Database, table, forms, reports, queries, record, fields
  • Data types
  • Number field
  • Lookup Field
  • Key Field – primary and Foreign Key
  • Entity
  • Attribute
  • Relationships
  • One to Many relationship
  • Many to Many relationship
  • Views
  • Designing a Database
  • Access database designing Practical's

Course Content

INTRODUCTION TO Database Management System
Gives introduction to database and ms access

  • Introduction to DBMS
  • Introduction to Microsoft Access and relational databases
  • Elements of a Database, table, forms, reports, queries, record, fields, Modules and Macros part 1
  • Elements of a Database, table, forms, reports, queries, record, fields, Modules and Macros part 2
  • Data / Field type
  • KEY FIELDS
    09:43
  • 3 Components of relational database
  • Designing a Database – Linking tables to together
  • Paper work – Database Design

Ms Access Database design and Management – Practicals

Student Ratings & Reviews

No Review Yet
No Review Yet
ZK200

Material Includes

  • Quizzes
  • Assignments
  • Articles
  • Videos

Requirements

  • Good internet connection
  • Answer all quizzes
  • Complete within 30 days

Audience

  • Anyone willing to learn Ms Access
  • Database administrators
  • Head of institutions
  • Students and pupils

Want to receive push notifications for all major on-site activities?