Elements and Performance Criteria
- Create database
- 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
- Save and close down database to storage area
- Customise basic settings
- Create reports
- Create forms
- Retrieve information