Access Quiz

 Design  Access 

 object  object  table, query   object  table  design   table  object  query  design   query

 Cascade update 

 table  table   table   table  ( table  table )

 table  enforce referential integrity 

 enforce referential integrity   table   Access  ( table  table )  enforce referential integrity 

Referential Integrity 

  table  table  primary key 

Group by 



 table  primary key

  table   table  Microsoft Access  primary key  Microsoft Access  

 Access  Primary key 

  table   primary key   Access   primary key  

 Access  Null  field

  null  field  field  primary key

 Access   Enforce Referential Integrity 

 

 function  Query  field 



Group by  field  field  data type  text, number, date

  Group by  ( )

 table  field  table   field  primary key 

  primary key  record  table 

 table  field  table   field  primary key 

  primary key 

  Group by 

  Group by   () 

 Design Table  field 2 fields  table  primary key 

  field 2 fields  primary key ( field   combination key)