Access 2007 topics you may be tested on:

• Start Access

• Creating, naming, saving a database file

• Entering the structure for a database table:

  • entering field names, field types, field sizes

  • Setting the primary key

• Entering the data (i.e. records) in a table

• Creating and using Forms

• Using the Report Wizard to generate and name a report

• Entering queries: (*)

  • Displaying all fields, all records

  • Displaying only specific fields, in specific order

  • Using character data in a query, wildcards

  • Using numeric data, comparison operators, computed fields

  • Calculating statistics

  • Using compound criteria involving AND, involving OR

  • Joining tables in a query, restricting records in a join

  • Sorting records in a query, grouping records in a query

  • Parameter queries

  • Sort queries result

  • Creating queries with calculated field

  *: Creating queries is a very important part of working with a Database.  This will be weighted at 30%-40% of the test.  You should make every effort to study this part.  The best thing to do is to redo Tutorial 3.
  
  

• Changing the structure of the database:

  • Adding fields, changing fields, specifying format

  • Specifying default values, specifying a range, specifying required field, specifying legal values

  • Enforce referential integrity.

  • Add validation rules and/or validation text
    
    

• Adding/deleting records

• Establishing relationships and Use a sub-datasheet