
TABLE OF CONTENTS

14. Database Manager
14.1 Table Manager
14.1.1 Add Table
14.1.2 Modify Table
14.1.3 Delete table
14.1.4 Set Default Table
14.2 Add Record
14.3 Search Records
14.4 List of Records Found
14.5 Setting Backup Options
14.6 Backup Database
14.7 Restore Database
14.8 Hot Keys for "Database Manager"

14. Database Manager

The "Database Manager" is a program which can be used to create a database in the form that you specify. You can use the "Database Manager" to add records and search for data in your records. 

Database Terminology
A table contains at least one record, and a record consists of at least one field. You can specify attributes for each of the fields. In other words, a record is made up of a group of one or more fields, and a table is made up of one or more records.

When the "Database Manager" is started, it checks whether or not a table has been created. If no table has been created, a "Table Manager" dialog appears to take you through the process of creating a new table. If there is at least one table created, the "Search Records" dialog appears and the "Search" edit box is focused, so that you can search for data. To close the program while adding or searching a table, press "Space-z (dots 1-3-5-6)". Or you can use the menu. Press "Space-m (dots 1-3-4)" or F2 to open the menu. Move to "Exit" by pressing "Space-1" or "Space-4" (or Up or down scroll button) repeatedly, and press "Enter". Or you can type "z (dots 1-3-5-6)" from the menu.
The general navigation keys for the ""Database Manager"" are as follows.
1. Moving among controls
Move to the previous control: Shift-Tab (Space-1-2) or Space-F3
Move to the next control: Tab (Space-4-5) or F3
2. Moving in a list box
Move to the previous list item: Space-1 or up scroll button
Move to the next list item: Space-4 or down scroll button
3. Changing the selection in a prompt box
Select the next value: Space-4, Space or down scroll button
Select the previous value: Space-1, Backspace or up scroll button

The menu in the "Database Manager" consists of the following items. You can open this menu by pressing "Space-m (dots 1-3-4)" or F2.

1. Table Manager: Create, delete, and modify tables, records, and their fields. When you start the "Database Manager" for the first time, the "Table Manager" dialog appears.
2. Add record: Add records to the current table.
3. Search records: Search records in the current table. You can also search each field in the table.
4. List of records found: Use this menu item to navigate a list of records found in the table by the previous search. You can delete or modify each record in the list. If you have not performed a search before you using this function, the message, "no items", is displayed.
5. Setting backup options: Select the method for backing up the database.
6. Backup database: Backup all database files used in the "Database Manager".
7. Restore database: Restore the previously backed up database files. 
8. Exit: Used to close the "Database Manager".

These menu items are explained in detail in the sections below.

14.1 Table Manager

Use the "Table Manager" dialog to create, delete, or modify a table. This dialog contains the following controls.
1. Table name list: Displays the name of created tables, and their order in the list.
2. Add table button: Use this option, to create a new table.
3. Modify table button: Use this option, to change the name of a table, or modify the structure of the table, by adding or deleting fields.
4. Delete table button: Use this option, to delete the table that you have selected in the table name list.
5. Set default table button: Use this option, to set the table that opens by default when you run the program.
6. Close button: After closing the "Table Manager" dialog, and returns you to your previous position in the program. When there is no table created, if you press "Enter" on the "Close" button, the "Database Manager" program is closed.
Move among these controls by pressing "tab (Space-4-5)" or "shift-tab (Space-1-2)".

14.1.1 Add Table

"Add table" is a dialog for creating a new table. This dialog contains "Table name" edit box, "created fields" list, "Add field" button, "Modify field" button, "Delete field" button, "Previous field" button, "Next field" button, "Confirm" button and "Cancel" button. move among these controls by pressing "tab (Space-4-5)" or "shift-tab (Space-1-2)".
Suppose you want to create a table called "addressbook" which contains 4 fields: name, telephone, address, and memo. create this table as follows.

