accessWORKS - Microsoft Access Database Consulting

New York City based Access Database Freelance Consultant (VBA, SQL)

Home     About Us     Samples     Clients/Testimonials     Contact Us     Site Map      
Architect Spec Book - Access 2007
Order Tracking/Inventory
Outlook/Word Integration
Query/Report Builder
Import/Export Processing
Report Selector/Builder
HR Staff Profiler
Excel Access Integration
Subform Drill-down
< To view samples, click on side menu.
 
Samples and Product highlights
 
Microsoft Access Database is a relational desktop database system from Microsoft, packaged with Microsoft Office Professional which combines the Jet relational database engine with a graphical interface. The development environment provides productivity-enhancing features. It can use data stored in Microsoft Access/Jet, SQL Server, Oracle, or any ODBC-compliant data container. Skilled users and data architects use it to develop powerful, complex applications. Relatively unskilled programmers and non-programmer "power users" can use it to build simple applications without having to deal with features they don't understand. It supports substantial object-oriented (OO) techniques .

Microsoft Access is widely used by businesses and programmers to create ad hoc customized systems. Its ease of use and powerful design tools give the programmer a lot of power for little effort. However, this ease of use can be misleading. This sort of power user is often an office worker with little or no training in application or data design. Because Ms Access makes it possible even for such developers to create usable systems, many are misled into thinking that the tool itself is limited to such applications.

Some professional application creators use Microsoft Access Database for rapid application development, especially for the creation of prototypes and standalone applications that serve as tools for on-the-road salesmen. Applications that are used by more than a handful of people tend to rely on a Client-Server based solution such as Oracle, DB2, Microsoft SQL Server, PostgreSQL, MySQL, or MaxDB. However, an Microsoft Access "front end" (the forms, reports, queries and VB code) can be used against a host of database backends, including Ms Access itself, SQL Server, Oracle, and any other ODBC-compliant product. This approach allows the developer to move a matured application's data to a more powerful server without sacrificing the development already in place.

 
 < To view samples, click on side menu.