Data Modelling II

Back to: DATA PROCESSING SS 2

 

Welcome to class! 

In today’s class, we will be talking more about data modelling. Enjoy the class!

Data Modelling II

Editing data type in fields

When creating tables, you should define the data types of the table to the most closely match the type of data that will be entered in the field.

To edit data type in a data sheet 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 data of the format:

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.

To edit data type in the design view:

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

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 Delete.
3. Type in the new name.

Evaluation

1. Write down steps on how to perform the following on MS Access; to edit data-type, delete a table and to rename a table.
2. Write down steps on how to load MS Access.

Creating forms

Forms allow 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 the 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 groups
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 a picture of query wizard

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

Creating a 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 a 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.
2. List five (5) data-type.

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 the 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 on 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

 

In our next class, we will be talking more about Data Modelling.  We hope you enjoyed the class.

Should you have any further question, feel free to ask in the comment section below and trust us to respond as soon as possible.

Ready to make school management and growth easy? Book your free onboarding session now

Get more class notes, videos, homework help, exam practice on Android [DOWNLOAD]

Get more class notes, videos, homework help, exam practice on iPhone [DOWNLOAD]