1) In the "Table Manager" dialog, press "tab (Space-4-5)" to move to the "Add table" button, and press "Enter". Or just press "a (dot 1)" from the dialog.
2) The "Add Table" dialog appears, and the "Table name" edit box is focused.
3) Type "addressbook" and then press "tab (Space-4-5)".
4) The "created fields" list is focused. As you have not yet added fields, "no items" is displayed in the list. As you add fields to this table, they are added to this list box.
5) Press "tab (Space-4-5)" to move to the "Add field" button, and press "Enter". Or press the shortcut key, "a (dot 1)".
6) The "Add field" dialog is opened, and the "Field name" edit box is focused.
7) Type "name" and press "tab (Space-4-5)".
8) The "Field type" combo box is focused. Press "Space-4" or "Space-1" to move to "edit box", and press "tab (Space-4-5)".
9) The "Set primary key" check box is focused. To set the current field as the primary key, press "Space" to check it.
10) Press "tab (Space-4-5)" to move to the "Confirm" button, and press "Enter". Now, the "name" field has been added to the "addressbook" table.

To cancel adding the field, press "tab (Space-4-5)" once more to move to the "Cancel" button, and press "Enter". If you have added a new field, you get a message saying that a new field has been added. The "created fields" list is shown again. Now, "name" field appears in the list, with the form, "name (edit box, pri) 1/1". Since only one primary key exists in a table, if you have set a field as the primary key, the "Set primary key" check box is not shown in the "Add field" dialog when you add another field. 
Add the "telephone", "address", and "memo" fields by repeating steps 5 through 10 above. Note that you may want to set the "Field type" of the "telephone" field to "number", "address" to "edit box", and "memo" to "multi line edit box". Once you have added all of the fields you wish to add, press "tab (Space-4-5)" to move to the "Confirm" button, and press "Enter".
To change the name of a created field, move to the field name you want to change in the "created fields" list. Press "m (dots 1-3-4)" or "tab (Space-4-5)", and enter on the "Modify field" button. "Field name: (selected field name)" is displayed. Type the new name for the field and press "Enter". Though you can change the name of a field, it is not possible to change the properties of a field once it is created.
To delete a created field, press "Space-1" or "Space-4" repeatedly in the "created fields" list to move to the name of the field you want to delete. Press "tab (Space-4-5)" repeatedly to move to "Delete field" button and press enter or press "d (dots 1-4-5)", to activate the shortcut key for the "Delete field" button. You may also press "tab (Space-4-5)" repeatedly to move to the "Delete field" button and press "Enter".
To change the placement of a field in your table, move to the field that you want to change in the "created fields" list. Press "p (dots 1-2-3-4)" or "n (dots 1-3-4-5)". Or press "tab (Space-4-5)" and enter on the"Previous field" button or "Next field" button to change the location of the current field.
The "Add Table" dialog is closed, and the "table name" list box is shown again. The newly created table is added to this list, and "address book 1/1" is shown in the list. To close the "Table Manager" dialog, press "tab (Space-4-5) to move to the "Close" button, and press "Enter". Or press "Space-z (dots 1-3-5-6)" to close the dialog. Then, the "Search Records" dialog is opened, and the "name" field, the first field of the "address book" table, is shown. Here, type the name you want to search for.

14.1.2 Modify Table

"Modify table" is used to modify the name or structure of a created table. It contains the same controls as in the "Add Table" dialog. To modify a table, press "Space-m (dots 1-3-4)" or F2 to open the menu, and press "Enter" on "Table Manager". Or press the hotkey for "Table Manager", "Enter-t (dots 2-3-4-5)". When the "Table Manager" dialog is opened, the "table name" list is focused. Press "Space-1" or "Space-4" to move to the table that you want to modify, and press "m (dots 1-3-4)", the shortcut key for the "Modify table" button. Or press "tab (Space-4-5)" repeatedly to move to the "Modify table" button, and press "Enter". the "Modify Table" dialog appears. This table is the same as the "Add Table" dialog. The only difference is that the "Table name" edit box, and "created fields" list contain the information already stored in the table. You can not change the name of a table.
To add additional fields, press "tab (Space-4-5)" to move to "Add field" and press "Enter". Type the new field name and press "Enter". To delete an already created field, press "Space-1" or "Space-4" repeatedly in the "created fields" list to move to the name of the field you want to delete. Press "tab (Space-4-5)" repeatedly to move to the "Delete field" button and press enter or press "d (dots 1-4-5)", to activate the shortcut key for the "Delete field" button. You can also press "tab (Space-4-5)" repeatedly to move to the "Delete field" button and press "Enter".
To change the order of a field in  your table, move to the field that you want to change in the "created fields" list. Press "p (dots 1-2-3-4)" or "n (dots 1-3-4-5)". Or press "tab (Space-4-5)" and enter on the "Previous field" button or "Next field" button.
To change the name of a created field, move to the field name you want to change in the "created fields" list. Press "m (dots 1-3-4)" or "tab (Space-4-5)", and enter on the "Modify field" button. "Field name: (selected filed name)" is displayed. Type the new name for the field and press "Enter".
Though you can change the name of a field, it is not possible to change the properties of a created field.

