Computer Operator Practical Question Ms Access ; How to create Quantity database, table & create report of Items?

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.