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

Editing data type in fields

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

 To edit data type in a 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 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 a new field).
3. Click the Data Type.
4. Choose the appropriate Data Type.
5. Format the field in the Field Properties dialogue 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.

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

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 detailed report displays all of the selected records. Reports are a means to view and analyze a large amount of data. 

You can use the report wizard or create a custom report that meets your specific needs.

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 open the form to view it or modify the form’s design
12. Click Finish