
Bruce U. answered 07/16/19
Microsoft Access - 25 years of corporate world experience
In .net, you can have a gridview control for example and chose a data source so the c# program knows what table to bring in data from. In Access, you can create a form, go to the property sheet, and in the RECORD SOURCE section, choose your table that will drive the data on the form. HOWEVER, it is far easier to first create a table with all the fields of information you need (example: product description, product price, sales rep, order date, order number, etc.) Then, once you have a table, go to the CREATE menu in Access and select FORM WIZARD, then, in form wizard, select the table you just created. The wizard will guide you through menu options and then will create a form automatically that you can use as a basis to customize as needed. Although, you can have an Access database on a network that is shared by multiple users, it's not possible to run Access forms outside of Microsoft Access.