FREQUENTLY ASKED QUESTIONS

Find answers to common questions about microsoft access and our database services below, If you can’t find an answer call us at 087 135 0114 or email us at info@ces-solutions.co.za.

Contact Us

Microsoft Access and Databases

Some basic Microsoft Access Database FAQ’s are covered below.

Yes, try out the Northwind online template, that will give you a good idea of what Access can generally do.

The full version of Microsoft Access can be downloaded from www.microsoft.com and is included in the Microsoft 365 subscription.

Yes, export your existing data to an online MySQL server and connect your users with an ODBC connection; while still using Microsoft Access locally on each PC.

Yes, its data can be exported to an SQL or MySQL server. The forms, queries, reports and code will remain in an Access file on your PC.

No, MS Access only runs on Windows and Mac PC’s. Access also does not run on Linux.

No, Access as a database file, does not run in the cloud, but there are methods of storing your data in the cloud which can then be accessed by your local copy of Access.

No, Microsoft Office 365 for Mac does not include MS Access. ACCDB database applications will not work on macOS.

Start with deciding on how a database should benefit your business, analyse your existing data and draw up your database schema.

Yes, there are a few ways to achieve this.

No, it’s not a database, even though it stores data. Technically, it’s a flat-file database, not a relational database.

Yes, there’s Access Runtime, but you will only be able to run or execute an MS Access database that someone has already developed.

Yes, there are many tutorials to be found online, including some from Microsoft.

Access Runtime is free to download and install, but you will only be able to run or execute an MS Access database that someone has already developed for you. Access Runtime does not allow you to make changes or develop your own database.

Allowing the use of blanks or empty fields needs to be carefully considered since Null, Zero and empty are not the same thing, and can have an effect on your reports. A correctly structured database should prevent this.

The MS Access Database Engine is an install package that provides data connectivity between Microsoft Office applications and non-Microsoft Office applications. After installation, you will not be able to execute the program as a Windows application; instead, it runs in the background of your computer.
Examples of MS Office applications are Excel, Word and Outlook. Good examples of non-Microsoft Office applications in this context are Microsoft SQL Server or a simple text file.

The Microsoft Access Database Engine is something that a software developer would provide to you, together with a custom-built piece of software, and not something that standard a PC user would be concerned with. The MS Access Database Engine is a facilitator of data transfer between different file formats.

Here’s a list of what the MS Access Database Engine is not:

The MS Access Database Engine is not the same as the Microsoft Access application that comes with some versions of MS Office.
Cannot execute MDB or ACCDB files.
It cannot be used to share or network a Microsoft Access Database backend file on a server.
Not macOS compatible.
Not the same as the Free runtime version of Microsoft Access.
Not a program that you can run from your desktop and interface with.
It’s name can also not be shortened to MSDE, since that is something else entirely, namely the Microsoft SQL Server Desktop Engine.

The Microsoft Access Database Engine is a facilitator that allows data transfer between applications.

Curious how a Custom Database can transform your business?

Contact us today to explore MS Access solutions.

Get in Touch

Our Database Services

Some Microsoft Access Database FAQ’s from our customers are covered below.

No, not necessary. There are some advantages to having a Microsoft Office suite for integration, but the Free Runtime version of Access works in most cases.

No, we will assist you with the setup. As with any business, you need to have supported and reliable internet, especially if your data is hosted online.

Yes, we will import your data into a custom Access Database, incorporating all your historical data.

We will host your data online, which will be available to any of your users with an internet connection. Our online hosting is a managed service, meaning we take care of security and backups.

WHAT OUR CUSTOMERS SAY

Good
Based on 3 reviews
Neville Bigalke
Neville Bigalke
2021-12-16
Thanks Gunter for your excellent work.
Lou Rens
Lou Rens
2021-10-28
We at CIS Industrial Services can highly recommend Gunter form CES Database Development for all your Microsoft Access Database needs. Gunter had taken the time to understand the task at hand and what our vision was for this project. He is quite responsive and truly trying his best to ensure that he deliver on his customer’s vision.
Stephen Jones
Stephen Jones
2021-07-20
CES has offered Storage WISE very efficient services since 2010. The database developed for us has helped in condensing our entire management system into one customised operating centre. The added benefit is that CES amends, adds or removes functionality as required at a speedily and efficient rate. With remote connection to our database, we never have to wait for anyone to "arrive" to assist us. I would really suggest that any company looking for a custom database system to contact them.
write a review