Skip to content
Question of 29

Q.(Question 12 — internal choice, attempt this

(OR)
the alternative) From the following information show a design table in M.S. Access:
Customer Id — Account No. — Name — Address — City — Balance (₹):
901 — 99262 — Sham Lal — Street No-2 — Mohali — 8,040
902 — 99269 — Sohan Lal — Akash Nagar — Ludhiana — 12,060
903 — 99563 — Monika — Vijay Nagar — Abohar — 20,080
904 — 99344 — Raj Kumar — Bagh Colony — Fazilka — 40,020
Punjab PsebPSEB Punjab Class 12 (Commerce) 2020Subjective· 6mImportance★★★★★
0% · 0/29 Questions
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

Define fields with data types in Design View, then enter the four records. (Computer Applications — out of current syllabus.)

In MS Access, a table is first created in Design View by specifying each field and its data type:

Field NameData Type
Customer IdNumber
Account No.Number
NameText (Short Text)
AddressText
CityText
BalanceCurrency (or Number)

Customer Id can be set as the Primary Key. After designing, the four records are entered in Datasheet View:

901 / 99262 / Sham Lal / Street No-2 / Mohali / 8,040

902 / 99269 / Sohan Lal / Akash Nagar / Ludhiana / 12,060 …

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.