Computer lesson 10 – DATABASE MANAGEMENT SOFTWARE
It’s Our Tenth Week in Computer Studies and we are actually Making Progress.
Last week we did Some Practical In PowerPoint and I gave Some Homework, unfortunately, I had a poor turn up.
Most Students repeated the questions which took almost half of the Write-up, and that wasn't quality enough to receive those rewards.
Please do better next time.
In Our today's class, we would look at Data Base Management As I mentioned last Week.
DATABASE MANAGEMENT SOFTWARE
These are software that helps computer users create, edit, and manage databases.
A database is defined as a collection of data or information organized for storage in computer memory and designed for easy access by its authorized users.
This data may be in the following forms: text, numbers, or encoded graphics.
Databases have become so important in modern societies that they can be found in almost every field of information including Government, Military, and Education.
Examples of database management software are Microsoft SQL, SAP HANA, Oracle, and Microsoft Access. In this lesson, Microsoft Office Access is the database management software that will be considered.
MICROSOFT OFFICE ACCESS
Microsoft Access is database management software designed by Microsoft Corporation as a part of the Microsoft Office Suite. It contains tools to create and manage professional databases. To access Microsoft Access:
● Click on your start button to open the start menu and look for Microsoft Access.
● You can also simply use your search tool to search for “Access”. The application will launch.
MS Access 2007
MS Access 2016
The above diagrams show the startup or welcome page in two different versions of MS Access (2007 and 2016). The user can choose to create a blank database or pick any of the templates listed.
FEATURES OF MICROSOFT OFFICE ACCESS
Just like other application software in the Microsoft Office Suite, MS Access contains similar features.
The Menu Bar contains the Home Menu, Create Menu, External Data menu, and Database Tools menu. We will look at some of this featured menu content.
This menu tab helps the database user format the text, change views, sort and filter, find and replace text in the database record and also save and refresh records in the database.
This menu tab basically assists the user to create different types of databases. It contains tools for creating and editing table type databases, form type databases, report type databases as well as query type databases.
External Data Tab:
The external data menu provides tools that help the user import external data from different sources like excel, Lotus123, Paradox, etc.
The menu also has tools that enable the user to export the database to different formats and applications. The user can also collect email data, and synchronize and edit SharePoint lists.
Database Tools Tab:
This menu helps us to encrypt, analyze, show relationships /dependencies and run macros on the database.
The above are features of Microsoft Office Access menu tabs.
Access also includes specified templates that assist users with specific databases. The picture below shows some of these templates.
And that's the end of our lesson for today Kids. By Next Week, we would look at Excel In our Next Class.
What If I tell you we don't have Home Work this Week? I want you all to go through all our Previous Classes, Check all the Corrections I have given to everybody and get Prepared for next Week.
I will like to see how you all Create Some quality Content When I give you Home Work by Next Week.
Bye Bye !!
[ Unless otherwise indicated, All Images/Graphics Used here are Mine ]