School of Computer Sciences Western Illinois University IS 524, Assign#2 Amaravadi Note that this assignment requires you to know database concepts prior to doing it. Download from the course web site and open it in Access, make sure to the content. The database ‘insurance.accdb’ ‘enable’ already has the product table. You will be creating the Creating the client and payments tables, entering data, doing queries and creating a report. DATA DEFINITION We will define the tables in the following steps. Go into tab and select design”. You are “Create” “table presented with a blank table as below. This has id as primary key. Close this table and then select and Design’ again from the main ‘Create’ ‘Table menu. You are presented with another form that looks like the previous one. Using the attributes below, define the data for the by typing in the attributes and their data types. Define the primary key by Client table highlighting the key and selecting the primary key icon from the menu. Close the table and save as “design’ Repeat the same process for the table. You need to hold down the shift key when defining payments ‘Client’. multiple primary keys. The is already available. product table Client Product Payments You should see all three tables on the left side of the screen. CHECK RELATIONSHIPS You need to check if the tables are linked together. Go into tools” and from the main “Database “relationships” menu. It should show the tables linked by cross-reference keys. If they are not linked, all three tables and “add” link them by dragging and dropping primary keys (see the diagram below). Close and save. DATA ENTRY FORMS We will create data entry forms for the and tables and enter data through the forms. For the ‘client’ ‘payment’ table data will be entered directly into the table. Select table first and go into create” and ‘product’ ‘client’ design” from the menu on top. You are presented with a blank form on which will be placed. “forms ‘controls’ See the menu in the figure below. You will create the title first and then add fields:
School of Computer Sciences Western Illinois University IS 524, Assign#2 Amaravadi Note that this assignment requires you to know database concepts prior to doing it. Download ‘insurance.accdb’ from the course web site and open it in Access, make sure to ‘enable’ the content. The database already has the product table. You will be creating the Creating the client and payments tables, entering data, doing queries and creating a report. DATA DEFINITION We will define the tables in the following steps. Go into “Create” tab and select “table design”. You are presented with a blank table as below. This has id as primary key. Close this table and then select ‘Create’ and ‘Table Design’ again from the main menu. You are presented with another form that looks like the previous one. Using the attributes below, define the data for the Client table by typing in the attributes and their data types. Define the primary key by highlighting the key and selecting the primary key icon from the “design’ menu. Close the table and save as ‘Client’. Repeat the same process for the payments table. You need to hold down the shift key when defining multiple primary keys. The product table is already available. Client Product Payments You should see all three tables on the left side of the screen. CHECK RELATIONSHIPS You need to check if the tables are linked together. Go into “Database tools” and “relationships” from the main menu. It should show the tables linked by cross-reference keys. If they are not linked, “add” all three tables and link them by dragging and dropping primary keys (see the diagram below). Close and save. DATA ENTRY FORMS We will create data entry forms for the ‘client’ and ‘payment’ tables and enter data through the forms. For the ‘product’ table data will be entered directly into the table. Select ‘client’ table first and go into create” and “forms design” from the menu on top. You are presented with a blank form on which ‘controls’ will be placed. See the menu in the figure below. You will create the title first and then add fields:
db_intro.docx