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 (405) 492-6795‬

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

    Oklahoma City was settled during “The Land Run” at the end of the 1800s. Oklahoma City became a major stop on Route 66, one of the original highways in the country. Recently, Oklahoma City added water taxis to transport people along the downtown canal in the Bricktown neighborhood. Oklahoma City, because it is in Tornado Alley, has seen tornados every month of the year. Many museums make up Oklahoma City’s culture. Some of these include the National Cowboy & Western Heritage Museum, the American Banjo Museum, and the Museum of Osteology, which houses over 300 animal skeletons. Oklahoma City is home to one of the country's horse racetracks, which is open year-round. Another site worth noting is the Crystal Bridge in the Myriad Botanical Gardens in downtown Oklahoma City. The Myriad Gardens is home to the Water Stage, which is a stage surrounded by a moat of water. The construction of the Oklahoma City Streetcar, also located downtown, came about due to major growth over the last several years.  

    Major growth in Oklahoma City is a recent development, due to diversification of the economy. Oil and livestock are major pillars that helped start the economy of Oklahoma City. The major stockyards in Oklahoma City have been around since before World War II. After the war, Tinker Air Force Base brought in federal development. The federal government is one of the larger employers in Oklahoma City. Love’s Travel Stops and Sonic Drive-In headquarters are based in Oklahoma City. In the 1990s, Oklahoma City began a redevelopment plan known as the Metropolitan Area Projects. This has brought more development to the downtown area, with a baseball park, convention center and an entertainment district. Technology, health, and energy services also contribute to a more diversified Oklahoma City economy, which in turn has led to growth.  

    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