Task 3 Guide

Fields, Data Types and Primary Key

Choose suitable column types and use LoanID as the primary key equivalent.

Steps

  1. 1 Rename the default Title field to ItemName if needed.
  2. 2 Add LoanID as a single line of text field.
  3. 3 Make LoanID required and enforce unique values where the setting is available.
  4. 4 Add choice, date/time, yes/no, currency and notes fields for the loan data.
  5. 5 Enter LoanID values like LOAN-001, LOAN-002 and LOAN-003.

Recommended Fields

Field Type Example Purpose
LoanID Single line of text LOAN-001 Unique identifier for each loan record
ItemName Single line of text Canon camera Name of the borrowed item
Category Choice Camera Groups items into consistent categories
BorrowerName Single line of text Jordan Lee Person borrowing the item
YearLevel Choice or Number 12 Year group of the borrower
DateBorrowed Date and time 2/6/2026 Date the loan began
DueDate Date and time 9/6/2026 Date the item should be returned
Returned Yes/No No Current loan status
DateReturned Date and time 8/6/2026 Actual return date
ConditionOut Choice Good Condition when borrowed
ConditionIn Choice Damaged Condition when returned
ReplacementCost Currency $85.00 Approximate replacement cost
Notes Multiple lines of text Missing cable Longer follow-up notes

Official Microsoft References

Microsoft Lists mobile apps retirement

Use Microsoft Lists in the browser on iPad. The iOS and Android Lists mobile apps were retired in mid-November 2025.

 Create a list

Students create the database as a blank Microsoft List.

 Column types and options

Column types are used as the practical equivalent of database field data types.

 Create, change or delete a view

Saved list views are used as query and report outputs.

 Unique columns

LoanID is treated as the primary key equivalent using required unique values where available.