Skip to content

Data Modeling – SS2 Data Processing Lesson Note (First Term)

Lesson note at a glance

Class
SS2
Subject
Data Processing
Term
First Term
Reading time
6 min
Start of this note, 5 of 8
Take this term’s notes offline
Reading here is free. Download all 8 SS2 Data Processing First term notes as PDF to print and Word to edit.
Download all three terms, ₦2,000
Instant download. Secure payment by Paystack. Card, bank transfer, USSD or OPay. Payment stuck? WhatsApp us.

Data modelling in Microsoft Access is the process of organising data into tables, then using forms, queries and reports to enter, select and present that data.

Advertisement

Behavioural objectives

By the end of the lesson, students should be able to:

  1. explain what a data model is and name its basic parts;
  2. edit the data type and format of a field in Datasheet view and Design view;
  3. delete and rename a table;
  4. create and save a form, with or without the Form Wizard;
  5. create a query using the Query Wizard;
  6. create a report using a blank report or the Report Wizard.

What is a data model?

A data model is a plan that shows how data is organised, stored and linked in a database.

  • Table: a grid that stores data about one subject, such as Students or Teachers.
  • Field: one column in a table, holding one kind of detail, such as Surname.
  • Record: one row in a table, holding all the details about one item, such as one student.
  • Primary key: a field whose value is different for every record, such as an admission number.
  • Relationship: a link between two tables through a matching field.

What are the main database objects used in this lesson?

There are four main database objects used here: tables, forms, queries and reports.

  • Table: stores the data.
  • Form: gives a screen for entering and viewing data one record at a time.
  • Query: selects and filters data from one or more tables.
  • Report: organises and summarises data for viewing online or for printing.
Object Main use Example
Table Store data List of all students in SS2
Form Enter and view records Screen for adding a new student
Query Select and filter data Only students who offer Biology
Report Present data for printing Printed class list

How do you edit the data type of a field?

To edit a data type, choose the type that matches, as closely as possible, the data that will be entered in the field.

Advertisement

What are common data types?

  • Short Text: letters, digits and symbols in small amounts, such as names and phone numbers.
  • Long Text: longer text, such as comments or notes.
  • Number: numeric values used in calculations, such as scores.
  • Currency: money values, such as school fees in naira.
  • Date/Time: dates and times, such as date of birth.
  • AutoNumber: a number Access adds automatically to each new record.
  • Yes/No: one of two values, such as present or absent.

To edit the data type in Datasheet view

  1. Click the field you wish to define.
  2. Click the Datasheet tab on the Ribbon.
  3. Click the down arrow next to the data type.
  4. Choose the type of data that will be entered into the field.

To edit the format of a field

  1. Click the field you wish to define.
  2. Click the Datasheet tab on the Ribbon.
  3. Click the down arrow next to the format.
  4. Choose the format you want, such as a date style.

To edit the data type in Design view

  1. Click Design view.
  2. Click the field name you wish to define or create (for a new field).
  3. Click the Data Type.
  4. Choose the appropriate data type.
  5. Format the field in the Field Properties dialogue box.

How do you delete or rename a table?

You delete or rename a table by right-clicking it and choosing Delete or Rename.

To delete a table

  1. Open the desired database by clicking the Microsoft Office button and clicking Open.
  2. Right-click on a table and choose Delete.

To rename a table

  1. Open the desired database by clicking the Microsoft Office button and clicking Open.
  2. Right-click on a table and choose Rename.
  3. Type in the new name.
  • Caution: deleting a table removes all its records, so check before you delete.

What is a form and how do you create one?

A form is a database object that lets users enter, view and edit records one at a time.

Advertisement

Creating a form

  1. Open the Navigation pane.
  2. Click the table or query on which you want to base your form.
  3. Activate the Create tab.
  4. Click Form in the Forms group.

Saving a form

After you create a form, you can save it, and you can open a saved form at any time.

  1. Click the Save button on the Quick Access toolbar.
  2. Type the name you want to give the form.
  3. Click OK. You can access the form by clicking the Navigation pane.

Using the Form Wizard

The Form Wizard creates a form by guiding you through a series of choices.

  1. On the Create tab, click the More Forms down arrow.
  2. Click Form Wizard.
  3. Choose the Tables/Queries that you wish to have on the form.
  4. Choose the fields you wish to have on the form.
  5. Click Next.
  6. Choose the layout for the form.
  7. Click Next.
  8. Choose a style.
  9. Click Next.
  10. Create a title for the form.
  11. Choose whether you want to open the form to view it or modify the form’s design.
  12. Click Finish.

What is a query and how do you create one?

A query is a database object that selects and filters data from one or more tables.

  • Reuse: queries can be saved and used as often as you need them.
  • Example: a query can list only the students who scored above 50 in Data Processing.

Creating a query using the Query Wizard

The Query Wizard walks you through the steps to set up a query.

  1. Click the Create tab.
  2. Click the Query Wizard button in the Other group.
  3. Choose the type of query you wish to run.
  4. Click OK.

Choosing the fields to include from each table

  1. Click the Tables/Queries down arrow and choose a table.
  2. Select the fields you want and move them to the Selected Fields box.
  3. Repeat for each table that has fields you need.
  4. Click Next.
Advertisement

Finishing the query

  1. Type in a title for the query.
  2. Click Finish.
  3. The query will be displayed.

What is a report and how do you create one?

A report is a database object that organises and summarises data for viewing online or for printing.

  • Detailed report: displays all of the selected records.
  • Use: reports help you view and analyse a large amount of data.
  • Methods: use the Report Wizard or create a custom report that meets your needs.

Creating a blank report

  1. Click the Blank Report button on the Create tab.
  2. Click the Add Existing Fields button.
  3. From the field list, click and drag the fields to the report.

Creating a report using the Report Wizard

  1. On the Create tab, click the Report Wizard button.
  2. Choose the Tables/Queries that you wish to have on the report.
  3. Choose the fields you wish to have on the report.
  4. Click Next.
  5. Choose the sort order for your report.
  6. Choose the layout for the report.
  7. Click Next.
  8. Choose a style.
  9. Click Next.
  10. Create a title.
  11. Choose whether you want to open the report to view it or modify the report’s design.
  12. Click Finish.

Evaluation

  1. State the steps to edit the data type of a field in Design view.
  2. How do you rename a table?
  3. What is a query?
  4. List the steps to save a form after creating it.
  5. What is the use of a report?

Assignment

  1. Write out the steps to create a form using the Form Wizard, then the steps to create a report using the Report Wizard.

This term's Data Processing topics

SS2 First Term · 8 topics

  1. Database Management System I
  2. Database Management System II: How to Create Database
  3. Data Model
  4. Data Model II: Types of Data Modelling
  5. Data Modeling
  6. Data Modeling II: Standard Data Model & Examples
  7. Normalization
  8. Entity-Relationship Models
Advertisement

Lesson Notes for Other Classes

Print it or edit it in Word

Every note is free to read online. A PDF or Word copy of one subject costs ₦1,000 for one term, or ₦2,000 for all three terms.

Sign in first, then choose your class and subject at checkout.