Term: 1^st Term

Week: 5

Class: Senior Secondary School 2

Age: 16 years

Duration: 40 minutes of 2 periods each

Date:

Subject: Data Processing

Topic:- Data Modeling III

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

Make use of Microsoft access as a Relational database model

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, On-line Materials.

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION	TEACHER’S ACTIVITY	STUDENT’S ACTIVITY
STEP 1 INTRODUCTION	The teacher reviews the previous lesson on the advantages and disadvantages of data models	Students pay attention
STEP 2 EXPLANATION	He discusses and illustrates the fact that Microsoft access is a relational database model. He then lists the data types available in Microsoft Access	Students pay attention and participates
STEP 3 DEMONSTRATION	He shows the students how to create, open, close etc the database	Students pay attention and participate
STEP 4 NOTE TAKING	The teacher writes a summarized note on the board	The students copy the note in their books

NOTE

The following table lists the data types available in desktop databases in

Access 2013 and later versions.

Data Type	Usage	Size
Short Text (formerly known as “Text”)	Alphanumeric data (names, titles, etc.)	Up to 255 characters.
Long Text (formerly known as “Memo”	Large amounts of alphanumeric data: sentences and paragraphs. See The Memo data type is now called “Long Text” for more information on the Long Text details.	Up to about 1 gigabyte (GB), but controls to display a long text are limited to the first 64,000 characters.
Number	Numeric data.	1, 2, 4, 8, or 16 bytes.
Large Number	Numeric data.	8 bytes. For more information, see Using the Large Number data type.
Date/Time	Dates and times.	8 bytes.
Date/Time Extended	Dates and times.	Encoded string of 42 bytes For more information, see Using the Date/Time Extended data type.
Currency	Monetary data, stored with 4 decimal places of precision.	8 bytes.
AutoNumber	Unique value generated by Access for each new record.	4 bytes (16 bytes for ReplicationID).
Yes/No	Boolean (true/false) data; Access stores the numeric value zero (0) for false, and -1 for true.	1 byte.
OLE Object	Pictures, graphs, or other ActiveX objects from another Windows-based application.	Up to about 2 GB.
Hyperlink	A link address to a document or file on the Internet, on an intranet, on a local area network (LAN), or on your local computer	Up to 8,192 (each part of a Hyperlink data type can contain up to 2048 characters).
Attachment	You can attach files such as pictures, documents, spreadsheets, or charts; each Attachment field can contain an unlimited number of attachments per record, up to the storage limit of the size of a database file. Note, the Attachment data type isn't available in MDB file formats.	Up to about 2 GB.
Calculated	You can create an expression that uses data from one or more fields. You can designate different result data types from the expression. Note, the Calculated data type isn't available in MDB file formats.	Dependent on the data type of the Result Type property. Short Text data type result can have up to 243 characters. Long Text, Number, Yes/No, and Date/Time should match their respective data types.
Lookup Wizard	The Lookup Wizard entry in the Data Type column in Design view is not actually a data type. When you choose this entry, a wizard starts to help you define either a simple or complex lookup field. A simple lookup field uses the contents of another table or a value list to validate the contents of a single value per row. A complex lookup field allows you to store multiple values of the same data type in each row.	Dependent on the data type of the lookup field.

HOW TO CREATE A DATABASE IN MICROSOFT ACCESS

Open Access.

If Access is already open, select File > New.

Select Blank database, or select a template.

Enter a name for the database, select a location, and then select Create.

CLOSE A DATABASE

Click the File tab.
Select Close.

UNIQUE IDENTIFIER IN MICROSOFT ACCESS

A unique identifier (UID) is an identifier that marks that particular record as

unique from every other record. It allows the record to be referenced in the

Summon Index without confusion or unintentional overwriting from other

records

HOW TO CREATE FIELDS WITH DATA TYPES

Microsoft Access database fields are created by entering a field name and a

field data type in each row of the field entry area of the database table

window.

The field description is an option to identify the fields purpose; it appears in

the status bar during data entry.

HOW TO SET A FIELD DATA TYPE IN ACCESS

Access opens the table in Datasheet view.

Select the field (the column) that you want to change.

On the Fields tab, in the Properties group, click the arrow in the drop-down

list next to Data Type, and then select a data type.

Save your changes.

SEARCHING IN MICROSOFT ACCESS

Open the table or form, and then click the field that you want to search.

On the Home tab, in the Find group, click Find, or press CTRL+F.

The Find and Replace dialog box appears, with the Find tab selected.

In the Find What box, type the value for which you want to search.

SORTING IN MICROSOFT ACCESS

Click the Home tab on the Ribbon, and locate the Sort & Filter group.

Sort the field by selecting the Ascending or Descending command.

The table will now be sorted by the selected field.

MODIFYING IN MICROSOFT ACCESS

To make some changes;

Click Settings> Customize in Access in the upper right corner of your browser window.

Note: If you don’t see Customize in Access, you either don’t have

permission to customize the app, or the app has been locked.

Click Openwhen prompted by the browser.

If you have Access installed, it’ll open and display the design environment.

On the left side of the screen, click the table caption name in the Table Selector whose view you want to change, and then click the view that needs changing.
Click the Editbutton in the middle of the view.

Now you can start changing the design of the view. Some of the things you can do here:

Move, resize, or delete controls. (Note that deleting a control on a view doesn’t delete the underlying data—just it’s display on this view).
Add controls from the ribbon: Click a control in the Controls gallery and Access places the new control in the view.

Add controls from the Field List: Double-click or drag a field into the view.
Change the properties of a control by selecting it and clicking the Data or Formatting buttons that appear next to the control.

Add a macro to a control by selecting it and clicking the Actions button that appears.
Add custom action buttons to the Action Bar at the top of the view.

Once you’re done making changes, click Save and then Home > Launch App to see your design changes in your browser.

App-level changes

Rename a view's caption, duplicate, or delete a view by clicking its name in the View Selector, then clicking the Settings/Actions button that appears:

Add a new view by clicking the Add button (+) to the right of the View Selector.

Import data from an Access database into an Access web app by clicking Home > Table, then clicking the type of data to import under Create a table from an existing data source.

HOW TO CREATE REPORT

On the Create tab, in the Reports group, click Report.

Access builds the report and displays it in Layout view.

For more about viewing and printing your report, see the section View, print,

or send your report as an e-mail message.

CLASS ACTIVITY: Create a database inputting any data type of your choice. Modify it to personal preference, save and generate a report

EVALUATION: 1. Enumerate four data types and discuss their usage

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively

Lesson Notes By Weeks and Term - Senior Secondary 2