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 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.

• Scalability

• Relational databases are designed to be in a

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

• Data Normalization

• Relational databases can easily scale to handle large

  amounts of data and high levels of concurrency.

• Data Integrity

• Relational databases enforce data integrity constraints,

  which help to ensure the accuracy and consistency of data.

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