Calculation Fields take the data entered into two Number fields and perform a basic calculation using the data in those fields. Large Text fields handle an unlimited amount of text, which you can use for notes or other multi-line text. Small Text fields offer a single line of text you can use to enter something like a name, address, city, or state. IDatabase offers 14 field types for handling the different types of data you may want to enter. But, out of the box, the templates that ship with the app are not complete enough to be useful. These are easy enough to add to the template and once you’ve made these changes you can use your updated database as the basis for a new template. For example, if you use the built-in movie database you’ll notice that, among other things, it is missing pick lists for movie genre and lacks a release date field. All of the the templates provide a good foundation for creating databases that suit your specific needs, but as they are they lack necessary fields and need further configuration to be truly useful. Among the included templates are forms for book and CD collections, class lists, computer inventories, and exercise logs. When creating a new database, iDatabase offers the option of starting from a pre-defined template or from scratch using a blank file. IDatabase offers a simple drag-and-drop interface for adding fields to forms, but has limited form customization options.

Database software for macs