This chapter is sub divided into two parts and this is the
first part. If you have already read this part, click to read part two - Getting Started with MS-Access and Its User Interface. As a business Organization grows, the volume of their data and information increases to an extent that if an automated, customized data storage and retrieval system is not used to store these information, its retrieval and maintenance will reduce the efficiency of the business.
In other cases, some business organization in quest for
dynamism and accuracy, need a customized system to help them perform some
difficult tasks and calculations efficiently and accurately. These tasks may
include staff payroll system, forecasting and trend, sales report, budget
control, etc. all these tasks can be managed by an electronic database
management system. That is a computer with relevant Database Management System
software like Microsoft Access.
HOW TO STUDY THE CHAPTERS OF THIS TUTORIAL
This tutorial assumes that you don’t
have any knowledge of database administration. It explains from the scratch,
every bit of MS-Access. So if you are a novice in database administration, you
are at the right place. This tutorial is prepared for you.
Each chapter of this tutorial
contains the procedures to achieve some tasks, some practical examples and some
practical exercise for you in order to help you comprehend its content.
It is recommended in this tutorial that you have a PC or an
access to a computer system, so as to enable you practicalize the procedures
and exercises. Also try as much as possible to practice the exercises in this
tutorial for a deeper comprehension of the contents of this tutorial.
See the MS Access Full Course Contents.
CONTENTS
USES OF MS-ACCESS
DATABASE MANAGEMENT SYSTEM (DBMS)
TYPES OF DATABASE
DATABASE TERMINOLOGIES
IMPORTANCE OF SETTING UP A DATABASE IN AN
ORGANIZATION
What is Microsoft Access?
It
is a type of Database Management System used in creating relational database.
It is used to record and store large volume of information which can be retrieved
based a specified criteria.
USES OF MS-ACCESS
1. It is used to record data.
2. It is used for stock inventory control (Stock Control).
3. It is used to prepare sales report.
4. It is used to prepare students grade list.
5. It is also used to prepare bank database.
6. It is used to prepare workers payroll.
7. It can also be used in budget control.
DATABASE MANAGEMENT SYSTEM (DBMS)
This is complex application software that is used to construct, expand and maintain a database. A typical example of a DBMS is MS-Access. Other example include; clipper, Oracle, D-Base, etc.
DATABASE
This is a collection of related records that contain information of individuals, employees or entities which are organized structurally to enhance easy access, update, maintenance and storage with minimum redundancy.
TYPES OF DATABASE
Basically, there are two types of database. They include;
Relational Database, Hierarchical Database and Network Database.
RELATIONAL DATABASE
This type of database organizes its information in records and fields called Table. The fields are related because they are attributes of an entity and also because they all contain the same fields or data items. It can combine records of different files. An example is Workers Record shown below.
HIERARCHICAL DATABASE
The elements of this type of database is subordinate to just one other element, which is called the Root and the root is always at the top of the hierarchy, it is the collection of records on one-to-one relationship.
NETWORK DATABASE
Unlike the hierarchical database, a record can be subordinate to many other records. It is the collection of records on one-to-many relationships.
DATABASE TERMINOLOGIES
- FIELDS
This is a unit of information which forms the attributes of a record. It can also be referred to as Data Item.
- FIELD NAME
This is the column title or heading that specifies the type of data to be stored in a column or field.
- DATA TYPE
This one of the properties of table design view that determines the type of data to be recorded in a field.
- PRIMARY KEY
This is one of the properties of table object that avoids duplication of data in a column. It is used in table relationship.
- RECORD
This is the collection of related fields. It is commonly expressed in rows.
- DATA
It is a raw or unprocessed fact concerning an individual or business organization.
- INFORMATION
It is also referred to as processed data. It is data that have been organized and processed which is now meaningful.
- CHARACTER
It is the smallest entry in a database. A collection of character is called a field or data item. It can be an alphabet (A-Z), numerals (0-9) or alpha-numerals like special characters.
IMPORTANCE OF SETTING UP A DATABASE IN AN ORGANIZATION
There are many benefits of setting up a database for your organization. Some of them include:
- It enhances easy access and retrieval of information.
- It enhances easy update and maintenance of information.
- It accommodates large volume of information.
- It enhances decision making.
- It provides adequate security.
- It supports network of database.
This is the end of part one. I hope you learnt a lot? Feel free to share this tutorial with your friends.
In the part two of this chapter, I will be talking on GETTING STARTED WITH MS-ACCESS AND ITS USER INTERFACE. See you there.
Recommended Entrepreneurship Books
The Passionate Entrepreneur’s Strategies: Learn how to discover business ideas that will be successful, grow multiple online income streams, make money from home, attract new and retain customers, applications of SWOT analysis in any business, skills that will help you succeed as an entrepreneur, self-discipline, etc. Lucrative Business Ideas Series Book 1. By Buzzer Joseph. Read more about the book.
How to Make Money from Blogging and Affiliate Marketing: Learn the Step by Step Guide of Creating, Growing and Optimizing your WordPress Blog from Scratch for Search Engines (SEO) and How to Make Money through Google AdSense, Affiliate Marketing and Other Strategies for Earning Passive Income Online. Lucrative Business Ideas Series Book 2. By Buzzer Joseph. Read more about the book.
How to Make Money Self-Publishing Kindle Books for Beginners: Learn the Step by Step Guide to Self-Publish a Best Selling Book on Amazon KDP, How to Design Book Covers with Adobe Photoshop, Format, Edit and Proofread your Book Manuscript with Microsoft Word, Promote your Book on Various Online Platforms and Earn Monthly Passive Income Online. Lucrative Business Ideas Series Book 3. By Buzzer Joseph. Read more about the book.
Complete Solar PV System Installation Guide: DIY guide on how to install grid-connected and off-grid solar PV systems, how to build solar-powered electric cars, convert conventional cars to electric cars, online and offline ways to make money from solar energy sector (including stocks), electrical wiring and protection system installation guides, plus free resources for skill acquisition and personal development. Lucrative Business Ideas Series Book 4. By Buzzer Joseph. Read more about the book.
How to Make Money from Crypto Trading and Investing for Beginners: Step by step guide with screenshots on the basics of blockchain technology, bitcoin and altcoins, crypto security tips, cryptocurrency market analysis (FA and TA), long term and short term trading, how to calculate your profits in excel, legit ways to make money with cryptocurrencies, DeFi yield farming and staking, how to use any centralized and decentralized exchange platform and more, plus crypto investment bonus! Lucrative Business Ideas Series Book 5. By Buzzer Joseph. Read more about the book.
Blockchain Practical Guide: Step by step guide with pictures, on how to monetize the latest blockchain technology trends: crypto trading and tools, especially Ethereum, DeFi, Staking, NFTs, Top 100 Play-to-Earn (P2E) and NFT games, Web 3.0, Metaverse, Virtual Reality (VR), Augmented Reality (AR), blockchain job opportunities, with crypto investment bonus! Lucrative Business Ideas Series Book 6. By Buzzer Joseph. Read more about the book.
How to Make Money with Blockchain Web3 Apps: Step by Step Guide with Screenshots and Videos on How to Make Money from Blockchain and Web3 Projects – NFTs, Play-to-Earn (P2E) Games, Move-to-Earn (M2E) Apps, Watch-to-Earn (W2E) Apps, SocialFi and GameFi Apps, with crypto investment bonus! Lucrative Business Ideas Series Book 7. By Buzzer Joseph and Kelly Joseph. Read more about the book.
Very rich content. I never knew much about ms access until i read this tutorial post.
ReplyDelete