Please see the attachment. How can I create a form like this to store
information.

Here is what I have done.

Created table BUSINESS , which has all the business names.
Created table CATEGORY , that has the Business name and Category Name.
Created table SUB CATEGORY , that has the Category Name and Sub Category
Name.

Created table APPLICATION , Which has all the Application Names
Created table COMPONET, Which has the Application Name and Component Name.

I have linked all the tables and have primary keys.

Create a query which would pull out all the Business, Category , Subcategory
, Application and Component infomation.

PROBLEM: If you look at the attachment I need to store values X. How doI
store this information and it which Table. Also how can I design a form like
the Excel sheet that helps me to store Information in a user friendly way.

Thanks,
Sharan.