CDVSA > Grantee Support > Database Support

Database Support

 

For assistance with database issues and the CDVSA Reporter tool contact CDVSA's Research Analyst at bahiyyih.parish@alaska.gov or by phone at (907)465-4673.

ANDVSA Database CDVSA Reporter Tool User Guide

  • ANDVSA 4.0 User Guide
    This Guide is for an earlier version and is soon to be updated, but it may be still helpful)
  • ANDVSA Version 6 Beta
    This is the current Database File for Grantees. Download this file to your computer. Don’t open it on your personal computer. Bring the file to your Program’s data computer and add the file extension .MDB to the end of the file name in order to be able to open and use the database file. If you need assistance call the CDVSA’s Research Analyst at (907)465-4673.

Q: What database version are we supposed to be on?
A: As of November 2014, CDVSA Programs should be running Version 7.0 of the ANDVSA Microsoft Access Database program. If you need the latest version installed and/or need any type of assstance, email the CDVSA's Research Analyst at bahiyyih.parish@alaska.gov or call (907)465-4673

Q: How does data reporting work from programs to CDVSA?
A: When yearly, quarterly, or other reports are needed, the CDVSA’s Research Analyst will email a request for that report, including instructions for how to complete the request. Anyone who has patience and can operate a mouse should be able to follow the long version of the instructions, though they may need assistance over the phone. In order for the report to be accurate, the database will need to have had all of its data entered for the time period covered by the report. Reports will never be requested that require data that is less than a month old.

Q: What causes the reports in the database program to generate what appear to be incorrect results?
A: Three different reasons are possible:

  • Something is wrong with the underlying data. Looking at the Quality Control Queries, accessible from the main screen, may enable you to diagnose problems with missing or incorrect data. The Services Provided Report, from the Reporting Menu may also help.
  • The report may be correct, but may be counting the data differently from how you expect. For example, the report for the Family Violence Prevention and Services Act grant (FVPSA) only counts participants who received services during the reporting period, who never received services from your program before the reporting period.
  • A report has an error in its construction. If you are confident that the data you entered is correct, and that a report is not representing this data correctly, then there may me an error in how the report was made. Building reports is complex, and mistakes happen. Please contact the research analyst if you suspect an error in a report, so that the research analyst can fix it in the next version of the database. Thank you!

Q: Should I be making backups of the database? When? How?
A: Yes. It is best to make an “off computer” backup of the back end of the database at the minimum quarterly. Please ask the research analyst for help with this process, as, if it is not done correctly, it can result in catastrophic data loss. The backups contains highly sensitive information, and must be clearly identified and kept in a very secure location, or they may be kept on a secure USB key (with buttons for a password). Contact the Research Analyst if you have any questions or would like assistance.

Q: How should I record a certain incident or service?
A: If you have questions about how to keep track of data on your forms, the first place to look is the Guide to Victim Service Forms above. If you are still unsure, then please feel free to contact the CDVSA’s Research Analyst, at bahiyyih.parish@alaska.gov, or (907)465-4673, with your questions.

Do you have any question you think should be listed here? Email bahiyyih.parish@alaska.gov