MSA Basics

It is a collection of data that is stored in a computer system.

• Microsoft Access

• Data

• Database

• Forms

Non-numerical data plays a significant role in almost any database, and it is important to be able to sort and analyze it.

• TRUE

• FALSE

Match the following Advantages of Relational Database

• Data Normalization

• Relational databases enforce data integrity constraints,

  which help to ensure the accuracy and consistency of data.

• Scalability

• Relational databases are designed to be in a

  normalized form, which helps to minimize data redundancy and improve data consistency.

• Data Integrity

• Relational databases can easily scale to handle large

  amounts of data and high levels of concurrency.

• Data Access

• Relational databases provide powerful querying

  capabilities through SQL (Structured Query Language) which is a

  standard language for accessing and manipulating data in a relational database.

This relational database refer to highly flexible, allowing for the

creation of new tables, columns, and relationships as needed.

• Flexibility

• Portability

• Ease of use

• Reliability

Most relational databases are easy to use and have a wide

range of support and resources available, which makes it easy

for developers to learn and use them. Which of the following relational database this refers to?

• Flexibility

• Portability

• Ease of use

• Reliability

This relational database proven to be highly reliable

and have been in use for decades, which means that many bugs have

been discovered and fixed over time.

• Flexibility

• Portability

• Ease of use

• Reliability

This relational database are highly portable, meaning that they

can be easily migrated to different platforms and hardware.

• Flexibility

• Portability

• Ease of use

• Reliability

It is a relational database management system (RDBMS) developed by Microsoft.

• Microsoft Access

• Data

• Database

• Objects

It allows users to create and manage tables, forms, queries, and reports

using a graphical user interface (GUI) rather than writing code.

• Microsoft Access

• Data

• Database

• Objects

What are the four (4) objects of MS Access?

• Tables

• Sheets

• Forms

• Queries

• Reports