14.1.3 Delete table

Use this option to delete a table. To delete a table, Press "Space-m (dots 1-3-4)" or F2 to open the menu, and press "Enter" on "Table Manager". Or press "Enter-t (dots 2-3-4-5)", the hot key for opening the "Table Manager". When the "Table Manager" dialog is opened, the "Table name" edit box is focused. In this list box, move to the name of the table you want to delete by pressing "Space-4" or "Space-1" repeatedly, and press "d (dots 1-4-5)", the shortcut key for the "Delete table" button. Or press "tab (Space-4-5)" repeatedly to move to the "Delete table" button, and press "Enter". You are prompted, "Delete table? Yes". To delete press "Enter". To cancel, press "Space" to select "No", and press "Enter".

14.1.4 Set Default Table

When you set a table as the default table, each time the "Database Manager" is started, this table is displayed and you are placed in the search dialog. If you have created more than one table and you use one of them more frequently than the others, it may be convenient for you to set this table as the default table. If no table is set as the default table, the last table used is displayed when opening the "Database Manager". 
To set a table as the default table, press "Space-m (dots 1-3-4)" or F2 to open the menu, and press "Enter" on table manager. You can also press "Enter-t (dots 2-3-4-5)", the hot key for opening the "Table Manager". The "Table Manager" dialog appears, and the "table name" list is focused. In this list, press "Space-4" or "Space-1" repeatedly to move to the name of the table you want to set as the default table. Then press "s (dots 2-3-4)", the shortcut key for the Set default table" option. Or press "tab (Space-4-5)" repeatedly to move to the "Set default table" button and press "Enter". Or simply press "Enter" on the name of the table in the "table name" list. The Braille Sense U2 announces that the table is set as the default table, and the "Table Manager" dialog is closed.

14.2 Add Record

 Use this option to add information to a table that you have created. When the "Database Manager" is started, the "Search Records" dialog is opened. To open the "Insert a New Record" dialog, press "Space-m (dots 1-3-4)" to open the menu, and press "Enter" on "Insert a New Record". Or press "Enter-i (dots 2-4)" from the dialog. 
Think of a record as a collection of information (fields) for an object (record). Let's consider the "addressbook" table you created in the previous section. YOU can add records to this table using the method described below:
1) Press "Space-m (dots 1-3-4)" or F2 to open the menu, and press "Enter" on "Insert a New Record". Or press "Enter-i (dots 2-4)" from the records list.
2) The "name" field, the first field in the "addressbook" table, is shown. Type the name of the person for whom you want to create a record, and press "tab (Space-4-5)".
3) The "telephone" field is focused. Type the person's phone number. Since this field is a "number" field, a limited set of characters including numbers and hyphen is available. enter a number without the number sign. If you press "Space" instead of ?(hyphen), the hyphen is entered.
4) Press "tab (Space-4-5)" to move to the "address" field. Type the address.
5) Press "tab (Space-4-5)" to move to the "memo" field. Since this field is a "multi edit box", you can type multiple lines of text. To start a new line, press "Enter".
6) Press "tab (Space-4-5)" to move to the "Confirm" button. If you press "Enter", the record is added to the table. If you do not want to save the record you have created, press "tab (Space-4-5)" once more to move to the "Cancel" button, and press "Enter". Or press "Space-e (dots 1-5)".
If you have added a record, the "name" field is focused again so you can add another record. 
To go back to the "Search Records" dialog, press "Enter-s (dots 2-3-4)". To open the "Table Manager" dialog, press "Enter-t (dots 2-3-4-5)". If you open these dialogs while entering a record, you are asked To save the record. Select "Yes" or "No" by pressing "Space" or "Backspace", and press "Enter". If you select "Yes", the record is saved, and if you select "No", it is not saved and the specified dialog is opened. If you select "Cancel", the dialog is not opened.

