Cyber InfoTechnology

WEEK 08

REFLECTION IN THIS WEEK

        This week I have learned about the application of database by using Microsoft Access such as: Creating tables, entering data, relationship of the tables, creating queries, creating forms wizard as well as report wizard by using Microsoft access. We did an activity by using Microsoft access and because of this I have learned how to use Microsoft access and the use of Microsoft Access. 

Apply relational database design approach and implement it using Microsoft Access or other DBMS

Relating Two Tables

Click on the link for Microsoft Access online tutorial on relating two tables in a database.

http://office.microsoft.com/en-us/access-help/create-relationships-for-a-new-database-RZ101772998.aspx

Timeframe: 35 minutes

Create queries for a new database

Building and using queries in Microsoft Access.

Click on the link for Microsoft Access online tutorial on creating queries.

http://office.microsoft.com/en-us/access-help/create-queries-for-a-new-database-RZ101772999.aspx

Timeframe: 35 minutes

Create forms

Click on the link for Microsoft Access online tutorial on how to create forms for database

http://office.microsoft.com/en-us/access-help/create-forms-for-a-new-database-RZ101773001.aspx

Timeframe: 35 minutes

Create reports

Click on the link for Microsoft Access online tutorial on how to create reports for a database.

http://office.microsoft.com/en-us/access-help/create-reports-for-a-new-database-RZ101773004.aspx

Timeframe: 35 minutes