Database Technologies Level 3: Application Development with MS Access
| DIT 15549 | 18 hours |
Programs
Objectives
- To provide competence working with multiple table databases, advanced forms and reports and action queries
Outcomes
- Customizing reports
- Designing and creating custom reports
- Adding subreports to reports
- Using domain aggregate functions in a report
- Exporting tables as HTML documents
- Creating and modifying data access pages
- Importing and exporting XML files
- Creating PivotTables and PivotCharts
- Creating action queries
- Defining relationships
- Joining a table using a self-join
- Running and adding actions to macros
- Creating a macro group
- Using Switchboard Manager to create a switchboard
