Microsoft Office Access


Microsoft Office Access

Microsoft Office Access is a database application used to create and manage databases.

Databases allow one to store information related to specific topics in an organized way. In addition to storing information, they are used to extract, sort and summarize information.

This module begins with an Introduction to Databases where the student is taught the theory, rules, methodologies behind the designing of databases.

The course is designed for students working with Microsoft Access. Students will learn how to create new databases, create reports and manage data in existing databases. In addition, students will learn how to maintain data consistency, customize database components, and to share Access data with other applications. Introductory Microsoft Access classes offer a tour of the software and introduce new users to the features and advantages of Microsoft Access. Students explore the program and learn core skills, such as finding and using database templates, creating tables and modifying forms and reports.


  1. Introduction to Databases
  2. Basic
  3. Intermediate
  4. Advance
  • Summary

    Introduction to Databases provide participants with an overview of what databases are and how they are designed. The course explains the theory, methodology, principles and considerations behind the design of databases.

    The course does not incorporate the use of any database application, but instead focuses on the theoretical foundation that participants must know in order to design or use any database application effectively.

    Objective

    Upon completion of the course participants will be able to:

    • Know and appreciate what databases are
    • Know and describe the types of databases
    • Plan the design of databases
    • Identify and create database Entities and Fields
    • Identify and create database Tables
    • Identify Primary Keys and Secondary Keys
    • Establish database Relationships
    • Create Entity-Relationship Diagram
    • Query Databases using basic SQL

    Prerequisite

    • Introduction to Computing

    Target

    • Persons who wish to pursue a course or career in database design or management, or need to grasp an understanding of how databases are designed and managed. It is also meant for persons who intend to use any database management application in designing and managing databases.

     

  • Summary

    Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools.

    In this course, participants will go through creating, populating and querying databases using Microsoft Office Access

    Objective

    Upon completion of the course participants will be able to:

    • Navigate the Microsoft Office Access environment
    • Plan and design databases in Microsoft Office Access
    • Set up Tables and Fields
    • Apply Data Validation
    • Apply Preferential Integrity
    • Establish Table Relationships
    • Create basic Forms
    • Sort and Filter records
    • Create basic Queries
    • Create Reports
    • Print Reports

    Prerequisite

    • Introduction to Computing
    • Microsoft Office Word – Basic
    • Introduction to Databases

    Target

    • Persons who wish to learn the basic operations of the Microsoft Office Access application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. 

     

  • Summary

    In this course, participants will be taught how to maintain data consistency, how to customize database components, and how to share Microsoft Office Access data with other applications

    Objective

    Upon completion of the course participants will be able to:

    • Maintain data integrity
    • Control data entry
    • Create advance Forms, Sub-forms and Custom-forms
    • Add Controls to Forms
    • Create Navigation Forms
    • Create advance Queries
    • Create advance Reports
    • Organize information with Tabbed Pages
    • Display a Summary of Data in a Form
    • Add Headers and Footers
    • Add Charts to forms
    • Import, Export and Link objects
    • Password protect database

    Prerequisite

    • Introduction to Computing
    • Microsoft Office Access - Basic

    Target

    • This course is for persons whose job responsibilities include maintaining data integrity, handling complex queries, forms, and reports, and sharing data between Microsoft Office  Access and other applications. 

     

  • Summary

    In this course, you will extend your knowledge into some of the more specialized and advance capabilities of Microsoft Office Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining databases

    Objective

    Upon completion of the course participants will be able to:

    • Split databases
    • Add PivotTables and PivotCharts
    • Query databases using SQL
    • Attach SQL queries to Controls
    • Create Crosstab and Parameter queries 
    • Create and modify Macros
    • Set database Options and Properties
    • Link tables to external data sources
    • Document a Database
    • Analyze the Performance of a Database
    • Optimizing database resources

    Prerequisite

    • Microsoft Office Access - Intermediate

    Target

    • This course is for the persons whose job responsibilities include working with related tables; creating advanced queries using SQL, forms, and reports, writing macros to automate common tasks, and performing general database maintenance.

     



You may also be interested in...

  • 1
  • 2
Prev Next

Microsoft Office Word

Microsoft Office Word

Microsoft Office Word is the first of the Microsoft Office Suite applications to be studied by the student. It is a word processing application used to create documents such as letters,...

Website Design

Website Design

Websites have become essential in recent years. Individuals and institutions seek to showcase their products and services to the world in order to gain patronage through websites. Websites are the...

Graphic Design

Graphic Design

Graphic design is an interesting field as it brings out ones ability to be creative. The student will be taken through design considerations and rules, and the by step approach...

Microsoft Office PowerPoint

Microsoft Office PowerPoint

Microsoft Office PowerPoint is a presentation application, that is part of the Microsoft Office Suite. The application incorporates a graphical approach to presentations in the form of slide shows that accompany...

Microsoft Office Excel

Microsoft Office Excel

Microsoft Office Excel, part of the Microsoft Office Suite, is a spreadsheet application for making computations. The ability of the applications to make basic computations as well as analytical, statistical and...

Microsoft Office Project

Microsoft Office Project

Microsoft Office Project is a project management application. As part of the Microsoft Office Suite, it is a tool used to define, schedule, execute, monitor and report tasks of projects....



Stay Connected

 contact +233 (0) 274 236 750
  +233 (0) 303 305 664
   
 email This email address is being protected from spambots. You need JavaScript enabled to view it.
   
 facebook Facebook


Locate Us

location  114 Apple Avenue, Comm. 10, Tema
   
  map