Microsoft Access News: Updating the Access Services in SharePoint Roadmap

Microsoft Access News: Updating the Access Services in SharePoint Roadmap

If you have been using Microsoft Access Services (in SharePoint), be aware of the latest news last week of this being dropped.

microsoft-access-news-updating-the-access-services-in-sharepoint-roadmap

Not to surprised! Microsoft Access is a desktop power application tool which works very well with VBA (Visual Basic for Applications).

A web version always had its limitations and it seems now perhaps there was never a large enough take up of developers when Continue reading “Microsoft Access News: Updating the Access Services in SharePoint Roadmap”

How to Publish An Access Database To SharePoint – MS Access On The Web

How to Publish An Access Database To SharePoint – MS Access On The Web

With the release of Access 2010 and better still, version 2013, publishing your Microsoft Access database on the web couldn’t be easier.

Check out this short three and half minute video tutorial showing how you link and synchronise between SharePoint (online Access Services) and your ACCDB database file within Microsoft Access

How to Publish An Access Database To SharePoint – MS Access On The Web

Just a few points to be aware of when considering Continue reading “How to Publish An Access Database To SharePoint – MS Access On The Web”

Access 2013 – 4 Ways to Create an Access App

Access 2013 – 4 Ways to Create an Access App

Here’s a quick video tutorial (only two and half minutes) that shows the new pending Access 2013 application and the 4 ways to create and MS Access app (or database)

Four individuals demonstrating the 4 ways to create an Access database with the main feature being the new enhanced and advancement bringing it into 21st century namely a web version.

Access 2013 – 4 Ways to Create an Access App

Even though previous versions of Access use the web services, this version is even more simplified and slicker to use.

access 2013To be honest, I haven’t spent too much time with the new version and it’s not yet released to the public just yet and my clients therefore do not need to know anything about this yet but as we now use more and more web based applications and our smart-phones are becoming more sophisticated, Microsoft have finally recognised the need to be in the game and market share and this is certainly the first steps to a ‘mobile’ device version.

I wrote a quick summary of Access 2013 and their new features a few months ago and it appears it’s pretty going to be this look and feel too – so not too many things have changed since then.

I will be moving to Access 2013 very soon though I still do look after clients who use Access 2000 over the web too!

Anyone else thinking of upgrading? Let me know your thoughts in the comment box below.

Working With Hyperlinks In Access – Create A Button Link

Working With Hyperlinks In Access – Create A Button Link

With an Access database, there are many ways to perform similar functions like creating a clickable button using the standard CommandButton or using hyperlinks in Access instead – that’s a URL link and having some quick automated way to fire up an email for example.

This blog expands on this feature and in particular how you can use a hyperlink to act as an alternative button for your datasheet or form objects in your database without even using a single line of programming code albeit a macro or some Access VBA code.

Working With Hyperlinks In Access – Create A Button Link

Rather than a conventional CommandButton (a grey dull looking control) to click and run a procedure, we can adopt the hyperlink action instead and Continue reading “Working With Hyperlinks In Access – Create A Button Link”

Microsoft Access Hyperlinks: Easy To Create And Apply

Microsoft Access Hyperlinks: Easy To Create And Apply

Take a look at how easy Access hyperlinks are with this effective two minute video tutorial showing the simple steps in a table when setting the field’s data type to ‘Hyperlink’.

Microsoft Access Hyperlinks: Easy To Create And Apply

Like with all defined data types and their properties in a table, your forms inherit these settings too making the smooth transition to a user-friendly Access application.

Microsoft Access hyperlinks have been around since version 97 and in a form you will see more properties that can be further refined.

access hyperlinks

To understand more about tables, forms or any other key attribute of Microsoft Access, you always have my eBook bundle collection available to you at a discounted price with a 100% money back guarantee too.

Microsoft Access Database: Access Web Database from a Windows Phone

Using Microsoft Access 2010 with Microsoft Office 365, you can use your Windows 7 (mobile phone operating system) to read and update your Access database via the web.

Take a look at this quick demonstration which will require certain services to be in place including Microsoft Enterprise Services.

Microsoft Access Database Tutorial – My Comments

You will need to have several products and services in place to fully utilise this useful tool via your mobile phone. Therefore, it will need to include Microsoft Office 365 which is a monthly and affordable plan.

You will also need to know something about SharePoint 2010 and how to publish an Access database to the web using this or a similar Microsoft Access service.

Microsoft Access Database: A Powerful Database Program for Novice End Users!

I found the following article about Microsoft Access Databases which is aimed at those who are considering using a powerful database management tool and have no knowledge or have no idea which application to choose.

This article will ease the new ‘prospect user’ towards using Microsoft Access as being the friendlier application when Continue reading “Microsoft Access Database: A Powerful Database Program for Novice End Users!”

Microsoft Access Database: Ways to share an Access Database

With a stand-alone Microsoft Access Database design approach, you have complete control over managing the data and their objects but if you are going to want to share your Access database; simply loading your .MDB or .ACCDB file on a shared network folder will cause problems further down the line!

So sharing an Access database is a methodology often over looked and needs to be planned at the earliest opportunity leveraging your time Continue reading “Microsoft Access Database: Ways to share an Access Database”