How to create a program in the database designer

To date, the issues of systematization and cataloguing of information is almost every person. At work we use diaries, lead database of customers, orders and services, compiled various reports. For home looking for a program to compile libraries, libraries, record recipes and the like. In this article we will explain how to create a simple database yourself.

You will need

• Rомпьютер, free database designer Fleece, Microsoft Office or OpenOffice.

Instruction

1. For example we will create a database of contacts - mini CRM system. Download and install the database designer, go to control projects and create the project. Let's call it "Base contact".
   
2. In the constructor of the database structure we add the object "Customers". Dragging the mouse field to be added and enter their names. String type fields: "name", "Phone", "Address", Skype, Email, notes. A field of type date: "date of birth". For fields of type Email must specify the appropriate subtype, then it will appear as a hyperlink.
3. Create a Task object to schedule tasks and track their status.
   Add a field of type "date". Add the field "Status" type switch with the values "open, closed" (or "active, inactive"). Add a reference to the object "Customers". Add the field "Rating" type switch with values "without evaluation, excellent, good, satisfactory, not satisfactory". Add the calculated field "Time" with the formula [date]-[~today]. Include the filter for "Date", "Status" and "Client".
4. You can enter the data. Check the experience: add or remove fields in the list, turn on the filters.
5. For fields of type switch turn on the display property in the form of drawings. Add in the resources icons corresponding to the field values of the switch. Also add a field of type "Color" for color display tasks due today, and overdue tasks. The estimated result. Our database with their hands ready.