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

8. Lookup Field
9. Currency
10. Memo
11. Number
12. Primary Key
13. Foreign Key

11

2. 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

3. Queries
   1. Select query
   2. Aggregate
   3. Action                                       i.     Delete
      ii.     Append
       iii.     Update
       iv.     Make table

4. Calculated Fields in query
5. Criteria                  i.     Relation operator’s    
    ii.     And, or
    iii.     Like, between, in()
     iv.     *, ?
   11

4. 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

5. Macros

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

11

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

11

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

11

8. 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

9. 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