Introduction to Access – Data Base
An efficient means of managing data is by using databases. Information can be stored, linked, and managed using a database application such a Microsoft Office Access. In this training session, you will examine database concepts, and create and modify databases and their various objects using Microsoft Office Access.
A database is a collection of information that’s related. Access allow you to manage your information in one database file. Within Access there are four major areas: Tables, Queries, Forms and Reports
• Tables store your data in your database
• Queries ask questions about information stored in your tables
• Forms allow you to view data stored in your tables
• Reports allow you to print data based on queries/tables that you have created
What is MS Access?
Microsoft Access is a database developed by Microsoft Corporation. It was developed
by combining the relational database engine and GUI (Graphical User Interface). It was initially released in the year 1992. It supports Microsoft Windows operating system. It was licensed under the Trialware version and just requires a one-time purchase. It is a part of MS Office Suite applications or popularly called as Office 365. It also supports Visual Basic Applications related components. It allows the data model relationships and many other database-related features similar to conventional relational database management systems. The main architectural components of Microsoft Access are such as it can call anything that is of object-based. The typical objects within Microsoft Access are like Tables in the database, Macros, Reports, Queries, Modules, etc.
Microsoft Access being part of Microsoft Office Suite, it has similar features and looks to that of MS Office. The file type extension of MS Access is .accdb in Microsoft Access 2016 where it was .mdb before 2007 edition. Microsoft Access Database is based on desktop and allows to include different types of files such as documents, spreadsheets, different types of formats in a document .
Which tangible skills will you learn in this Course? The set of skills which can easily be obtained from this MS Access Course are such as Microsoft Access, Basic database concepts, creating a database, designing a table, Creating Queries, Creating and modifying Forms, Creating and Designing Reports, exporting data and mail merge and Designing Forms, etc.
CURRICULUM CONTENTS
| Learning Outcomes Examine database concepts and explore the Microsoft Office Access environment. Design a simple database. Build a new database with related tables. Manage the data in a table. Query a database using different methods. Design a form. Generate a report. Import and export data. | Outline Access Basics Design a Database Build a Database Work with Forms Sort, Retrieve, Analyze Data Work With Reports Access with Other Applications Manage an Access Database |
FEE AS AN INDEPENDENT PROGRAM = N8,500
FEE AS PART OF COMPUTER APPRECIATION = N30,000
DURATION = 4 WEEKS