MODIFYING THE STRUCTURE OF A DATABASE

        Quit the creation process after typing 20 on the COMMENTS line: <Ctrl+W>. (The Ctrl+W sequence “writes” the database structure to disk.)

NOTE

Some database programs prompt you for data entry upon completion of the database structure. If you are prompted for data entry, respond by typing N. Information is entered in Section 3.

OPENING AND CLOSING DATABASE FILES The USE command followed by a database filename (USE Filename <Enter>) opens the named database. Once open, the commands you enter interact with the database. Typing USE<Enter> closes the currently open database file. You can also type CLOSE DATABASE <Enter> to close all open database files. Proceed as follows:

1.         Close the database : USE <Enter>.

2.         Reopen the EXPENSE database: USE EXPENSE <Enter>.

 You can change the structure of an open database file by using the MODIFY STRUCTURE command. Most database program command can be abbreviated by using the first four letters of the command. For example, you can use MODI STRU in place of MODIFY STRUCTURE to save keystrokes. With the EXPENSE database file in use, perform the following procedure: