Listing Specified Fields in all Records

If the criteria field is cleared, chosen fields in all records will be displayed. Amend the 'cottages' query as shown below to print the ID, Address Line 1, Area and Central Heating fields for all records.

Amend the last query to:

  • List ID, Address Line 1, Area and Price.
  • List ID, Address Line 1, Type, Date of entry.
  • List ID, Address Line 1, Area, Postcode, Type, Date of entry.
  • List ID, Vendor, Type, Date of entry.

Contents: Databases

Skill Check: Databases