Help on access

[adijay]

Hi there! First of all let me present myself. My name is Nuno and I'm from Portugal.

I'm a complete noob on access because i've never had the necessity to use it. Now I'm trying to do a project and I think the best and simplest way to accomplish it might give some use to access. It is at this point that I need your help.

What I need to do is an application (web based for example, running on a browser window, or other similar) and I need it to have several menus. One for creating a "building" list with several information related with each "building". Then, on each building I'll have a customer list with the typical data such as name, adress, contact, a customer code and a value they have to pay me for example. then, on other page I'll have the billing service form wich on a drop box displays the customer list of the "building" i've selected and once I select the customer it fills out the other boxes ( in this case customer code and the value and a button that redirects me to the bill document (in word) and fills out the required fields.. On this billing service I would also need to create a table of payments that adds the payments I've registered through the form.

I'll have some other aplications that I need to add but for now I think that's a lot of stuff to work on.



As I told before I'm a complete noob on access that's why I need deperately your help to walk me trhough the process!!!


Thanks a lot everyone!!

[Computer202]

Welcome,

I am by no means a pro and can't help you totally here... However what you will need to start of with is a table for Buildings, customers and maybe payment billing service.

If you set up the billing service table to be exactly what you want on word but Instead of Name, Address etc use a relational link, this save time and work.

If you want them combined at a later stage a query is simple

Hope that helps get you started