Can microsoft access handle serial number wise data?

Question

If i need to keep track of stock, receipt dispatch etc of 50 different items and all these items have serial numbers. so have to maintain quantity with serial number of the the items.

Answer 1

Yes, it will do that. You'll need to program Access to do what you want it to do, including data input, data storage, and generating the reports that you need.

Answer 2

Yes it can.

1)Open the database
2)Choose the object "Tables"
3)Right click the table name and select Design View
4)Select the Data Type for the respective Field Name. eg-select the field name "Serial No" and in the respective Data type choose"Memo".
5)Close design view and start entering the serial number.