bopsnewjersey.blogg.se

Access customer service database template

#Access customer service database template how to#
#Access customer service database template update#

Locking selections to these boxes will assist with the validation process.Īs far as the simultaneous users that definitely adds complexity, but here is a link that has good information on how to accomplish this task. However, I would be able to assist you along the way and answer any questions you have while you are developing your solution.įorms can be complex but I would recommend using them and having drop-down (combo) boxes for the majority of the items you need to update/change. Unfortunately I don't think you will find anyone with the time to build the solution for you. I know this is probably simple to do, but like I stated before, I haven't worked with access in a long time and never had to do anything this complicated.

The way it is currently planned is to have separate databases for the make and models of the equipment, the vendors, and a master database storing rental information that has relationships to the previous databases. I would prefer the ability to have a drop-down in the form to prevent the user from typing the wrong information. I would assume a separate database for each would be necessary.

It needs to have measures in place to prevent mistyping of equipment makes or models or vendor names.

Multiple users MIGHT have to access the database simultaneously, but not often.

#Access customer service database template update#

The users will need to eventually update the records to apply the rental end date and hours of service.Extremely user friendly, so forms for everything.I haven't worked with Access in a long time and am hoping someone could give me a few pointers. I have been tasked with creating an Access database to track my company's equipment rentals.