[Year 12 IT Apps] DB SAC

[Mike Brookes]

Hi All
Strictly speaking data should not be entered directly into tables but 
through a form linked to the table (and possibly other tables/queries)
.
It is appropriate to use combo boxes/lists/radio 
buttons/checkboxes/sliders etc on the form to make data entry 
easier/more accurate. Controls on forms can provide a greater variety of 
validation.
Controls on a form can also display calculated data or data from other 
linked tables

Mike Brookes
Semi retired gentleman of leisure
Copperfield College

On 26/05/2011 3:15 PM, Jackson Bates wrote:
> Hi All,
>
> Could someone address Mark Scott's other comment that drop down lists are inappropriate in tables?
>
> I'd assumed we could credit drop down lists in tables for validation purposes, since forms are not mandated in this study for unit 3.
>
> Please correct me if I'm wrong, since I've been merrily showing my kids how to do that and would hate to have to penalise them now :)
>
> Thanks,
>
> Jackson Bates
> Waverley Christian College
>
>