Layouts+and+Forms

One of the powerful features of a database is that once the data structure has been designed, data from the database can be displayed in a variety of different ways. For example, if a DVD rental shop has a database which is accessed by both shop staff and customers, it may be appropriate to offer different layouts.

A simple form layout might be suitable for a member of staff who wants to quickly add new records to the database. This layout might not be the best choice for a customer, who would want to see a more visual interface when browsing the database of available DVDs.

Complete the tasks below on forms:

Investigating template layouts

Adapting an existing layout

Designing a new layout