Question: Create the following tables in the 'QC' database with given fields. Enter at least 3 records and perform the operations as below:[2]
Items: itm ID, itm Desc, itm Price
Purchase: pur ID, itm ID, pur Date, pur Qty
a) Create 'Inventory Details' report to list Purchase Date, Item Description, Purchase Quantity and Item Price. [2]
Solution:-
To create a database 'QC' and make a 'Items' and 'Purchase' table.
Step 1:- Open Ms Access app.
Step 2:- Write the name of the database as 'QC'.
Step 3:- Click Create to finish naming the database.
Step 4:- Press Ctrl + s to save the table as 'Items'.
Step 5:- To add more fields to a table in Datasheet view, double-click the Add New Field header.
Step 6:- Next, we've added the fields itmID, itmDesc and itmPrice to the Items table.
Now change the Data type of fields according to data.
Step 7:- Select highlight 'Purchase' table.
Step 8:- Go to Design View under View Group of Home Tab.
Step 9:- Change itmID data type to Number, purDate data type to Date/Time, purQty to Number and Press Ctrl + s to save the table.
Step 10:- Now go again to Datasheet View under View group from Home Tab.
To add more table on the Database:-
Step 11:- Go to Table under Tables Group of Create Tab.
Step 12:- Press Ctrl + s to save the table as 'Purchase'.
Step 13:- To add more fields to a table in Datasheet view, double-click the Add New Field header.
Step 14:- Next, we've added the fields purID, itmID, purDate and purQty to the Items table.
Step 15:- Insert suitable 3 records in the both table and save table.
Now change the Data type of fields according to data.
Step 16:- Select highlight 'Items' table.
Step 17:- Go to Design View under View Group of Home Tab.
Step 18:- Change itmDesc data type to Text, item Price data type to Currency and Press Ctrl + s to save the table.
Step 19:- Now go again to Datasheet View under View group from Home Tab.
a) Create 'Inventory Details' report:-
Step 1:- Select the Items table. Then click on the Report Wizard button under the Reports group from Create Tab.
Step 2:- Next, add itmDesc and itmPrice field one by one from Available Fields and Move to the Selected Fields by clicking > symbol.
Step 3:- Select the another Purchase Table from Table/Queries.
Step 4:- Add the fileds purDate and purQty from Available Fields and move to the Selected fields by clicking on to the > symbol one by one.
Step 5:- Then click on the Next button until Preview the report not comes and if you want to apply formatting then adjust as you want.
Step 6:- Click Finish button.
Step 7:- That's all the steps for creating database, tables and report of above question.
No comments:
Post a Comment