We Talk Coding
Microsoft Access - Databases?
Hi, we've been given a few questions in class to do with microsoft access and creating databases. Strangely enough though, we'vew never used the program before and they're asking us to answer questions about it, which seems a little odd. I've answered as many as I possibly can, but am confused with a couple and as, as said previously, I've never used it before, I really do have no clue as to what the answers may be. They are: 1) What is the purpose of a databse, and how will it make some company's run more efficiently? 2)What is validation, and why is is to important? What could go wrong if validation was not used? 3)If you had 3 linked tables, how would the database work overall? 4) Once the data is inputted, how can the data be processed? 5)Why is microsoft access such a good choice of program for creating databases? Many thanks!!
Public Comments
- 1) Databases allow storage/retrieval of information. They also provide mechanisms to relate data for more efficient storage and analysis. 2) Validation - At least make a guess at this one. Hint, garbage in, garbage out. 3) Linked tables can enforce data integrity and/or relate information from multiple tables. 4) Databases provide many ways to access data. SQL, triggers, external applications connecting via connectors (ODBC, JDBC, or direct API calls) 5) Microsoft Access is not a great choice as a database for anything large. The multi-user support is weak compared to free (MySQL) and commercial alternatives (Oracle, Sybase, Informix, etc...).
