Exercise 1: Create customer databaseBy using PostCast New Database Wizard you will create your personal database in less than 2 minutes, without having to bother about terminology and theory. Your database is the PostCast driving force. However, it would be necessary to precisely identify your database in order to be able to use the PostCast advanced tools. If you want to use the PostCast E-mail Client only, you may leave out the database but then you will need at least one table for all the rest. PostCast makes use of Access database. Access databases are very widespread and they form a basic part of the Microsoft Office package. Here are the steps towards the quickest and simplest new database creation: 1. Start the program first. If you had not previously defined a project, select 'Blank Project' from the window which appears once you had started the program. You can also click the 'New' button from the Toolbar. Save your project as: 'Customers.poc' (you can click the Save button from the toolbar). 2. You should start the New Database Wizard. Select 'Tools/New Database' option from the menu, and the initializing screen will appear: 
3. You should enter the path whereby your database will be saved. Enter 'customers.mdb' in the 'File name:' text box. You may proceed to the next step. Click the 'Next' button. 4. First, you must enter the table name. Enter "Customers" within the 'Table Name' text box. Now you may enter the names of fields or columns in your new table. 5. Below the 'Field name' text box, the 'Data Type' combo box can be seen. It serves the purpose of assessment of the type of your data to the corresponding column. Column names You should enter all the column names within the 'Field name' text box: Last Name, First Name, Company, Street, City, Country, Phone, Fax, Registration fee, Shipping, Total, Number of licenses Here is an example of column definition: - Enter "Last Name" within the 'Field name' text box. The column type is thus a text type, and it allows as many as 255 characters per record table. In this case the 'Text' type is selected by default. - Click the 'Add' button. You would notice that you have just entered the data into the list box on the left. Other data i.e. First Name, Company, Street, City, Country, Phone, Fax, are likewise entered in column tables. Enter the Registration fee, Shipping and Total column with the 'Currency' data type. Click the combo box and select 'Currency' from the list. The 'Number of licenses' should be 'Integer' data type. The figure below shows what your table is supposed to look like: 
6. Now you have defined all the columns. Click the 'Build the table' button. A new screen will appear which will ask you to define the Primary Key. Its main function is the maintenance of the internal table integrity. Thanks to the Primary Key, two identical primary key values cannot be found in the table simultaneously. All you have to do for now is click the 'Continue' button. 7. Your new database is ready for use. Click the 'Save' button from the toolbar to save all changes. Click 'Next, and then 'Finish'. Exercise 2: Import data from the text files | 
