nowtmodule 2 Backgroundmodule 2 BackgroundModule 2 TasksModule 2 Write-upmodule 2 ChecklistModule 3 Backgroundmodule 3 TasksModule 3 Write-upModule 3 Checklistnowt
nowtlist: task 1list: task 2list: task 3list: task 4list: task 5List: task 6list: task 7list: task 8list: task 9before handing innowt
 

Check List for task 6 - Compare Excel and Access

When you started your project you were asked to choose between using MS Excel and MS Access. Two key factors should have informed your choice

  • Your package must comply with the data protection act with respect to client / patient confidentiality. This means that workers can only see the information they actually need to do thier job.
  • You need to ensure that data entry is made as easy as possible and that as few errors as possible are made.

Have you described the following features for the two pieces of software?

  1. The availability and ease of use of user forms
  2. The ability to limit data input with
    1. input masks
    2. Limiting the type of data input
  3. How it is possible to reduce data input errors using
    1. Default values
    2. Input masks
    3. Validation Rules

You may find it useful to look at the help file you used to set up the table with your clients / patients.
   

© LEV