Create+and+use+databases+-+BSBITU301A

=BSBITU301A - Create and use databases =





On successful completion of this unit you should have the knowledge and skills required to create simple two-table relational databases with reports and queries, for the storage and retrieval of information. Specifically you will: [|Learn the structure of an Access database]
 * Unit Purpose**
 * Create a simple [|database]
 * Create reports and queries
 * Use database.

Your result will be recorded and reported to you as Competent or Not yet Competent.
 * Reporting of assessment outcomes**

This unit describes the performance outcomes, skills and knowledge required to create simple two-table relational databases with reports and queries, for the storage and retrieval of information. You will need to provide evidence of the following:
 * Requirements to successfully complete this unit of competency**
 * creating simple databases and queries
 * manipulating data using queries
 * formatting data into a final version.

__Exercise 1__ [|Tutorial 1] Build your first database

Do not attempt [|Make the switch to Access 2010]. It's not necessary for us.

Welcome to Access 2007
media type="youtube" key="giIeRZOIpt4" height="344" width="425"

Access 2007: Entering and Editing Data
media type="youtube" key="CKElUIiwe3U" height="344" width="425"

__Exercise 2__ Complete this [|tutorial] © [|Lynchburg College]. The exercise will be collected electronically when you have finished.