Hey guys
I'm new here and first off i understand the very basics of Access.
For our bussiness i need some sort of cliënt database with invoicing.
We have cliënts with multiple cars and i need some sort of database to keep track of this.
Bassicly what i need is the following.
I need a cliënt database with possibility to add multiple vehicules per cliënt
I need to be able to search on vehicule so i can see the cliënt connected to the vehicule
I need a form in wich i can make an invoice with the possibility to automatic get the cliënts details and add one of his vehicules (and only the vehicules listed to that person.
What i know of access like said are the very rudementary basics like making tables, forms and relations but that's where the fun ends.
What i would like help with is, how many tables, forms and qeury's do i need to make this work, the end result has to be easy enough to let someone with no access knowledge to use the database as well so preferably with some easy buttons like "add vehicule" "add cliënt" and "make invoice".
Please help me.
Kind regards Jonas