DATABASE, EXCEL AND ACCESS

 


A. WHAT IS A DATABASE?

 



A database is a systematic collection of data. Examples of it are Telephone directory, Log-in / log-out, Record book and etc. 


B. WHAT TYPE OF SOFTWARE IS MICROSOFT EXCEL?



Microsoft Excel is a spreadsheet software created by Microsoft. It also allows users to create their own diagrams, tables to input their data, charts, and databases as well.

 

C. WHAT TYPE OF SOFTWARE IS MICROSOFT  OFFICE ACCESS?

 

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

 

D. THINK OF ATLEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL.

 While both of these software can be used for database, Access is mainly for easier data storing as it's capacity for storing data is higher than excel. It can store large objects such as images and documents. Other than that, Access is also relational, meaning it has tools to create many to many or one to many relationships between the user's tables. On the other hand, excel can create graphical representation of data. Unlike access, excel is non-relational as all of the information has only a one to one relationship.

 



 

Comments

Post a Comment

Popular posts from this blog

FUNCTIONS, ADVANTAGES, DISADVANTAGES OF DBMS

Image
  DATA DEFINITION In a DBMS, data is what's being dealt with and data definition is the ability to clearly define what is stored in the tables of a database. As an example, SQL is utilized in order to instruct how to store the data.    DATA MANIPULATION   This means that the existing data within a DBMS can be easily manipulated. Modification is easy as users can insert, delete and update their database. DATA SECURITY AND INTEGRITY Enhanced protection is ensured in a DBMS. It prevents any type of unauthorized access and data alteration. On the other hand, integrity is the validation and it helps maintain the overall accuracy of the system's structure. DATA RECOVERY AND CONCURRENCY   System failures can be unavoidable and DBMS has the ability to retrieve the lost data. Other than that, concurrency means that it can be accessed at the same time as multiple users can view it.  DATA DICTIONARY  A data dictionary primarily consists information regarding the ...
Read more