Database Management-1

Database Management - Chapter 20: MS Access 🎉

Introduction

Overview of MS Access for managing databases.

Page 1: Database Basics 📚

Intro to MS Access and its applications.

Page 2: Data Analysis 🔍

Analyze:

• Data Types

• Number of Records

• Number of Fields

• Examples: Doctor ID, Patient ID, Name, Phone, D.O.B

Page 3: Success Criteria 🚀

Key Activities:

• Create & save a database.

• Create a table & set its data types.

• Enter records in datasheet view.

Learning Objectives:

• Understand how to create databases and tables.

• Set fields and data types.

• Enter and save data.

Page 4: Creating Databases & Tables 🛠

• Database Creation: Define the type of data to store.

• Data Input: Add daily business information to tables.

Page 5: Challenge - Create a Database 🎨

Activity: Open MS Access, create, and save a database named "Themepark."

Page 6: Challenge - Create a Table 🏰

Activity: In the Themepark database, make and save a table called "Visitors."

Page 7: Visitors Table Structure 📝

• VisitorID: AutoNumber

• FirstName: Short Text

• Surname: Short Text

• DateOfBirth: Date/Time

• Gender: Short Text

Page 8: Challenge - Setting Data Types 🛡

Activity: Input data into the "Visitors" table and confirm the data types.

Page 9: Data Entry into the Table 🖊

Activity: Utilize table tools to input data and ensure all records are saved correctly.

Page 10: Entering Data into the Table 🎈

Activity: Fill the "Visitors" table with all 10 records and automatically generate VisitorID.

Page 11: Understanding Assessment ✔

Activity: Complete the Quizizz to test your knowledge of the material.

Page 12: Learning Reflection 🌟

Key Learnings:

• Ability to create databases and tables.

• Entering data into records.

• Understanding of flat-file databases.