Access Databases

Microsoft Access is a database management system that comes with Microsoft Office Professional. Access allows tables, data entry forms, filtered data views and reports to be easily designed and incorporated into a unified database for your business. An Access database can be used to store prospects, customers, employees, sales and production information.

What Access Database Services do I provide?

I can provide Access database support and consulting to fix performance, usability, design or corruption problems. I can also design a new Access database for your business, assist you with migrating your existing Access database to a SQL Server back-end, provide a web-based forms front-end for your Access database, provide reporting solutions and assist with importing and export data.

What are the advantages of using Microsoft Access?

  • A database can be developed in Access quickly
  • Microsoft Access is cheaper than many other database systems
  • The Access database can be shared by a few users
  • Microsoft Access has detailed and powerful reporting capabilities.
  • The back-end Access database can be migrated to Microsoft SQL Server when database becomes larger or the number of users increases

What are the disadvantages of using Microsoft Access?

  • Microsoft Access databases developed by internal business staff often need to be modified by a database professional to incorporate better database design principals to overcome performance, usability and reliability issues.
  • Access databases are often slow and suffer performance problems when used by more than a few users.
  • Microsoft Access databases can experience performance problems when a database grows large.
  • Access databases can become corrupt, stopping you from accessing your data.

What versions of Microsoft Access do you support?

I support Microsoft Access 97, Access 2000, Access 2003 and Access 2007.

What is the next step?

if you are in Perth, Western Australia, then Contact me to organise a time for your first free consultation.

Return to Services web page

 

Microsoft Access Services

Access Database Design
SQL Query & View Design
Access Report Design
Access Form Design
VBA programming
Front-end & back-end separation
Access performance improvements
Data import and data export
Migrate Access databases
Advise whether Microsoft Access is suitable for your business

Other Software Services

Custom Database Applications
Web Development
Covert Web Design to Web Pages
Rich Internet Applications
Desktop Applications
Computer Programming / Coding
Systems Analysis & Design Consulting
Database Support
Database Administration
Web Hosting
Web Security
Document Conversion
Find out more