4. Database Development

This is a practical unit covering the basic theory, creation and use of a single-table database and a simple relational database involving two tables in a one-to-many relationship. You will start by looking at an existing single-table database, learning how to add records and make queries. In subsequent lessons you will create

• a flat-file or two-table relational database of your own, using suitable field types and adding in appropriate validations

• an input form with help text, combo boxes and list boxes

• queries and a report using data from one or both tables

• a front end menu for your application linking to the database input form and report

MS Access is used in this unit.

1. introduction to databases

Understand what a database is and why it is useful in many different applications
Learn what is meant by a flat file database, record, field
Enter data into a database in datasheet view
Create queries using multiple criteria to answer questions relating to a given flat file database
Use different operators such as >=, BETWEEN, AND, OR, NOT and the wildcard * in queries

LESSON PRESENTATIONWATCH THIS LESSONVIDEO: HOW TO COMPLETE THE GOTCHA DATABASE TASKGOTCHA DATABASE (Please download and save to your My Documents) GOTCHA CRIME SCENARIOS (You will be using Queries to solve the Crimes)

2. creating a database table

Design a database with one or two tables
Create the database structure
Use suitable field types including numbers and text
Add validations and validation text to at least one field
Add records to the table and test the validations

LESSON PRESENTATION WATCH THIS LESSONHow to set up a database videoHow to make a relational database videoSample Data (pupils).csvSample Data (school).csv

3. queries

Note examples of queries on websites
Use complex criteria to select records
Create a parameterised query
Sort the data on one or more fields
Choose which fields to display in the Results table
Add a calculated field

LESSON PRESENTATION WATCH THIS LESSONHow to create a query in Access video

4. input forms

Discuss examples of forms on websites
Create a new form from a table or query
Make the form user-friendly by adding help text, combo boxes, etc
Sort and navigate tables using a form
Find, enter, modify and delete records using a form

LESSON PRESENTATION WATCH THIS LESSONHow to create a form in Access video

5. creating a report

Create a report based on a query
Edit the layout of the report
Create a consistent design

LESSON PRESENTATION WATCH THIS LESSONHow to create a Report in Access video

6. Finishing and testing

Create and test a menu from which the user can select the various functions
Receive and respond to peer feedback
Make modifications where necessary
Complete the assessment portfolio

LESSON PRESENTATION

Page updated

Google Sites

Report abuse