Getting Started with Databases
Getting Started with Databases
Items in this lesson
Getting Started with Databases
What do you already know about database components?
Learning Objective
At the end of the lesson you will be able to:
describe the key components of a flat file database and
explain the advantages and disadvantages of
tables,
queries,
reports and
forms.
What Is a Database?
A database is an organised collection of data, stored in a way that makes it easy to search, sort, and manage information.
Flat File Databases
A flat file database stores information in a single table, making it simple to understand but limited for large, complex data.
Table, Record, Field
A table is made up of rows (records) and columns (fields). Each record stores all data about one item; each field holds one type of information.
Tables: Advantages & Disadvantages
Tables are simple to set up and understand but can get large and messy with more data.
Queries: Pros & Cons
Disadvantages
Can be hard to create for beginners and may return wrong data if not set up correctly.
Finds information fast and sorts data easily.
Advantages
Reports: Strengths & Weaknesses
Reports present data in a clear, printable format. They can be time-consuming to design.
Forms: Benefits & Drawbacks
Forms make data entry easy and reduce mistakes, but require careful setup to work well.
Summary Table
Disadvantage Example
Query: finds data quickly. Form: easy entry. Table: simple view. Report: clear output.
Advantage Example
Table: may be messy. Query: hard setup. Report: takes time. Form: needs design.
When to Use Each Component?
Choose tables for storing data, queries for searching, forms for entering, and reports for sharing results.
What Have You Learned About Databases?
Write down 3 things you learned in this lesson.
Write down 2 things you want to know more about.
Ask 1 question about something you haven't quite understood yet.
