How do you manage a database?





INTRODUCING : EXCEL & ACCESS


WHAT IS A DATABASE? 

It is a collection of information organized and presented to serve a specific purpose.

WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? 

Microsoft Excel is a spreadsheet that features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). 

WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? 

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

WHAT ARE THE DIFFERENCES BETWEEN ACCESS AND EXCEL?

Excel is a spreadsheet software program that is traditionally used to manage numerical information, it is used to build models for analyzing data, write simple and complex formulas to perform calculation and present data in a variety of charts. Meanwhile Access is an RDBMS program that can link and extract information from multiple tables to answer specific questions, its tables are designed for complex querying in relation to data stored in other tables.





Comments

Post a Comment

Popular posts from this blog

Demystifying Software Requirements: What You Need to Know

Image
What are Software Requirements? Software requirements can be envisaged as the blueprint of any development project. They specify exactly what the software should do and how it should do it, thereby ensuring that the final product meets the needs and expectations of its users. Types of Software Requirements: Business Requirements :  These revolve around the general objectives of the organization or the customer. These provide information related to the general features, rather than detailed aspects. User Requirements : These are the specifications of what the users need to perform. They ensure that the system will actually meet the needs of the users. Functional Requirements : Everything that the system is to do. In a point-of-sale system, handle sales transactions, inventory tracking, and report generation. Non-Functional Requirements : These are more in the line of how the system performs. This involves things like how many users it can handle simultaneously, whether it is secure,...
Read more

Building Blocks of Success: Understanding Construction, Management, and Agile Practices

Image
Construction: Art and Science in Building While construction is indeed art and science in transforming a blueprint into reality, ideas and requirements are transformed into ready-to-use software applications in the process of software development. The process is as follows: Planning : Just like construction projects, general software development involves planning-as it defines the project goals, scope, and requirements for creating an overall roadmap. Designing : Software architecture and design work similarly like the blueprints used in construction in presenting a framework and functionalities before actual coding begins. Building : Coding-actually the building process in software, where the developers get together and bring it to life just like engineers and laborers do to construct a building. What is Management? Management is another integral part of completing projects with success in software development. This comprises: Planning and Organizing : Project managers put tog...
Read more

Billie Eilish Music | Music & Entertainment

Billie Eilish is a unique singer for she had her own style in clothes, her own music concept, and she shows who she really was. Her music genre incorporates pop, dark pop, electropop, emo pop, experimental pop, goth-pop, indie pop, teen pop, and alt-pop. At age 17, she became the youngest female artist in UK history to score a number-one album and is regarded by various multimedia outlets as the "Queen of Gen-Z Pop".  I became a fan of her since she released the music video of "Bad Guy" in 2019, the song is about relationship power dynamics where woman would let his man control her but when he betrayed her, she'll make him pay. This was scary and ironic as Billie's vocal is angelic but expresses threat and disinterest.  In 2021, she released the "Happier Than Ever", that receive several awards and nomination such as the Best Pop, Best Direction, Best Visual Effects and Song of the Year at the 2022 ceremony. The song is all about how she got away fr...
Read more