Is MS Access have a function that allows you generate invoices? If so is it
possible to have a premade list and it auto populated in the selected fields
customer information. Let me know thanks.
Access knows NOTHING about customers, or sales, or invoices.
The analogy you might want to consider is that a carpenter's toolbox knows
nothing about windowframes, or soffits, or girders.
Access is a toolbox to let you put together Tables (to store data), Queries
(to integrate and sort data), Forms (to edit and view data) and Reports (to
print out data). If you want a list of Customers, you would create a Table
with the fields appropriate to customers - LastName, FirstName, perhaps
Address and Phone, etc. You would also want a table of Invoices with the
CustomerID but NO other customer information, an InvoiceDate, and other
information about the invoice as a whole; a table of Products, probably; a
table of Sales, etc.
You would construct appropriate forms to enter data into these tables, and
then use the Report Builder to create an invoice report pulling together the
information from these various tables for printing.
Take a look at the Northwind sample database that came with Access. It isn't
perfect (Microsoft wanted to show off a bunch of bells and whistles) but it
will at least demonstrate what can be done.
You may also want to check out these sources of information about using
Access:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
John W. Vinson [MVP]
