Microsoft Access, Database Basics 01

​MS Access 101

By A Mamazhusup

Multiple Choice

What is DATA?

• A computer program

• A type of electronic game

• Facts or information that can be stored and processed

• A device for storing files

Multiple Choice

What is a Database?

• An organized collection of data stored electronically

• A program for browsing the internet

• A table in a math book

• A place to store the clothes

Multiple Choice

What is a Record in a Database?

• A recorded song

• A group of fields about one thing (like one student)

• An award certificate

• An educational video

Multiple Choice

What is a Field in a Database?

• A football field

• A place in memory

• A button on the keyboard

• One type of information in a table (like "Name" or "Age")

Multiple Choice

What is a Table in a Database?

• A table is a random assortment of data without structure.
• A table is a single row of data in a database.
• A table is a structured collection of data in rows and columns in a database.
• A table is a collection of unrelated files in a database.

Multiple Choice

What is a Query?

• A query is a request for data or information.
• A query is a method for sorting data.
• A query is a programming language.
• A query is a type of database.

Multiple Choice

What is a Primary key?

• A primary key is a temporary identifier for a record in a database.
• A primary key is a duplicate identifier for multiple records in a table.
• A primary key is a unique identifier for a record in a database table.
• A primary key is an optional field in a database record.

Multiple Choice

Why we need a Primary key in a table?

• A primary key helps in sorting data in a table efficiently.
• We need a primary key to allow duplicate entries in a table.
• We need a primary key to uniquely identify each record in a table and maintain data integrity.
• A primary key is used to group similar records together.

Single, One Table, Not Relational table

✅ 1. If you try to store everything in ONE table…

​Book Title	​Author	​Student Name	​Taken Date	​Return Date
Harry Potter	J.K. Rowling	Aida	10-Jan	—
Harry Potter	J.K. Rowling	Bek	12-Feb	20-Feb
SynganKylych	T.Kasymbekov	Sezim	1-March	—

If one row says:

• “Harry Potter”

• “J.K. Rollwing” (spelling mistake)

Now your system thinks these are two different books.

​Errors happen easily

• “Harry Potter” stored many times

• “Aida” stored many times

• If you fix a spelling (Aida → Ayda), you must update many rows.

A. Repetition

❌ Problems