ICT693 Access 2003 Designing forms and reports for a relational database
Description
This opportunity will help you to design more complex forms and reports using a relational database ie one containing more than two tables. This unit will build on the skills gained in Access 2003 - Creating simple database forms and Access 2003 - Creating simple database reports. The skills gained in these previous units will be invaluable when trying to design a form or report using multiple tables.
Content:
Be able to create forms with sub forms for one-to-many relationships
Be able to navigate and use a relational form
Be able to modify forms in design view
Be able to create a report using more than one table
Be able to modify a relational report in design view
Level: Proficient users
Audience: All education staff
Pre Skills: Mastery of the skills covered in Level 0/1 Microsoft Access courses
