Database Modelling: Creating a form, Query and Report

Creating Forms

Forms allows you to enter, edit or display data. They are based on tables. With forms, you can choose the format and arrangement the fields will take or will be displayed.

To create 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

After you create a form, you can save it. You can also 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.

Form Wizard

You can create forms with the help of a form wizard

On the create tab, click the more forms down arrow.

1. Click Form Wizard
2. Choose the Table/ Queries that you wish to have on the form
3. Choose the field you wish to have on the forms
4. Click Next
5. Choose the layout for the form
6. Click Next
7. Choose Style
8. Click next
9. Create a title for the form
10. Choose whether you want to open the form to view it or modify the form’s design
11. Click finish

EVALUATION

(1) What is a form?

(2) How would you create a form?

Creating Queries

A query allows you to select and filter data from multiple tables. Queries  can be saved and utilized as often as you need them.

Creating using Query Wizard

The Query Wizard walks you through the steps to set up a query. To run a query using the query wizard

1. Click the create tab
2. Click the query Wizard button under other group
3. Choose the type of query you wish to run
4. Click OK

To choose the field you wish to include from each table

1. To select fields from different tables, click the Tables/Queries down arrow
2. Click OK

To insert picture of query wizard

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

CREATING REPORT

Reports organize and summarize data for viewing online or for printing. A detail report displays all of the selected records. Reports are a means to view and analyse large amount of data. You can use the report wizard or create a custom report that meets your specific need.

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 using Report Wizard

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

GENERAL EVALUATION

1. State the operations that can be performed in a database.
   1. List five (5) data-type.

READING ASSIGNMENT

Data Processing for Senior Secondary Education by HiiT Plc. Chapter Two, pages 58 – 63

WEEKEND ASSIGNMENT

1. Another name for field type is known as ______ (a) File type (b) Name type  (c) Record type            (d) Data type
2. Another name for unique identifier is known as ___ (a) Key (b) Data (c) Field(d) Record

3. ____ is an attribute or field that can be used to identify a record in a database table or file. (a) Data            (b) Field (c) Key (d) Table
4. ____ is used to design a database in a computer. (a) Database package (b) Graphics package (c) Spreadsheet package (d) Word Processing package
5. ____ model organizes data using two fundamental constructs, called records and sets. (a) Hierarchical            (b) Relational   (c) Network      (d) Optical

SECTION B

1. Define database Model.
   1. List and explain types of database Model.
   1. All fields are set to accept a particular type of input, list and explain the types of data types you know.