14.3 Search Records

Once you have added records, you will likely want to access this information in an efficient manner. To search for information in your records, use the "Search Records" dialog. To open the "Search Records" dialog, press "Space-m (dots 1-3-4)" and press "Enter" on "Search Records". Or press "Enter-s (dots 2-3-4)". The "Search Records" dialog is opened, and the first field of the table is focused. Type the text that you want to search for. 
Using the Address Book example, the focused field is the "name" field. Thus, type a person's name in the edit box to look up "/her  record. If you have several records under the same name, you may wish to further specify the record you are looking for. To search for records using content from more than one field, press "tab (Space-4-5)" to move to another field. Type the text to search for in this field, and press "Enter". 
the "List of Records Found", or rather, records that matched your search, is opened. In the "List of Records Found", each record is shown in the following form. "(the name of the first field) : (other information in the record) xx/yy". "yy" is the total number of records found, and "xx" is the order of the current record in the list. If no record is found, you are informed, "No records found", and the current field is shown again, so you can type another search queery. Move through the "List of Records Found" as follows.

1. Move by record
Move to the next record: Space-4 or down scroll button
Move to the previous record: Space-1 or up scroll button
Move to the last record: Space-4-5-6
Move to previous same field different record: Space-3
Move to next same field different record: Space-6
Move to the first record: Space-1-2-3
2. Move among the fields in a record
Move to the next field: Space-5
Move to the previous field: Space-2
Move to the last field: Space-4-6
Move to the first field: Space-1-3

From the "List of Records Found", To search for new text, press "Enter-s (dots 2-3-4)" to open the "Search Records" dialog again. Type the new text you want to search for and press "Enter".

To delete a record, press "Space-1" or "Space-4" to move to the record, and press "Space-d (dots 1-4-5)" from any of the fields in the record. You are asked if you really want to delete the record. Select "Yes" or "No" by pressing "Space" or "Backspace". If you press "Enter" after selecting "Yes", the record is deleted, and if you select "No", the deletion is canceled. 
To search for records in another table, press "Enter-t (dots 2-3-4-5)" to open the "Table Manager" dialog, and press "Enter" on the name of the table you want to open.
To change the content of a record, select the record by pressing "Space-1" or "Space-4" repeatedly. And press "Enter-m (dots 1-3-4)" from any field in the record. The same dialog as the "Insert a New Record" dialog is opened. To change the content of a field, move to the field by pressing "tab (Space-4-5)", type the new content, and press "Enter". To save the modifications, press "Enter" after typing new content for all the fields you want to change. Or move to the "Confirm" button by pressing "tab (Space-4-5)" repeatedly, and press "Enter". To cancel modification of the record, press "tab (Space-4-5)" once more to move to the "Cancel" button and press "Enter".

14.4 List of Records Found

The "List of Records Found" appears when the queery you typed in the "Search Records" function produces results. While using the "Insert a New Record" or "Search Records" dialog, To go to the "List of Records Found", press "Space-m (dots 1-3-4)" or F2 to open the menu, and press "Enter" on "List of Records Found". Or  press "Enter-r (dots 1-2-3-5)".

14.5 Setting Backup Options

