Access Database Solutions
Introduction
Our lead engineer has over 20,000 hours of Microsoft Access development experience across a wide range of database projects. Our expertise is unmatched, and we can offer our experience to solve various Microsoft Access challenges. Here are some of the services we provide:
Level 1
- Fix startup issues: Your database may not start due to an internal error or because older Microsoft Access databases (.mdb) are incompatible with current versions of Microsoft Office (.accdb). These may need to be converted.
- Fix functionality: Your Access Database may have incomplete or defective parts that need fixing. This can include minor enhancements to increase capability.
- Extract data: You may want to extract data from an Access Database into another database like SQL Server, PostgreSQL, or Excel. This is often done as IT support staff can manage the other database format.
- Resolve data structure issues: Sometimes your database's capability is limited due to structural issues with the data. For example, a non-normalized database can cause various limitations or problems. Often, fact tables or lookup tables are missing, leading to data quality issues. This work may also require data cleansing.
- Enhancements: You may need enhancements to the database to provide necessary capabilities. For instance, if you are missing a key piece of information in one of your tables, the table needs to include the new field, and queries, forms, and reports may need updating.
- Split database files: Your database should be split into a Front-End database file and a Back-End database file. This allows you to update your queries, forms, reports, or code without overwriting your data. It also enables your database to function as a file-server multi-user system.
Level 2
- Create a custom user interface: Your database can be enhanced with custom menus that replace the Office Ribbon Menu, significantly improving usability by displaying only relevant commands. This can reduce anxiety for both current and new users. The custom menu can include links to help and training files as well as other resources.
- Convert to client-server: Your back-end data file can be converted to a server-based database engine like SQL Server or PostgreSQL. This allows the server to process your queries and data access, utilizing its increased efficiency and capacity. Your front-end can remain in Microsoft Access, using the backend database engine to process all data requests while providing the user interface for the database.
- Convert the front-end to a compiled application: Your front-end can be converted from Access into a compiled language, like Microsoft's C#. This allows the front-end to be compiled into an .exe application file. The back-end can remain in Microsoft Access or be converted to a client-server database engine.
- Convert both the front-end and back-end: Your front-end can be converted from Access into a compiled language, and the back-end can be converted to a client-server database. For example, converting the front-end to C# and the back-end to PostgreSQL eliminates the need for Microsoft Access on client machines and reduces licensing costs.
Level 3
- Design a database solution from the ground up: We can build your database solution from the ground up with your choice of front-end and back-end architectures.
Contact Us
Please contact us to discuss how we can best meet your needs. If you are in the Canberra region, we are happy to meet face-to-face. For areas outside Canberra, we are available for video conferencing.