Courses and resources

Who is it for?

You should have attended (or be familiar with the concepts in) the Using Databases course.

Ideally, you should also have attended the Designing and Developing Databases and the Creating Queries courses.

What is it about?

This course covers creating basic forms to enable data entry and viewing and editing records.

You will also create reports to summarize and present data from tables or queries.

What will I get out of it?

1/ Creating forms using the form wizard.

2/ Modifying form design.

3/ Form controls (fields, labels, images).

4/ Form and control properties.

5/ Adding option buttons and combo boxes.

6/ Creating reports using the report wizard.

7/ Modifying report design.

8/ Grouping and sorting in reports.

9/ Creating labels with reports.

10/ Numbering items in reports.

11/ Conditional formatting in reports.

Is there anything I need to do before attending?

Participants should be familiar with field properties in tables and criteria in queries and be confident in using and navigating within an Access database.

Learning Provider: This course is administered by Staff Learning and Development, please contact SLD@exeter.ac.uk for any queries.