KwickClips Databases and SQL

Databases and SQL: 71 short revision clips (page 2)

One idea per clip, with the answer written out underneath. Each clip links back to the full Databases and SQL lesson it came from.

How do you get the row count?44 secWhat makes a join an equi-join?41 secWhat happens if no column name matches?40 secWhat is a record?40 secWhich keyword sorts largest first?45 secWhy do marks get lost?42 secWhat is the difference between validation and verification?41 secWhich file extension does Base use?42 secWhat does one row of the Design View grid represent?40 secHow do you set a primary key in Base?41 secWhen is a record saved?41 secWhat is redundancy?41 secWhich relationship is most common?41 secWhere do you create a relationship?41 secWhat is an orphan record?40 secWhere do you start?41 secHow many fields go in one grid column?42 secHow do you write a text value?42 secDoes a hidden field still filter?41 secWhere does form data go?42 secWhat does New data only give?42 secCan a report change data?41 secPortrait or landscape: which is wide?41 sec