|
|
Jargon Dictionary |
Microsoft AccessAccess is a piece of software which allows us to create a database system with great speed and flexibility. The data is stored in tables, which look a bit like Excel spreadsheets. These tables can be linked together to produce queries (selective views of your information). Attractive, intuitive screens can also be produced (called forms) and there is a report generator built in too. Using Wizards (step-by-step procedures) which lead you through common tasks, it's possible to produce a simple database very rapidly. Although this method is somewhat limiting in terms of what one can achieve, there is also a programming language built in to Access, called VBA (?) or Visual Basic for Applications. This allows someone with programming knowledge to produce much more sophisticated database systems. Sometimes, Access databases are used as "front ends" to SQL (?) Server databases, offering the forms and reporting of Access, combined with the extra security and speed of SQL. Or an Access database may be used as the "back end" to a VB.net (?) or ASP.net (?) system, providing the tables of data for the system. |
|
Close
|