"Textease Databases - DOC"
Textease Databases The Textease database can be selected from the database icon or through the Textease Studio icon and then through the Database option on the menu bar. Once the data has been entered, it can be sorted and selected. Charts and graphs are easily produced and data can be displayed as a form or report – for quick viewing. Data can also be imported from other sources. Data can be dropped into text to produce personalised letters. Definitions A field is defined as one of the pieces of data that make up a record, e.g. name of a pupil. A record is a complete set of fields in a database table, e.g. all the data we keep on a single person. A form is a page that contains fields and can have data entered into it. A report is a view of the data in the database that displays many records at once. Table Map The Table Map displays information about a database and its structure. Use the Table Map to change the names of tables and fields, or to create new forms and reports. To create a database Select Textease Studio and then Database – new field. Click on the new form somewhere around the centre top. A white rectangle will appear along with a name tag “Field 1” Type the word “Name” to see the tag change from “Field1” to “Name”. Add two more fields down the page and label them “Age” and “Height”. You have now created your first simple database. Selecting a field Simply click near the field and while holding down the mouse button drag the pointer over the field. A dotted box appears around the field with four corner points. This shows the field is selected. The size of these boxes can changed by dragging the corners. Click the pointer on a clean area to de-select the highlighted objects. Education Bradford 1 Format a field For example to show the height data in cm, select the height field entry box on your form, then click on the effects button on the button bar. Use the “cell” tag and choose 1 cm form the list of Format options. You can also format for date and currency. All entries can be positioned in the centre, at the right or justified. Entries can be placed at the top, middle or bottom of a cell. There are many other effects possible, i.e. style of line, line colour, fill colour and shadow. Creating new records New records can easily be added and deleted. Select the appropriate arrow to add or delete records. Example databases These can be accessed through the File, Examples menu. Choose a database to work with. Select Records (Query) To search through a database and answer certain queries, you use the select records button. A query box appears from which you choose the phrases, when assembled make a sentence which meets your selection. The query will begin to look like this. Education Bradford 2 The query can be extended by adding And, Or to statements. Select Add to Query and then when it appears in the open area, and you are satisfied this is what you want, select Run Query. Change Data View This button enables you to see your database as a table of information. Graphics and clip art can be added to your database. Education Bradford 3 Education Bradford 4