The day covers the following topics

*Database structure*
Essential database concepts
Databases vs. database files
Creating a database file
Defining fields
Using field types
What are relationships
Efficiency of using relationships
Using lookups
Editing records
Creating and deleting records
Modifying records
Navigating through records
Navigating with shortcut keys
Using Auto Enter options
Using lists for data entry

*Layouts and reports*
How FileMaker uses layouts
Modifying the default layout
The layout environment
Changing layout options
Creating a letter layout
The Merge Field command
Using the field tool
Creating a label layout
Creating a report layout
FileMaker's layout parts
Layout set up
Layout order

*Sorting and Finding*
Using the Find command
Searching for multiple criteria
Finding ranges
Uses of the Found Set
Specifying sort criteria
Unsorting records
Exporting and importing records
Relationships

Databases ensure your information is accurate. Attractive pop-up lists, auto-complete fields, and other features make data entry fast and consistent.

You are, no doubt, familiar with applications that have database-like functions, such as address book, calendar, photo management programs, and so on. While extremely useful, these programs perform a limited number of functions and hold a limited amount of information. In contrast, databases can hold whatever information you need and you can
view your data any way you like.

Use a database to connect your information together. You might have a list of customers, and a list of items you have sold. By connecting (or"relating") these lists you will see all the items a particular customer purchased. Then link database records with files, photos, movies, and even Web pages to organise everything in one place. Try doing that with a spreadsheet!

Databases do more than hold data. They help you solve problems, answer questions, and make decisions. You can create formulas and calculations to help you analyse information, then whip together quick reports to help you share your insights.

Flexible printing is another strength of databases. Mailing labels, reports, invoices, badges for events and paper entry forms all are made easier with databases.

This course teaches you the principal of good database design and construction.

Course Information

Course Fee : £280.00+VAT (incl buffet lunch & refreshments)

Dates : These course are arranged on an individual basis. Please contact the studio.

Duration/Time : 9.30 - 5:30pm

Location : The Old Fire Station and your business location if required

Tutor : Matthew Clavey

All courses and training days are administered through The Old Fire Station, taking place within the "Crew Room".