CCNC/CCNC Module 5/Designing and creating tables/Basic Table Operations/Add Records
Basic Table Operations |
Creating a Table | Design a Table | Open a Table | Add Records | Edit a Table | Navigate a Table | Close a Table | Delete a Table | Self Assessment | Summary & FAQs |
Contents
Adding Records
Upon completion of this tutorial the learner will be able to:
|
Add Record
Once the table is open, navigating the fields is like moving around the cells of a spreadsheet. Click the field to edit it, or use the arrow keys to move around. The left most column will indicate the action, if a green arrow head is present to the left of the row it is the active row being edited. If a yellow star is present it is a new entry.
Missing Data
If it is both a new row and it is active as the row being edited both the green arrow head and the yellow star will be present in the leftmost column. if you add data to a row that is incomplete (i.e. it does not contain entries in all the mandatory fields) an error will occur.
Error Message
This error message provides the name of the missing field. The last_name field is mandatory so when the database tried to save the new record it could not. Close the error dialog, correct the data entry problem and try to save the record again.
Test your knowledge