1.
We will create table as given in access database here is the name
Product Style –Fields will be-Auto generated ID, Code and Name
Product Height–Fields will be-Auto generated ID, Code and Name
Product Width- Fields will be-Auto generated ID, Code and Name
Product Depth- Fields will be-Auto generated Id,C2rode and Name
Nestings- Fields will be-Auto generated ID, Code and Name
Tierage- Fields will be-Auto generated ID, Code and Name
Carcass color- Fields will be-Auto generated ID, Code and Name
Door color- Fields will be-Auto generated ID, Code and Name
Lock Style- Fields will be-Auto generated ID, Code and Name
top option- Fields will be-Auto generated ID, Code and Name
Door options- Fields will be-Auto generated ID, Code and Name
charging Options- Fields will be-Auto generated ID, Code and Name
additional color -Fields will be-Auto generated ID, Code and Name
Shelves-Fields will be-Auto generated ID, Code and Name
UDL-Fields will be-Auto generated ID, Code and Name
Accessories-Fields will be-Auto generated ID, Code and Name
2. We will create a form where user can set available height, width and other option for
product style where user can select one product style and ,multiple height ,width and
other attributes of product style and for saving this data we will create a table named as
product_detail fields will be:
Id
Productstyleid
Height(multiple height with comma separated)
And other field (for other option) will be same as height.
3. We will create other __form_______ for SKU generation where you will select product
style and based on selected product style all other dropdown (height, width and other
options) from previously generated table and when you select all drop down their will be
a button that will be used for sku code generation and create new table to store these
detail
After developing the application in msaccess (having extension mdb) so you can share
this file with your client using attached file in mail.
Suggestion- It would be a better option to make this demo on .net using sql server
database. Instead sharing mdb file on mail, we can host it on a server and easily you can –
NOT INT because…………..
share link with your client and MS access using vb code that is outdated over that .net
using c# [Link] and other languages.
Using MSSQL server database over MS Access always a better option because sql
server is fastER than ms access
MY QUES’S:
HOW LONG will A TYPICAL SEARCH take in secs if we use the following:
I can’t give you exact number of second but for typical search both will take almost
same time if database is small .I suggest you SQL server because if database is large
and you want to get multiple table data using joins then using stored procedure and
functions on SQL server it will be fast .
MS Access = ______
SQL Server = _______
Limitation of Google Sheet and Form:
As discussed Google Form and Sheet has the limitation where you can just do survey only,
google form does not support conditional attributes which comes once you select a variable.