I need a small access database that will be used by 5 people who will be logging complaints. There are three types of complaints (they can be called Category One, Category Two, Category Three). When the database is opened the user should be provided with three options to go into (the three categories).
Once in one of the categories they should be presented with a form to input data. The input form will be no different for each of the three categories. For each category the data gathered will be the same; name, address, phone, a text box for a description of the complaint, and most importantly an automatically generated number (like a customer ID number). So from a tech’s perspective there will only be three access “tables?? hooked up.
There will be queries that are necessary. One: Query on a last name to see how many complaints in all the categories were filed. Two: Obviously, a way to search on the customer ID number. Cannot conceive every possibility at the moment but a good relationship will need to be established with the programmer; preferably 3 months of ongoing support for tweaking.
1) Complete and fully-functional working program(s) in executable form.
2.) 3 months of ongoing tech. support for possible tweaking. May not even be necessary.
W2K Pro. & XP