DATABASE CREATION Create Database: open Access 2007->Blank Database->File Name-> location->Create TABLE CREATION Import Table: External Data->click on the appropriate type of Import file->… Assign Primary Key: Design View->click on anywhere in the field->Primary Key Assign Data Type: Design View->click on Data Type of the field->click on the arrow->select Include/Remove Totals: Datasheet View->Home->Totals->click on the Total row of the field->click on the arrow->select ->Totals again to remove the Total row Establish Relationships: Database Tools->Relationships->Add Tables/Queries->close Show Table dialog box->drag from the matching field in one table to the matching field in another table->check Enforce Referential Integrity ->Join Type-> select->OK->Create->close QUERY CREATION Create Query In Design View: Create->Query Design->Add Tables/Queries->close Show Table dialog box->add field(s) to the Field row->perform the actions below (optional)->Datasheet View · Determine Criteria: enter in the Criteria row of the field(s) o Simple Criteria: enter the value(enter Null for records that are null) o Complex Criteria: § use wildcards (e.g. * , ?) § use comparison operators (e.g. >, <, >=, <=, not, between-and, >and <) o Compound Criteria: § And: enter different criteria in the Criteria row of different fields § Or: enter different criteria in the Criteria row and Or row of different fields · Show/Not Show Records: check/uncheck the box(es) in the Show row of the field · Sort: click on the Sort row of the field to be sorted->click on the arrow-> select · Show Top Values: click on the arrow in Return->select · Add a Calculated Field: right click on the Field row of the first open field->Zoom/Build->enter/create expression (e.g. Calculated Field Name: [Table Name]![Field Name] +/-/*//[Table Name]! [Field Name]) ->OK · Group Calculations: Totals->click on the Total row of the field->select · Change Field Caption: click anywhere in the field->Property Sheet->click on the Caption box and enter-close the Property Sheet box · Make Table From Query Results: Make Table->… ->Run->… Create Find Duplicates/Unmatched Query: Create->Query Wizard->Find Duplicates /Unmatched Query Wizard->OK->… OTHERS Export Table/Query Results: select the table/query->External Data->click on the appropriate type of Export file->… Enable Database Content: Security Warning Options->Enable This Content->OK Show Tabbed Objects: Office Button->Access Options->Current Database->Tabbed Documents->OK… |