DATABASE

 DataBase

A. what is a database?

Is an organized collection of data, generally stored and accessed electronically from a computer system. databases are more complex they are often developed using formal design and modeling techniques.

The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data.

B. What type of software is Microsoft office excel

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

C. What type of software is Microsoft office excel.

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.

D. Think of at least two difference between access and excel

Excel is extensively used by financial analysts as it is used for the analysis of data and draw insights from it. Excel has built-in rows and columns which help in referencing when applied formula on excel

Access is used as a part of Relational Database Management Systems. Access is quite helpful in the operations of small busine
sses. Access allows you to build relationships between different data sources and tables in order to perform complex queries.