Introducing database design
• Basic considerations
• Gathering resources
• Producing a flowchart of work

Designing your database
• Relational or flat field?
• Defining the relationships between databases and fields
• Designing the layouts

Creating a new database
• Defining and formatting fields
• Specifying field relationships
• Entering/importing data
• Defining calculation and date fields
• Setting look up fields
• Creating a list of values

Creating layouts
• Designing layouts for screen
• Designing layouts for print
• The Layout/Report Assistant
• Defining the part types in a layout
• Specifying the size of layout parts
• Importing graphics in a layout
• Using Container fields
• Using conditional formatting
• Numbering pages
• Creating headers and footers
• Setting passwords
• Creating layouts with a summary
• Creating letters and forms
• Creating lists
• Creating page breaks
• Using the Comments feature

Optimising your database for your user’s requirements