Data Center & Security
Do you have questions or need help?
Latest Blog Posts
Since it’s inception, Microsoft Access has been the go-to database for businesses of all shapes and sizes. Not surprisingly, as Access’s features and cloud capability have rapidly expanded over the years, so too have the different ways the technology is used. Here are a few of our favorites:
There are few things more valuable to a business than properly onboarding and training new employees. While for most companies the ROI on hiring and app developer for a training application wouldn’t be high enough to justify the cost, building them in house is an appealing option. And as the company’s hiring scales, moving the backend of the app to a server like Microsoft SQL Server will be a low-cost way to scale your training app with it.
For many small businesses, CRMs like Salesforce or Microsoft Dynamics are either too expensive or too cumbersome to implement. However, having accurate, up-to-date customer and prospect information is crucial to running client-facing departments . As an MS Access user, it’s more than likely that much of this data already exists there. By standardizing this information and creating relational tables for objects like leads and deals, you too can have a CRM without the cost and learning curve.
While we’re on the subject of prospects and customers, many of them will want to access some of the data that you store in your web database – for example, recent invoices or the date of their next appointment. You can easily deliver this data easily by offering them a form they can fill out on your site. ASP.NET forms can query a Microsoft Access online database directly, so by implementing them on your site, you can surface this data to your customers with limited effort from your developers.
If you’re like many, you’re using an endless string of VLOOKUPs in Excel to report on related data from different tables or sources. This is really a job for Microsoft Access’ relational tables. Built on top of Microsoft’s Jet Database Engine, you can use these powerful tools to easily create queries that quite literally fly.
If you’re in software development, one common practice you’re likely familiar with is creating waterfall models to manage the progress of an application. Since you may be creating an application that leverages Access or SQL Servers as your backend, why not keep track of your app’s progress there as well?
These are just a few of many ideas for uses for MS Access – the beauty of the software is that it’s uses are really only limited to the imagination<.
The database market is divided among four major players: MS Access, Oracle, SQL Server and MySQL. Due to accessibility and focus on user interface, MS Access has garnered some negative press as being unsuitable for professional level database development. However, depending on the needs of the organization, there are many compelling reasons to choose MS Access as your business database software.
MS Access is bundled with the MS Office suite, making it the most widely available desktop database program in the world. This also makes it one of the most affordable options for businesses, which tend to purchase businesses licenses of MS Office. The common interface among all the MS Office programs makes it easy to import and move data to and from the database without having to resort to specialized software. Due to the popularity of the product, support for MS Access is also very good, with plenty of online tutorials and articles available, in addition to Microsoft’s excellent customer service.
One of the main benefits of MS Access is its ease of use. Even users new to database development can pick up the basics quite easily, as everything is presented in an intuitive manner. Much of the user interface in MS Access is designed to assist users with creating and editing tables, and there are many templates available to ensure that the database meets organizational needs. MS Access also provides options for importing data from other databases, and provides troubleshooting tips for every step of the way.
Despite this focus on ease of use, MS Access users have access to powerful SQL tools that allow for rapid development. MS Access is also .NET friendly, meaning that developers wanting finer control of software development can take advantage of the ease of use and functionality of MS Access.
Due to the widespread popularity of MS Access, there are many third-party plugins and developmental tools that are available. This means that MS Access is far more flexible than other databases, making it easier to customize and adapt to the changing needs of your business. In addition, there are many more external consultants well-versed in MS Access, and they are generally more affordable than consultants for Oracle and SQL Server.
MS Access is an excellent database choice if your organization requires a database that is easy to use and that has established, reputable support structures. MS Access is powerful enough to meet the demands of most small to medium businesses.
Best of all you can utilize Access Hosting superior hosting infrastructure to further bolster your Access Database and get it in the cloud easily and securely. All of our services offer a free 30 day trial so that you can easily test everything with Microsoft Access to make sure that it meets your needs.
The foundation for any database software, like MS Access, is the ability to send a query. Organizing information and making it accessible on demand is what makes database software so powerful. Understanding how to craft queries can be challenging at first, but once you understand how to use select, action, parameter and aggregate queries, then you’re on your way to expertise. For truly complex queries and more complete data sets, you need to understand what query joins are, what they do and how they work.
When working with an online database, there are four basic types of query joins: inner, left, right and full. These descriptors tell you where the web database is looking for the requested information.
When creating join queries, you must first create joins between tables and relationships between fields. When the “Join Properties” dialog box pops up in the Access web app, you will see three sets of options:
First, you will need to select the left and right tables you want to join. There will be a drop-down list with all of the available tables. Designate the first one you want to work with as the left table and the second as the right table.
Next, you will need to select the columns to look at for each query. This allows the database on the web to only search for information in relation to those columns. There will be a drop-down list with all of the column names available. Select the column on the left and right tables you will be working with.
At the bottom of the dialog box are three options. These options are for creating a left, right or inner query. Select the type of query you want to use and move on to creating output fields.
Using join queries effectively allows you to do things like segment your mailing list for targeted marketing, find customer accounts more quickly and accurately, build customized reports and more.
Access Hosting is proud to announce that for 2015 we have increased the storage quotas on all of our Remote Desktop Hosting plans for customers seeking an easy way to move their Access Hosting Database to the web without any modifications.
Access Hosting, the leading hosting company for Microsoft Access services and solutions has doubled and tripled the storage on their Access Remote Desktop plans. Customers in need of bringing their Microsoft Access web application to the cloud can now do so without the need for expensive hardware or costly setup.
Interested customers will now enjoy 2GB of storage with the $29/month Access Pro Virtual Desktop and 3GB of storage with the $49/month Office Pro Plus Remote Desktop plan. Anyone interested in trying out this hosting service can sign up for a free 30 day trial at http://accesshosting.com/remote-desktop-hosting/free-trial
Remote Desktop Services allows you to keep your Access 2007, 2010, or 2013 Database running “as-is” online in the cloud. Using the latest advances in Microsoft Hypervisor technology we can create a seamless single click operating environment for your existing Access database that allows you to run your application without modification. This approach allows multiple users to connect concurrently to the cloud from any PC and experience the program as if it was running locally on their desktop. Pricing starts at just $19/month and we offer a free trial for qualified customers. You can learn more at http://accesshosting.com/remote-desktop-hosting/
Have you considered running your Access Database on the web with Sharepoint and Access Services?
Access Services does not support all the data types, relationships, objects, or events that the full Access client provides. If you’ve created a web database from the start, only the supported elements will be shown during the design process. For those who have not created a web database from scratch, it is still possible to get your regular Access database up to the web with Access Services.
Access 2010 includes the “Web Compatibility Checker” tool. This tool checks the web compatibility of the tables in a database as well as web objects. However, the tool does not check any data within the actual tables and does not check linked tables from other data sources.
The goal of this tool is to make sure that the database is “web-legal” and to get you up and running with Access Services in a functional manner.
To run the Web Compatibility Checker tool in Access 2010:
1. Go to FILE > Save & Publish
2. Click “Publish to Access Services”
3. Click “Run Compatibility Checker”
Once you’ve completed this process and fixed any errors, the next step is to get the database up to a Sharepoint server. You can get up and running with a Sharepoint 2010 Enterprise server for as low as $49 per month from AccessHosting.com
One of the most important changes with Access 2013 and their new web apps is in the architecture itself.
In SharePoint 2010, Access Web Services was storing everything in SharePoint (and then SharePoint’s content was backed up by SQL). Access 2013 apps are hosted by SharePoint 2013 while the data is stored in SQL Server 2012. SharePoint 2013 provides authentication, authorization, and security for Access 2013 apps. The back-end tables, views, macros, and queries are stored in an SQL Server 2012 database. This change in architecture reflects a substantial change in the way Access Services works.
You will notice that SQL stores tables, views, macros and queries but there’s no mention about reporting. That is because Access 2013 Web Apps do not allow you to create traditional Access reports. The only way to do reporting is by connecting the local Access software program to the SQL tables directly or using some other compatible reporting software tool.
There are a lot of advantages of using Access 2013 with SharePoint 2013, but it is important for Access Developer to note the following:
Access Hosting is committed to supporting the Access Developer community and will continue to offer SharePoint 2010 Access Web Services hosting for as long as developers are interested. SharePoint 2013 Access Web apps do have a ton of advantages, and we have launched our brand new Access 2013 SharePoint 2013 hosting packages. If you are interested in a free trial, please sign-up here.
We don’t just offer SharePoint hosting either. We have great ways for every Access Developer and Access application to be hosted in the cloud whether it’s through SharePoint, SQL Server or our RDP solution which lets you host any Access 2007, 2010 or 2013 application without ANY modifications. It supports VBA code too.
We are happy to announce that our Remote Desktop Virtual Machine has undergone some price changes and is now cheaper than ever. Our RDP Virtual Appliance is only $299/month and comes with 4GB of RAM and up to 10 users. Access 2010 or Access 2007 will come pre-installed on every remote desktop. With RDP, there are absolutely NO CHANGES necessary to your Access Application to get it running in the cloud. Simply copy/paste it over to your Remote Virtual Desktop.
Additional users are now only $10 per month! and the entire Microsoft Office suite (Word, Excel, Outlook, and Powerpoint) can be added to any virtual desktop for only $10 per user per month! These plans come with No setup fee and NO long term commitment. Best of all, you can install your own software and completely customize your RDP environment.