Greetings to you all....
I have spent some time reading through various threads, and I notice many users tend to lead with "I am a beginner" or "I am new here." I prefer to skip the formalities and get straight to the point.
My goal is to develop a database using Microsoft Access. Since I have no prior experience with Microsoft Access, I find myself in need of guidance regarding the proper methodology. I previously constructed a similar system in Microsoft Excel for some elderly clients, but they found the interface somewhat cumbersome. Essentially, I intend to facilitate the issuance of goods from my retail store to a local Publisher. It is far more efficient to input this data into a computer than to manage a mountain of paperwork. My vision is that once a client's name is entered, fields such as their address, zip code, phone number, and city will populate automatically. Furthermore, I would like the invoice number and the current date to generate automatically whenever the data entry form is opened. As I list the items, I want the unit price and the unit of measure to appear instantly; then, upon entering the quantity, the total for that item should calculate itself, culminating in a grand total at the bottom of the form.
I offer my thanks in advance to those possessing both good intentions and steady nerves...👍
I have spent some time reading through various threads, and I notice many users tend to lead with "I am a beginner" or "I am new here." I prefer to skip the formalities and get straight to the point.
My goal is to develop a database using Microsoft Access. Since I have no prior experience with Microsoft Access, I find myself in need of guidance regarding the proper methodology. I previously constructed a similar system in Microsoft Excel for some elderly clients, but they found the interface somewhat cumbersome. Essentially, I intend to facilitate the issuance of goods from my retail store to a local Publisher. It is far more efficient to input this data into a computer than to manage a mountain of paperwork. My vision is that once a client's name is entered, fields such as their address, zip code, phone number, and city will populate automatically. Furthermore, I would like the invoice number and the current date to generate automatically whenever the data entry form is opened. As I list the items, I want the unit price and the unit of measure to appear instantly; then, upon entering the quantity, the total for that item should calculate itself, culminating in a grand total at the bottom of the form.
I offer my thanks in advance to those possessing both good intentions and steady nerves...👍