FOCUS OUTCOME STATEMENT: - 5.2.2 designs, produces and evaluates appropriate solutions to a range of challenging problems
- 5.5.1 applies collaborative work practices to complete
- 5.2.2 designs, produces and evaluates appropriate solutions to a range of challenging problems
- 5.2.3 critically analyses decision-making processes in a range of information and software solutions
STUDENTS LEARN ABOUT: - editing, searching, sorting records
- Interface design
- the function of the user interface
- interactivity with the user
- communication with application and operating systems
- mathematical calculations
- outputs of the database: reports, forms, data/information
- presentation of reports: header, body text, footer
- Integration
- exporting data for other uses
- interface with other systems, e.g. mail merge
STUDENTS LEARN TO: - edit existing fields and records within a database
- construct query searches and sorts on given data
- explain the function of the user interface
- compare and contrast the types of user interfaces
- design and perform calculations on data
- create macros to perform repetitive tasks
- identify outputs when designing a database
- prepare a range of report layouts for presentation
- create an effective design for database forms
Access 2016: Customizing Tables
Access 2016: Working with Forms
Access 2016: Sorting and FilteringAccess 2016: Designing a Simple QueryAccess 2016: Modifying Tables
Access 2016: Multi-Table Queries (Part 1)
Access 2016: Multi-Table Queries (Part 2)
Further You Tube Videos
|
|
