How to create invoice table using - MS Access

-

Creating invoice table using - MS Access

 An invoice, bill or tab is a commercial document issued by a seller to a buyer, relating to a sale transaction and indicating the products, quantities, and agreed prices for products or services the seller had provided the buyer.

Creating Invoice in MS Access

  • Open MS Access and create or open database.
  • From the create tab, locate the table design and click on the Table Design.
  • Create the fields as "InvoiceNum","Text"; "ContractNum","Text"; "InvoiceDate","Date/Time"; "InvoiceItem","Text"; "InvoiceAmt","Currency"; "InvoicePaid","Yes/No";   w.r.t  "FieldName","DataType"  respectively.
  • Apply the primary key to the InvoiceNum.
  • Save and Rename the table.
  • Open the table in Table View.
  • Enter the field values.
  • Save the Table.

Preview and Printing Invoice

  • Click on the Print Preview to open the preview of your Invoice.
  • Now, Click on Print to print the Invoice.


Comments

Post a Comment

Popular posts from this blog

Exporting Tables, Queries, Forms and Reports to web pages

-
Image
Objective: Exporting Tables, Queries, Forms and Reports to Web Pages using simplest steps in MS Access    MS Access allows users to built a powerful integrated platforms of inserting, saving, retrieving the information into the database. There are many platforms for these facilities in MS Access for example  Tables ,  Quires ,  Forms ,  Reports , etc.    In previous posts we have learnt how to create the  Tables ,  Quires ,  Forms  and  Reports , etc. But if we want to open the data into another application then it provides  a way to do the same. We can export the table, queries, etc. into another format such as XML, web pages.    In this tutorial, you will come to know how to export the tables or queries into the web page format which allow you to open the table in web browsers.   If you don't know how to create the data tables, queries, and reports then please  read those articles  before it. We just follow some easy steps to do the same as follow: Procedure: 1. Open a database
Read more

Drug information storage and retrieval using MS Access

-
Image
Drug information storage and retrieval using MS Access      The storage, retrieval, and dissemination of information constitutes a major function of any drug information service (DIS). We developed a computerized system for the storage and retrieval of data from drug information requests (DIR) using a MUMPS-based information system. In the past, DIR forms were stored in looseleaf binders and filed chronologically. Due to the success and increased use of our DIS, this manual filing system became inadequate and awkward to use. Our solution was to develop a computer system where data could be entered from DIR forms and retrieved rapidly and easily. Each DIR was reviewed and key data elements were selected for input. The DIS files may now be searched online rapidly and efficiently. The MUMPS-based information system has provided open access for all staff pharmacists, 24 hours a day. The benefits have been an increase in both the quantity and quality of drug information provided.    Here, w
Read more

Computer as data analysis in Preclinical development - Brief Notes

-
Image
Unit - V  Computer as data analysis in Preclinical development Brief Notes     Scientists from many different disciplines participate in pharmaceutical development.Their esearch areas may be very different, but they all generate scientific data (and text documents), which are the products of development laboratories.   Even a typical Investigational New Drug (IND) application requires around 50,000 pages of supporting documents. One way or another, every single data point has to go through the acquiring, analyzing, managing, reporting, auditing, and archiving process according to a set of specific rules and regulations.The wide use of computers has tremendously increased efficiency and productivity in pharmaceutical development.    On the other hand, it has also created unique problems and challenges for the industry. This overview discusses these topics briefly by focusing on the preclinical development area (also known as the area of Chemical Manufacturing and Control, or CMC). Consi
Read more