How to Make Invoice Software In MS Access – Without Coding In Hindi | Invoice Form Entry |

Tech/Product Concept

Build an invoice management system in Microsoft Access (MS Access 2016) that supports:

• Customer + line-item entry
  • Invoice form with subform/fields for items
• Automatic calculations
  • Amounts, GST, subtotal, and grand total
• Auto-generated identifiers
  • Invoice numbers, invoice dates, and serial numbers
• Printing and preview
  • Report-based printing via Print Preview + Ctrl+P
• Browsing and search
  • Browse reports and search by invoice number
• UI automation
  • Use buttons + macros to open reports, filter by invoice number, and navigate

---

Main Workflow (Tutorial)

1) Create the database

1. Start MS Access
2. Choose Blank database
3. Name it (e.g., Invoice Maker)

---

2) Design tables (no coding)

Table 1: Customer Details

• Fields:
  • Customer ID
  • Full Name
  • Address
  • GST
  • Invoice Number (AutoNumber)
  • Invoice Date (Date/Time with default = Date())
  • Mobile
  • Email
• Set Invoice Number as the Primary Key

Table 2: Items / Invoice Line Items

• Fields:
  • Serial Number (Number)
  • Item Name
  • Quantity
  • Price (Currency)
  • GST (text/percentage)
  • Amount (calculated via expression Quantity * Price)
  • Subtotal
  • GST
  • Grand Total
• Use Access calculated/expression style for fields like Amount (and later formulas via control Control Source or property sheets).

---

3) Create relationships

• Create a relationship between the Customer table and Items table using:
  • Invoice Number

---

4) Create a query

• Create a query that joins/selects relevant fields from both tables to power:
  • the form
  • and the report
• Includes:
  • customer details
  • item/financial fields

---

5) Build the invoice entry form

• Use Form Wizard with the query as the record source
• Select “form with subforms below” so invoice line rows appear within the invoice
• Then design/format the UI:
  • Header (firm name, logo, styling)
  • Detail section (textboxes for each item row)
  • Footer (Subtotal, GST, Grand Total)
• In the form footer, add computed fields using Add Existing Fields

---

Automatic Calculations & Formulas (Key Analysis)

• Invoice Number & Invoice Date
  • Invoice Number: AutoNumber
  • Invoice Date: default set to Date()
• Serial Number
  • Set using a formula like Current record + 1
  • Paste into the control’s Default value
• Subtotal
  • Expression based on the sum of Quantity * Price across line items
• GST
  • Formula based on:
    • (Quantity * Price * GST% / 100)
  • Summed across items
• Grand Total
  • Subtotal + GST
• The tutorial emphasizes:
  • totals should compute automatically when line items are entered
  • the user should not manually calculate totals

---

Buttons, Reports, and Navigation (Product Features)

Buttons on the form

• Save (record operations)
• New Entry (add a new record)

Reports

• Create an Invoice report using Report Wizard from the invoice query
• Design report layout:
  • Header (firm name/logo/address/phone/email/GST)
  • Styled line-item table
  • Subtotal/tax/grand-total block
  • Terms & conditions
  • Signature area
• Set page size to A4
• Adjust sorting and serial order

Macros for report automation

• Create macros to open specific reports based on conditions, e.g.:
  • Invoice Number = [Forms]![Invoice Entry]![Invoice Number]
• Used for:
  • Print Preview for the current invoice
  • Search invoice by invoice number (with a prompt)
  • All Reports / browsing saved invoices

---

Print & Preview Behavior (Important Tutorial Details)

• Reports open in Print Preview
• Printing may be done via:
  • a dedicated print button (sometimes not present in preview)
  • or Ctrl + P directly from Print Preview
• The demo shows invoices such as Invoice #1, #2, #3, using next/previous navigation in reports

---

Final Validation Shown

• Create multiple invoice entries via the form
• Use:
  • All Reports to view invoices
  • Print Preview to print a selected invoice
  • Search Invoice to enter an invoice number (e.g., 2 or 3) and open that invoice’s report

---

Main Speakers / Sources

• Single presenter / tutorial voice
  • “friends” (Hindi/English style with auto-subtitles), demonstrating MS Access invoice building steps
• Source (YouTube Video Title)
  • “How to Make Invoice Software In MS Access – Without Coding In Hindi | Invoice Form Entry”