You can backup your database file, manually using the "Backup Database" function. You may also backup your database file automatically by using the "Set Backup Options". To activate the "Set Backup Options" function, press "Space-m (dots 1-3-4)" or "F2" to open the menu. Press "Space-4" or "Space-1" repeatedly to move to "Set Backup Option". Press "Enter". Or, press "e (dots 1-5)" from the menu to go to "Set Backup Option". You can also activate the function directly by pressing "Enter-e (dots 1-5)".
The "Backup Options" dialog has three controls: "Backup mode" radio button, a "Confirm" button, and a "Cancel" button. move among the controls by pressing "tab (Space-4-5)" or "shift-tab (Space-1-2)". To switch among the radio buttons, press "Space-1", "Backspace", "Space-4", or "Space".
The "Backup mode" has three radio buttons: "Manual backup", "Always backup changes when exiting", and "prompt to backup changes when exiting".

1. If you select the "Manual backup", it does not create a new backup file even if there are changes in the database. In this case, you can only create a new backup file by using the "Backup Database" menu.
2. If you select the "Always backup changes when exiting", a new backup file is automatically created  on exit if you modify or add to the database. 
3. If you select the "Prompt to backup changes when exiting", if you have modified or added to the database, you are prompted, "Backup changes? Yes" when you exit the "Database Manager". If you press "Enter" on "Yes", it automatically creates a new backup file and exits the "Database Manager". If you press "Space-4" once and press "Enter" on "No", it exits without creating a new backup file.

To change the backup mode, press "Enter" after focusing on one of the three radio buttons. Or, press "Enter" on "Confirm" after moving to it by pressing "tab (Space-4-5)". The default backup mode is set to "Prompt to backup changes when exiting".

14.6 Backup Database

If a hard reset  is performed, or if your battery dies, all of the data in the "Database Manager" is lost. Thus, it is very important that you create a backup file every time you make a change to the Database file. To go to "Backup Database", open the menu by pressing "Space-m (dots 1-3-4)" or "F2". Use "Space-1" or "Space-4", to locate "Backup Database". Press "Enter". You can also press "u (dots 1-3-6)" from the menu to get to "Backup Database". Or, press "Enter-u (dots 1-3-6)" to activate this function directly.
If you already have a backup file, you are prompted, "Backup changes? Yes". If you have made any changes to your database file, press "Enter" to create a new backup file. To keep the previous backup file, press "Space", to navigate to "No", and press "Enter" on it. When you create a backup file in your "Database Manager", a new backup file with the extension SDF is saved. The name of the backup file is "UserDatabase.sdf"

14.7 Restore Database

To restore the database file after a hard reset, press "Space-m (dots 1-3-4)" or "F2" to open the menu, and use the up and down scroll buttons to locate "Restore Database". Press "Enter". Or, press "r (dots 1-2-3-5)" from the menu. You can also press "Enter-o (dots 1-3-5)" to activate this function directly.
If you activate the "Restore Database" function, and you already have a database file, you are prompted, "Database file already exists. Restore? Yes". If you press "Enter", the backup database file is restored to the current database file. To cancel, press "Space" and press "Enter". 

14.8 Hot Keys for "Database Manager"

Add record: Enter-i (dots 2-4)
Search records: Enter-s (dots 2-3-4)
Table manager: Enter-t (dots 2-3-4-5)
List of records found: Enter-r (dots 1-2-3-5)
Set backup options: Enter-e (dots 1-5)
Backup database: Enter-u (dots 1-3-6)
Restore database: Enter-o (dots 1-3-5)

1. Move by controls
Move to the next control: Tab (Space-4-5 or F3)
Move to the previous control: Shift-Tab (Space-1-2 or Space-F3)
2. Move in a list box
Move to the next list item: Space-4 or down scroll button
Move to the previous list item: Space-1 or up scroll button
3. Select your answer in a prompt box
Move to the next answer: Space-4, Space, or down scroll button
Move to the previous answer: Space-1, Backspace, or up scroll button
4. Move in the "list of records found"
Move to the next record: Space-4 or down scroll button
Move to the previous record: Space-1 or up scroll button
Move to the last record: Space-4-5-6
Move to the first record: Space-1-2-3
Move to the next field: Space-5
Move to the previous field: Space-2
Move to the last field: Space-4-6 
Move to the first field: Space-1-3 
Move to previous same field different record: Space-3
Move to next same field different record: Space-6