Back to the basics: without code application development with access

Every now and then I have a home project for which I can't afford (or does not want to employ) a professional home contractor. Sometimes are too expensive, they do not believe that my home project is large enough, or want to take the time to understand what I want to do. Therefore, that I like companies such as Home Depot, Lowe's and ACE hardware. I know that I can go there shop around for the materials and tools, talk to some people who are more than I experts and come with newfound confidence, that I can create a new Office in my house or a new deck, or simply make a number of small but complex fixes around the House. I do not my life as a professional contractor, but as the people at Home Depot saying, "You can do it, we can help."
As a person, whose Karriere has centered on software development, I feel really passionate about users who are not professionals in software development in contrast to many of us. How they solve their problems too, if they cannot afford or do not meet, professional developers? Or what if we went all DevConnections in Orlando, Florida, this week?
One of the great advantages of Microsoft Access is how it helps create people easy applications, which would otherwise require the expertise of a professional developer.  While users can create Microsoft Access solutions, code with, such as Visual Basic or SQL, today we with you who would like to speak non-professional, can a few features that you create applications, write no code.
At the high level, you can create Microsoft Access data by three main tasks of tracking applications:
a) store and track your data: it is very easy to create the tables where your data is stored, and create forms on these tables, so that you enter, edit, change and delete your information. It is also easy, your data with Datasheet views (as opposed to a set of data views) to navigate. Of course you want your data, to be exact, and you can do access by defining validation rules, you can use on your data want to enforce. For example, you can ensure that the color of a product is one, or that the prices are non-negative for your products.
b) combine and design your data: once you have data stored in your tables, you can it, combine, create joining two tables, or by using external data. For example, can you the data in your invoices table with the data in your product information table "join". In access, you can do this by querying create essentially different views against your data.
c) reporting on your data: as soon as you stored data and it designed by querying, you can easily create reports against it. These reports you can create buzz, order your information based on a field of interest (for example, in descending order of price) and so on. Reports must be carried out only in access, you can also export it to Excel, where you can analyze your findings.
These three activities constitute the core of a data access page tracking application. Professional developers with professional development tools for hours create similar applications with tools like Visual Studio, and you then deploy it to their users. However this type of personal or team-based application can be created with access, in minutes, without writing code. In addition you can be deployed easily desktops on Microsoft SharePoint to people. In this way, an application for other users can be released while the information in SharePoint remains centralized.
In summary you keep in mind that, if you a small project to your information to track, with access, "can you do it, and we can help." In the next blog post, we are directly in access to illustrate.

View the original article here