Create and Develop Simple Databases

Duration24 hours

Description

This course is recommended for people wanting to create a simple database to enter and extract data and create reports.

Short Course Delivery Locations Help…

LocationApplication
Online Enrol Now
$249.00 GST inc
Assessment available in ICTICT210 for an additional fee.
Continuous enrolments
Enquire7210 3815
No refunds apply unless the course is cancelled by TAFE SA. International students on a Student visa (subclass 500) are not eligible to undertake short courses.

Skills Covered

Create and Develop Simple Databases
- Open a database application and design a two-table, simple relational database incorporating basic design principles
- Develop a table with fields and attributes according to database usage, as well as user requirements
- Create a primary key and establish an index for each table
- Modify table layout and field attributes as required
- Create a relationship between the two tables
- Add and modify data in a table according to information requirements
- Add and delete records as required
- Open and view different toolbars
- Format font as appropriate for the purpose of the database entries
- Design reports to present data in a logical sequence
- Modify reports to include or exclude additional requirements
- Use a wizard to create a simple form
- Open existing database and modify records through a simple form
- Rearrange objects within the form to accommodate information requirements
- Access existing database and locate required records
- Create simple query and retrieve required information
- Develop query with multiple criteria and retrieve required information
- Select data and display appropriately