Posts

Showing posts from March, 2023

DATABASE, EXECEL AND ACCESS

Image
 WHAT IS A DATABASE? Base on Google DATABASE is a a structured set of data held in a computer, especially one that is accessible in various ways WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? Microsoft Excel is a spreadsheet program that features calculation, graphic tools, pivot tables, and macro programming language support for Windows and Mac operating systems. See more on Excel with Microsoft 365.J WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Microsoft Access is a well-known database management system produced by Microsoft and is part of the Microsoft 365 office suite. Microsoft Access combines Microsoft's relational Jet Database Engine with software development tools and a graphic user interface (GUI). THINK OF AT LEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing com...

DBMS: Function, Advantage and Disadvantage

Image
  Function of a DBMS allowing numerous people to view a single database at once. establishing and maintaining user access permissions and security guidelines.   frequent data backups and speedy data recovery in the event of a breach. establishing database policies and guidelines to safeguard data integrity.   ADVANTAGE OF DBMS A DBMS can streamline your data processes and boost the commercial value of your company's data assets while relieving users throughout the company of tedious and time-consuming data processing duties. The outcome? improved data regulation compliance, a more productive workforce, and better decision-making.   Disadvantages of DBMS Increased Cost. High cost is one of the main disadvantages of DBMS, the cost can be of many types like hardware or software costs, data storage costs, etc. ... Complexity. Database Failure. ... Performance. ... Frequent Updates/Upgrades. ... Huge Size.