Student Name:

Date:

 

 

 

 

CIS 78 Final Project Scoring

Comment

Yes

No

Total

  1. Tables – Field types
    1. Text
    2. Number
    3. Auto number
    4. Date/Time
    5. Yes/No
    6. OLE
    7. Hyperlink                         i.     Word
      ii.     Excel
      iii.     Http:
       
      iv.     JPG, GIF, BMP, JPN
      v. e-mail
      vi. bookmark
    1. Lookup Field
    2. Currency
    3. Memo
    4. Number
    5. Primary Key
    6. Foreign Key

11

 

 

 

 

  1. Forms
    1. Custom form
    2. Sub form
    3. Query list box
    4. Reports list box           
    5. Switchboard
    6. Reports switch board
    7. Queries switch board
    8. Main Switch board

11

 

 

 

 

  1. Queries
    1. Select query
    2. Aggregate
    3. Action                                       i.     Delete
      ii.     Append
       
      iii.     Update
       
      iv.     Make table
    1. Calculated Fields in query
    2. Criteria                  i.     Relation operator’s    
       
      ii.     And, or
       
      iii.     Like, between, in()
       
      iv.     *, ?
      11

 

 

 

 

  1. Reports
    1. Report Header – Date – Logo – Report Writer
    2. Page Header  - labels
    3. Group Header – at least one.
    4. Detail
    5. Group Footer – calculated fields
    6. Report footer – calculated fields
    7. Page Footer
    8. Report based on table
    9. Report based on query

11

 

 

 

 

  1. Macros
    1. switch board
    2. reports list box
    3. query list box
    4. event procedures

11

 

 

 

 

  1. Modules  
    1. Function’s
    2. Sub procedure’s
    3. Event procedures
    4. Form event procedures

11

 

 

 

 

  1. Pages
    1. Static
    2. Dynamic
    3. Data access page

11

 

 

 

 

  1. Relationships
    1. One to many
    2. One to one
    3. Many to many
    4. Right outer
    5. Left outer
    6. Inner
    7. Self Join

11

 

 

 

 

  1. Startup –
    1. Boot into switch board
    2. User unable to change anything.
    3. One entry point and one exit point out of the program.
    4. Compact

11

 

 

 

 

Total 99