Tag: Access

All About Microsoft Access 2013 and Access 365

Microsoft Access 2013 is the software that has progressed over the ages from Access 1.1 in 1992 until now.

Office Professional 2013 Software (which includes Word, Excel, PowerPoint, Outlook and Access) will allow you to install and run Access 2013 as usual.

The Office 365 version is paid by monthly subscription and provides Web services to Office 2013. It includes the Office Professional 2013 software as well as Access 365 and Access 2013.

Access 365, besides the name “Access”, has little to nothing in common with Access 2013 or previous versions of Access.

What is Access 365 all about?

Access 365 is a tool for creating web apps that run within SharePoint 2013. The old .ACCDB format has been abandoned. New applications should use the Access 365 model, or stick with Access 2010.

Access 365 allows the rapid creation of small applications using the standard web technologies of HTML5, CSS and JavaScript in a simplified web development environment. One big feature is that Access Services can now store data to Microsoft SQL Server or an SQL Azure database.

The use of SQL Server overcomes the 2 Gigabyte size limitation of the previous Access databases. SQL Server also provides all the security and features essential for any strategic company business system.

And What about Access 2013?

The Access 2013 desktop version is much unchanged from previous versions – it still supports the Front-End and Back-End database model and Visual Basic for Applications (VBA).

But Access 2013 no longer supports:

  • The Microsoft Access project (ADP)
  • The Access 97.mdb database format
  • PivotCharts and PivotTables
  • The dBASE database
  • Smart Tags (Action Tags)
  • Access 2003 Toolbars and menus
  • The Microsoft SQL Server database Upsizing Wizard
  • The Developer Source Code Control

Apps for Office

There is a new feature of Access 365 – Apps for Office. This technology enables Office to be used as a service on the Cloud or Web. The webpage can be hosted in an Office application – that is Excel, Word, Outlook, PowerPoint or Project.

An app is usually published to the Office Store for use.

JavaScript API for Office

Access 365 has a new JavaScript API that provides programmatic access to Microsoft Office documents. The API includes application-specific data types, objects, functions and events.

The JavaScript API is a great improvement on the crude JavaScript design capabilities within HTML.

SharePoint apps

Access 365 provides a simple way for SharePoint to host the Front-End of an app and have the data management capabilities of SQL Server on the Web. This simplifies web development.

Note that Visual Basic for Applications (VBA) code is not compatible with SharePoint Access applications.

Access 365 Macro Editor

Templates can be used to create sophisticated looking apps – and without the need for code. However business rules and data manipulation can be implemented with a new macro language. The macros do not have the power of VBA, but are adequate for simple logic.

Microsoft’s Strategic Direction

Microsoft Access was never meant for corporate company databases. Many companies evolved the Access database software into their core administration systems. But with the limitations of network traffic, peak loads, reliability, rollback recovery, security, etc, etc – these systems eventually hit a brick wall.

The direction that Access 365 is now taking reverts to the original intention of Microsoft Access. That is, providing a rapid development environment for small Line of Business (LOB) applications.

Microsoft Access with VBA is at the end of the road. For mission critical administration systems, the best development platform is Visual Basic.Net with SQL Server.

Want Fast Access To Great Ideas On Making Money Online? Check This Out!

Let’s face it. Most people could use more money, whether it is simply to help make ends meet, put money away for a rainy day or meet retirement goals. But so many of us grow frustrated when we are not sure how to get more. Making money online can help with that. This article is here to help.

Sign up for a site that will pay you to read emails during the course of the day. You will simply get links to scan over different websites and read through miscellaneous text. This will not take you a lot of time and can pay great benefits in the long run.

Get paid to review some of the new products that are out on the market today. This is a great way for companies to determine if their new products are a hit or miss as they will pay good money to get an opinion on them. Get the word out on these products and pull in the cash.

If you have good ears and can type quickly, you might want to look into online transcription jobs. The beginning rates are usually low, but with time and practice, you can build up your skills to tackle some of the better paying jobs. Try looking on oDesk or eLance for some transcription work.

Many people find that they can make extra cash by completing surveys. There are many survey sites online that will pay you for your opinions. All you need is a valid email address. These sites offer checks, gift cards and PayPal payments. Be truthful when you fill out your information so you can qualify for the surveys they send you.

You can make money flipping domain names. There are many who can earn a living by simply flipping domain names. It’s a bit like buying real estate on the Internet and requires some investment on your part. Obtain the latest trends in keywords by utilizing Google AdSense and similar sites. Buy some acronym-based domains. Find domain names that are likely to pay off.

Join a focus group if you want to make some money on the side. These groups gather together from an internet hub at a physical location where they will talk about a new product or service that is out on the market. Generally, these groups will gather in very big cities near you.

Enter contests and sweepstakes. By just entering one contest, your odds aren’t great. Your odds are substantially better, however, when you enter multiple contests regularly. Taking a little time to enter a few free contests daily could really pay off in the future. Make a new e-mail account just for this purpose. You don’t want your inbox overflowing with spam.

Tens of thousands of people have learned to help line their wallets by finding great ways to make money online. You can be part of these really smart people who are doing this and become a financial success, too. You do not want to miss out. It is time to take financial control!

Exit mobile version