ACCESSible Database Solutions, Inc.
352-200-4704

• Access is a powerful tool that allows developers to create robust systems in a short amount of time.
• It is part of the Microsoft Office Professional Suite - You may already have Access installed
  Access integrates easily with Outlook, Excel, Word,etc
• Access is the most widely used Database system

What is a Relational Database? 

By and large, a database is a collection of information. Common collections of information include: the telephone book, the card catalog, your personal list of phone numbers and addresses contained in a Rolodex, or the entire record, contacts, billing, etc. collection of your business. 

The beauty of a relational database system is that you can store related data in separate tables. Then through defining relationships between the tables you can retrieve the information in the tables to use for making queries and writing reports. 

A database program like Access is software specially designed for managing a database. 

The four main elements of a relational database include

• tables for storing data 
• forms for entering and viewing data on the screen 
• queries for extracting specific information from the data (asking questions) 
• reports for printing query results 
  

If you have over 2gb of data, you want to consider having your data on a SQL Server and your front end developed in Access.

If you are going to have over 100 users, Access is not the front end for you.

You can use it to develop six general types of applications:

•  Personal applications
•  Small business applications
•  Departmental applications
•  Corporationwide applications
•  As a front end for enterprisewide client/server applications
•  Intranet/Internet applications