Microsoft Access, Database Basics 01
Presentation
•
Computers
•
9th - 12th Grade
•
Practice Problem
•
Easy
A Mamazhusup
Used 1+ times
FREE Resource
4 Slides • 8 Questions
1
MS Access 101
By A Mamazhusup
2
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
3
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
4
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
5
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")
6
Multiple Choice
What is a Table in a Database?
7
Multiple Choice
What is a Query?
8
Multiple Choice
What is a Primary key?
9
Multiple Choice
Why we need a Primary key in a table?
10
Single, One Table, Not Relational table
11
✅ 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 | — |
12
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
MS Access 101
By A Mamazhusup
Show answer
Auto Play
Slide 1 / 12
SLIDE
Similar Resources on Wayground
10 questions
Adobe Photoshop Shortcut Keys
Presentation
•
9th - 12th Grade
10 questions
Penjumlahan dan Pengurangan Aljabar
Presentation
•
12th Grade - University
10 questions
Graphing Linear Systems
Presentation
•
9th - 12th Grade
13 questions
Hacking
Presentation
•
9th - 12th Grade
10 questions
Python Data Types
Presentation
•
9th - 12th Grade
9 questions
Programming
Presentation
•
9th - 12th Grade
10 questions
Computer Network
Presentation
•
9th - 12th Grade
10 questions
Karyotypes
Presentation
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
HCS SCI 03 Summer School Review 4
Quiz
•
3rd Grade
11 questions
HSMS - Standard Response Protocol
Quiz
•
6th - 8th Grade
16 questions
1.1-1.2 Quiz Review
Quiz
•
9th - 12th Grade
12 questions
Exponent Expressions
Quiz
•
6th Grade
20 questions
Adding and Subtracting Integers
Quiz
•
6th - 7th Grade
11 questions
Northeast States
Quiz
•
3rd - 4th Grade
10 questions
Characterization
Quiz
•
3rd - 7th Grade
10 questions
Common Denominators
Quiz
•
5th Grade