Module 05 | Maintain Databases

Lecture Notes

- Created Table should contain the correct / given Databases name, table name with field names.

- Field type, field size and Primary keys of the table should match the given instructions.

- The database design documentation should be matched with the given instructions.

- Key fields should be identified and created according to the design document.

- Relationships among fields should be created as expected.

- The structure of the table should be modified according to the database and user requirement.

- Data types and field sizes should be matched with the given data set.

- Table should adhere to the validation rules as specified in the database.

- The form should be created according to the design documentation.

- The data should be stored in to the tables as expected.

- The query should be created according to the design documentation.

- The output of the formula should be matched with the expected results.

- The query results should be validated according to the requirement.

- The report should be created according to the requirement.

- The report layout (arrangement of data fields, headings) should be changed as per the requirement).

- The preview of the report should be as expected.

- The reports should be previewed to ensure that errors are detected and corrected before printing.

- The printed report should be free from any errors and format should be as expected.

- Modifications to the table/form should be done according to the requirement.

- Data modifications should be done according to the validation rules.

- Data should be sorted according to the given requirement.

- Search command should be used for specific word, number, and date in a field as required.

- The relevant filtering should be validated according to the given criteria.

- The most suitable backup option/media should be selected.

- All required information should be contained in the backup file.