Testing MS Access database
What things should be taken into account while testing an Access database?
Â
While testing an Access database, following things should be taken into account -
- If the database is creating Web pages from the datbase to a URL, is the information correct and updated? If the pages are not dynamic or Active Server pages, they will not update automatically.
- If the tables in the database are linked to another database, make sure that all the links are active and giving reevant information.
- Are the fields such as zip code, phone numbers, dates, currency, and social security number formateed properly?
- If there are formulas in the database, do they work? How will they take care of updates if numbers change (for example, updating taxes)?
- Do the forms populate the correct tables?
- Is the database secure?