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
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.

Behavioural objectives
By the end of the lesson, students should be able to:
- explain what a data model is and name its basic parts;
- edit the data type and format of a field in Datasheet view and Design view;
- delete and rename a table;
- create and save a form, with or without the Form Wizard;
- create a query using the Query Wizard;
- 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.
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
- Click the field you wish to define.
- Click the Datasheet tab on the Ribbon.
- Click the down arrow next to the data type.
- Choose the type of data that will be entered into the field.
To edit the format of a field
- Click the field you wish to define.
- Click the Datasheet tab on the Ribbon.
- Click the down arrow next to the format.
- Choose the format you want, such as a date style.
To edit the data type in Design view
- Click Design view.
- Click the field name you wish to define or create (for a new field).
- Click the Data Type.
- Choose the appropriate data type.
- 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
- Open the desired database by clicking the Microsoft Office button and clicking Open.
- Right-click on a table and choose Delete.
To rename a table
- Open the desired database by clicking the Microsoft Office button and clicking Open.
- Right-click on a table and choose Rename.
- 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.
Creating a form
- Open the Navigation pane.
- Click the table or query on which you want to base your form.
- Activate the Create tab.
- 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.
- Click the Save button on the Quick Access toolbar.
- Type the name you want to give the form.
- 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.
- On the Create tab, click the More Forms down arrow.
- Click Form Wizard.
- Choose the Tables/Queries that you wish to have on the form.
- Choose the fields you wish to have on the form.
- Click Next.
- Choose the layout for the form.
- Click Next.
- Choose a style.
- Click Next.
- Create a title for the form.
- Choose whether you want to open the form to view it or modify the form’s design.
- 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.
- Click the Create tab.
- Click the Query Wizard button in the Other group.
- Choose the type of query you wish to run.
- Click OK.
Choosing the fields to include from each table
- Click the Tables/Queries down arrow and choose a table.
- Select the fields you want and move them to the Selected Fields box.
- Repeat for each table that has fields you need.
- Click Next.
Finishing the query
- Type in a title for the query.
- Click Finish.
- 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
- Click the Blank Report button on the Create tab.
- Click the Add Existing Fields button.
- From the field list, click and drag the fields to the report.
Creating a report using the Report Wizard
- On the Create tab, click the Report Wizard button.
- Choose the Tables/Queries that you wish to have on the report.
- Choose the fields you wish to have on the report.
- Click Next.
- Choose the sort order for your report.
- Choose the layout for the report.
- Click Next.
- Choose a style.
- Click Next.
- Create a title.
- Choose whether you want to open the report to view it or modify the report’s design.
- Click Finish.
Evaluation
- State the steps to edit the data type of a field in Design view.
- How do you rename a table?
- What is a query?
- List the steps to save a form after creating it.
- What is the use of a report?
Assignment
- 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

