Microsoft Access Programmer: I have been a Microsoft Access programmer
since Access version 2.0 (released in 1993). Versions release since then are Access
95, Access 97, Access 2000, Access XP (or Access 2002), Access 2003, Access 2007,
and now Access 2010.
Microsoft Access can be a nice tool for creating databases quickly. Often, even
persons having no formal training or experience as a programmer can make good use
of Microsoft Access wizards or templates to create a database. A Microsoft Access
programmer can go further by employing principles of good database schema design,
efficiently designed queries, forms, and reports, as well as making use of VBA coding.
Existing Microsoft Access Database
If you have an existing Microsoft Access database, and you think you would benefit
from having a Microsoft Access programmer make some additional changes and enhancements
to that database, please let me know. Send me an email describing a little about
what you have in mind. I may have some additional questions for you to help me understand
your needs in more detail, and to determine how I might best be of help.
If you believe you have reached the limits of what Microsoft Access can handle,
and you would like to explore other options, I can help with that too. There are
limits to the amount of data that can be contained within a single Microsoft Access
database. You may want to enlist the aid of a programmer to see if it might make
sense to:
- Redesign the Access tables for more efficient storage
- Split the Microsoft Access data among multiple Access databases
- Upsize the Access data to Microsoft SQL Server
Microsoft Access Table Redesign
It may be that your Access database tables are not structured as well as they could
be. A Microsoft Access programmer may be able to redesign your tables in a way that
would result in more efficient storage of data.
Split into Multiple Access Databases
Although there are limits to the amount of data within a single Access database,
you can sometimes work around this limitation by placing some tables in a separate
database, and then linking that database to the original.
Upsize from Microsoft Access to Microsoft SQL Server
It may be time to consider upsizing the Access data to Microsoft SQL Server. A Microsoft
Access programmer can often move the data out of your Access database and into SQL
Server while keeping your forms, reports, and queries intact within your original
Access database.
There may be other options open to you as well. Please get in touch with me at your
earliest convenience to see how I might be of service.