Text field numeric field date and time field 2 what

This preview shows page 6 - 9 out of 20 pages.

Text Field Numeric Field Date and Time Field 2. What does the term ‘attribute’ refer to in relation to developing a table?
3. Describe three database usage and user requirements you will need to think about before developing a database.
4. Give three examples of data considerations.
Activity 1C: 1. Lay out the four steps you will need to take create a primary key in Access 2010. Right-click the relevant table and click Design View
Choose the field that will be the primary key. (To choose more than one, hold CTRL and click the appropriate fields). Reference BSBITU301 learners guide page 2. Why do you need to create a primary key for tables?
3. Briefly describe two ways that you could modify an existing table layout.
CBC-BSBITU301-A-V2019.2 Page 6 of 20
Canterbury Business College CRICOS Code – 01899K RTO Code - 6554 Another is by changing values of fields. In the navigation pane, right click the table that you want to change then click design view. Then select the field that you want to change then type the value and save your changes. 4. Briefly describe how to create a relationship between two tables. If you are using Access, click the ‘relationships’ window. You will need to select one or more tables, before clicking the ‘add’ button. Then, you can move one or more fields from one table into another table, which should bring up an ‘edit relationships’ dialogue box. Click ‘create’ when you have finished making any necessary adjustments to finalise the relationship. Reference BSBITU301 learners guide page 23 Activity 1D: 1. Give examples of three ways that you could modify table layouts or field attributes. Delete columns or rows
Reference BSBITU301 learners guide page 25 CBC-BSBITU301-A-V2019.2 Page 7 of 20
Canterbury Business College CRICOS Code – 01899K RTO Code - 6554 2. Create a simple database with at least related two tables using a software of your choice. Use at least one for formula.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture