Class Resources

Link to this page: www.noktra.com/class

Alternative link: www.xr.com/class

 

 

Slides and Such

 

Excel slides: Click Here

ICDL sets: Excel Basic & Intermediate

Advanced Filter Hands On

 

PowerPoint slides: Click Here

 

Word slides: Click Here

 

Access slides: Click Here

 

Quiz (STB Only)

www.xr.com/stbquiz

 

 

Feedback Form

www.noktra.com/comat74

Alternate link: www.xr.com/comat74

 

 

 

Advanced Function Exercise Page 132
No3:
=vlookup(C6,$B$15:$E$17,E6,false)

No 6:
=IF(H5>20000,"Yes","No")
No 8:
=IF(B5=1,0,IF(B5=2,0.05,IF(B5=3,0.075,0.1)))
No 10:
=IF(OR(B5=2,B5=4),0.05,0)
No 13:
=IF(ISERROR(AVERAGE(C5:C13)),"No data",AVERAGE(C5:C13))
 

 

Access Mini Database Design and Implementation Exercise

Mount View Community Hospital.

Scenario: In patients only and no follow-ups after discharge. Patients are treated for multiple ailments. Each patient can be treated by multiple doctors - but only one doctor per ailments per patient. A doctor can have expertise in many ailments.
 
Question: Create a simple database so that I can pick any patient and find out which doctors are treating her/him and for what. 
 
Hint:
  1. Start by describing the scenario using 3-word sentences and from there decide how many tables are needed.
  2. For each table, decide what columns (fields) are needed.
  3. Create the tables in the databse and relate them.
  4. Create queries to test if the question above can be answered.
Try the full project here.

 

Data Download

(Download instructions here)