Developing Microsoft Access Programs with
Advanced Database Solutions

Advanced Database Solutions recommends Microsoft Access to clients who need a small to medium sized system that can handle up to 20 simultaneous users. MS Access programming rates tend to be lower than other options, and production speeds tend to be quicker. ADS has a large active client base, with new Access programs going live on a weekly basis!

Some examples of our custom Microsoft Access business software include inventory management software, project tracking databases, employee monitoring software, payroll and time tracking databases, and sales CRM (customer relations management), and more! To find out if using MS Access is the best choice for your business, call us at 1 (980) 221-1120‬

access

Positives of working with Access

  • Has the ability to easily add or remove features.
  • Adaptable to grow along with your business.
  • Created and maintained by Microsoft instead of a third party.

    • MS Access has every feature a business needs to handle workflow control, management, reporting and automation.

    sql

    Negatives of working with Access

  • Impractical as a core database for larger companies due to capacity limits of about 2GB.
  • Lacks capacity to support multiple concurrent users like Microsoft SQL Server.
  • Only available for one office location as a stand-alone program.

    • MS access is not reccommended for large scale companies with over 20 users or multiple locations

    Charlotte is named after Charlotte of Mecklenburg-Strelitz, a German princess from the mid 1700s. One of the oldest public libraries in the state, the Carnegie Library, was started with a donation from Andrew Carnegie, a philanthropist and one of the richest Americans in history. The library opened in Charlotte at the beginning of the 1900s. Other places of interest, in Charlotte, include the NASCAR Hall of Fame, the Carowinds amusement park, and the Mint Museum of Art. The U. S. National Whitewater Center, which is a training facility for many outdoor sports, such as kayaking, whitewater rafting, hiking, and ice skating, is located near Charlotte. The Carolina Renaissance Festival, one of the biggest in the country, along with the Yiasou Greek Festival, the Breakaway Music Festival and the Heroes Convention, a comic book convention, happen each year in Charlotte and draw many visitors.  

    While tourism is not at the top of the local economy, Charlotte is home to a diverse group of businesses, such as: Coca-Cola, Lowe’s, Lending Tree, and Rack Room Shoes that play a big part in the economy. Charlotte houses the east coast headquarters for Microsoft, Wells Fargo and Credit Karma as well as the corporate headquarters for Bank of America. Charlotte is one of the largest banking headquarters in the country. Other companies that have headquarters in Charlotte include Honeywell and the Dole Food Company. The motorsports industry is a large part of Charlotte’s economy, as more than half of the NASCAR teams, employees and drivers are in and around the city area. Since the beginning of the 2000s, several thousand jobs have been created in the energy sector. Due to the area becoming more energy intensive, Charlotte has received the nickname “The New Energy Capital.” Freight transportation and trucking have also added to the economy over the last several years. Due to the diversity in its economy and its growth, Charlotte has made the list of “Best Places for Business and Careers.”  

    Here are some helpful links for more information for the software product Microsoft Access:

    What's new in Access 365? MS Access Database Basics Download Microsoft Access 2016 Runtime Version Download Microsoft Access 2013 Runtime Version Download Microsoft Access 2010 Runtime Version Basic tasks for an Access desktop database Microsoft Access Wikipedia