All About Databases and Microsoft


All About Databases and Microsoft

A. Database: A structured collection of data organized for efficient storage, retrieval, and analysis. It's used to manage information for various purposes.

B. Microsoft Office Excel: Spreadsheet software used for creating, organizing, and analyzing data in tabular form. It's commonly used for tasks like financial analysis and data visualization.

C. Microsoft Office Access: Relational database management system used to create and manage databases with structured data. Access is useful for tasks like managing inventory and creating small to medium-sized databases.

D. Differences between Access and Excel:

Data Structure and Purpose: Excel focuses on spreadsheet tasks and calculations, while Access is for managing relational databases with structured tables and relationships.Complexity and Functionality: Access offers more advanced features for creating queries, forms, and reports, and enforcing data integrity compared to Excel's simpler capabilities. 


Comments

Post a Comment

Popular posts from this blog

SAT3D Portfolio

Image
SAT3D: About Me My name is Luke Satriani Felarca.  I am a 3D artist and multimedia creator. I specialize in asset creation, sculpting, animation, and editing. Currently in 3rd year college. Always learning. Always improving. Skills 5 years of 3D modeling experience 3D sculpting (Blender, ZBrush) Short 3D animations Clean topology and optimized assets 2 years of video editing (Microsoft Clipchamp) 2 years of Photoshop CC 2019 3 years of Canva for visual design 3D & Design Editing & Graphics Software Proficiency Blender ZBrush Microsoft Clipchamp Photoshop CC 2019 Canva Education College: 3rd year (Ongoing) Field: Bachelor of Science in Entertainment and Multimedia Computing
Read more

ER Diagram for a Bank Database

Image
In a bank database, the Bank entity manages multiple Branches, each Branch has multiple Accounts, each Account is owned by a Customer, and each Customer may have a relationship with one or more Employees of the bank.  Entity: An entity represents a real-world object or concept in the database, like "Customer" or "Account." Attributes: Attributes are the characteristics or properties of entities, such as "CustomerID" or "Address." Relationships: Relationships define how entities are connected or related to one another within the database. Degree of Relationships: The degree of a relationship refers to how many entities are involved in that relationship; most often, it involves two entities at a time. Connectivity of Relationships: Connectivity specifies how entities are directly linked in a relationship, like "one-to-one," "one-to-many," or "many-to-many." Cardinality of Relationships: Cardinality indicates the number...
Read more

Software Proficiency

Image
Software Proficiency Back to Main           I use Blender mainly for 3D asset creation, especially props and environments, where clean topology and optimization matter most. For character sculpting, I rely on ZBrush—it gives me better control for high-detail organic models. When sculpting, I often switch between Blender and ZBrush to balance flexibility and precision.         For video editing, I use Microsoft Clipchamp to cut, arrange, and sync my scenes. Once the base edit is done, I refine visuals using Canva, especially for overlays or text. In photo editing, I blend Photoshop CC 2019 and Canva depending on the task—Photoshop for advanced corrections, and Canva for faster layout work.
Read more