Database Features - Data Entry (Forms)

Syllabus Detail

  • Data entry using forms. 11 GEN

Background

  • Forms are commonly used for entering information into a database
  • They're graphical user interfaces with command buttons and text boxes capable of entering, manipulating and even deleting data
  • Forms are the preferred method of data entry due to their graphical nature and ease of use

 

Example of a Form

 (Source)

  • Each set of information brought up belongs to a database record (row)
  • Forms refer to database columns in the form of textboxes
  • The textboxes present the data for existing fields, and act as entry points for new additions
  • The buttons down the bottom allow for navigating through records
  • Information written in the textboxes next to each label are saved as the column (or field) value

 

Further Research

  • Forms, queries and reports by GCF LearnFree here
  • Database basics by Microsoft here

 

Worksheet and Practice (yet to be added)

Found an error or have an enhancement? Please let us know via this contact form