CCNC/CCNC Module 5/Designing and creating tables/Basic Table Operations/Self Assessment

From WikiEducator
Jump to: navigation, search
Tutorial.png 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

Self Assessment

Icon objectives.jpg


Upon completion of this self assessment the learner will:
  • Create a fully attributed database table
  • Create, Read, Update and Delete records from a database table
  • Navigate the records within a database table
  • Delete a database table
  • Close a database table

Icon activity.jpg

Portfolio Activity

Refer back to the database design work you did in the previous chapter. Choose either your design of a one-to-many or many-to-many relationship. Use this design to create two or more tables.

  1. Use the "Create Table in Design View..." option from the task panel.
  2. Once the design view is open, add the fields for your table design. Check the data types match your design.
  3. If you have identified a Primary Key set this field by right-clicking the leftmost column and select Primary Key.
  4. If you have no Primary Key add a field of type Integer and set the AutoValue to 'Yes'. This will be the Primary Key.
  5. Save the table
  6. Create another table using the same five steps. This second table should be a part of your chosen table relationship requested at the beginning of this activity.
  7. Once you have the two tables created, open each of them and add some records to each table. If you created some rules try and violate the rules by entering incorrect data.
  8. Save and close all the open database tables.