HRV8H2QMZVJY
test
February 20th, 2010Creating a VBA Access database
February 10th, 2010You can create powerful Access databases with no programming code at all. There may be a situation though when you do need some specialized functionality and then you will have to create a VBA Access database.
The programming language used in all the MS Office products is VBA which stands for Visual Basic for Applications.
How do we go about this? It really depends on the type of functionality you require, but chances are you will find yourself creating sub procedures and functions. This will hold the main code of your program. Code can be put behind the forms itself or in code modules.
There is a bit of a learning curve however when it comes to creating a VBA Access database. It takes time to become confident and proficient in a programming language.
You can also get proficient in the MS Access macro language which will give you a start in how logical statements flow. MS Access macros are essentially VBA Access statements, but are much easier to use.
If you feel confident to attempt a VBA Access database then you should, otherwise enrol in a good training course. There are also plenty of good books on the MS Access VBA language.
Microsoft Access ebook
February 9th, 2010We can learn Microsoft Access from many resources. One great way is to use a Microsoft Access ebook.
An ebook can be read on your PC or laptop and is easier to transport than a traditional printed book.
I have written two great Microsoft Access e-books which you will find on this site.
If you want to know about the MS Access subform or the MS Access macro then you have come to the right place as there is a resource for both those subjects.
You will find my Microsoft Access ebook publications will enhance and take forward your understanding of Access. Struggle no more as I break the subject down in plain English. There is also a video tutorial series to accompany each Microsoft Access ebook.
Add to your library of MS Access books today and add another skill to your toolkit.
Microsoft Access course
February 8th, 2010There was a time when Microsoft provided book type manuals with their software. This is no longer the case and we really have to hunt around for the information we need or attend some kind of Microsoft Access course.
Of course there is the online help, but this may not be suitable for everybody. We learn and retain information if different ways. I personally prefer to have a book that I can refer to wherever I am.
The alternative is to attend a Microsoft Access course, but this could involve travel and may not always fit into everyone’s schedule.
Fortunately there is an answer in the form of the Microsoft Access Power Mastery course.
This course is available on this website and you can either watch the tutorials online or on a pc playable DVD.
The course is very comprehensive and many students have given great feedback about it.
It is now in its second version and even better than before. You get a ton of Access 2007 tutorials in the form of videos and cheat sheets to take you from beginner to power master.
It’s like having a teacher there with you guiding you each step of the way. Learn at your own pace – skip, pause, rewind, replay any part of the tutorials.
So skip the online information hunt and take charge of your future now.
Give yourself a head start and get on board this Microsoft Access course.
Access contact database
February 6th, 2010Although we can use MS Outlook for storing contacts, we may also want a dedicated system to do this. We can store personal or business contacts and call them up at the click of a button in an MS Access contact database.
The advantages of storing contacts in An MS Access contact database are obvious. MS Access is the world’s most popular desktop database and that does not look like changing in the short term.
Microsoft Access software can interface with Excel, Outlook or any application in the MS Office suite. What does this mean for you? Well take the example of Outlook. You will be able to seamlessly export your contacts from the MS Access contact database into MS Outlook.
On this website I have created an affordable MS Access contact database which will be very useful for personal as well as business use.
MS Access 2007 help
February 6th, 2010MS Access 2007 is the version of Access that changed everything. The interface is like no previous version and takes some getting used to. Instead of the classic toolbars and menus we now have what is known as ‘The Ribbon.
It is easier to now create basic forms and reports. Unfortunately there is not a lot of MS Access 2007 help available at this stage and it is important to get the correct training as soon as possible.
How much MS Access 2007 help needed will vary from person to person. Some need more training than others. We all learn differently and there are aspects of MS Access which are complicated.
Take for example database relationships – these are the backbone of any good MS Access database and it is useful to have a good understanding.
On this site I have created a great MS Access 2007 help product. Students have got great value from it and now it is available online or on DVD.
How to use the autoexec macro
February 1st, 2010The autoexec macro is used to run actions when the database is opening. For example, you may wish to perform a data update before the system becomes active. You can do a similar thing with the start up options, but the autoexec macro will allow you to run more than one action.
Lets look at how we can use the autoexec Access macro to open a form and move to a blank record for entering data.
Load up a database.
Go into the macro designer.
In Access 2007 at the Ribbon you would click on the create tab.
Then click on the macro icon at the far right hand side.
In the action column select the ‘OpenForm’ action.
MS Access Autoexec Macro
At the bottom of the screen you will see an area for action arguments.
Select the name of the form to open
Make sure the view says form.
Now select another action of ‘GoToRecord’.
At the bottom of the screen you will see an area for action arguments.
Select an object type of form.
The object name will be the form you are opening.
Set record to be new.
That’s it…..
Now just save the macro with the name of ‘Autoexec’.
Close the macro designer window.
Exit the database.
Now run the database.
The autoexec Access macro will immediately kick in and you will be taken to a brand new record in the form you specified.
The autoexec macro enables us to control what we want to take place when the database is opening.
Click here MS Access macro if you want to learn more about macros.
Create a PDF file with a Microsoft Access macro
January 26th, 2010In Microsoft Access 2007 one of the new features is to save data as PDF format files. You can also do
this by using Microsoft Access macros.
Load up the macro designer and click on the actions column. Scroll through the list of actions until you find one called ‘OutputTo’. Select this action.
At the bottom of the screen you will see the Microsoft Access macro action arguments.
-The object type will be the object you are using which could be a table, query, form etc.
-The Object name will be the name of the object – for example you may have a table called customers.
-Output format will be the type of format you wish to output the object to. This could be html, excel etc. Select PDF format here.
Output file will be the path of where you want the output to be saved.
The only other setting here which you could use is ‘Output quality’. Set this to be ‘Screen’.
Microsoft Access macro
Now save and run the Microsoft Access macro.
In Windows locate the area where your PDF was saved and open it up.
Click here to get more help with the Microsoft Access macro
MS Access Macro – How To Open a Report
January 20th, 2010An MS Access macro is a great tool for automating our databases. We can use Microsoft Access macro actions for many tasks.
In this demonstration I am going to open a report by using a macro.
The MS Access macro designer has three main columns
1. Macro Name
2. Action
3. Comment
Enter the name of the new MS Access macro in the ‘Macro Name’ column.
Now move to the ‘Action’ column and select the ‘OpenReport’ action.
Look towards the bottom of the screen and you will see the action arguments section. Enter the name of the report in the report name section. In the view section select the view you wish to see the report in. In this example I want to see it in print preview mode.
Now save the MS Access macro and close the designer window.
Create a brand new form in design view.
Now make sure the wizard button is clicked as you want to use a wizard for the next step.
From the toolbox control area you want to click the command button control.
Drop the button onto the form.
The wizard will now load and you will see two columns – categories and actions.
Select from the categories box the option called miscellaneous.
From the actions box select the run macro action.
Click the ‘Next’ button and on the next screen select the macro that you saved earlier.
Click the ‘Next’ button and on the next screen add text to the button.
Click the finish button.
Now run the form and click your command button.
The Microsoft Access macro will run and your report will open in print preview mode.
The MS Access macro makes our life so much easier. We don’t need to learn complex programming code to add power to the database.
To further your learning of the MS Access macro check out this great new MS Access macro ebook.
Using the MS Access macro
January 16th, 2010When we want to automate certain aspects of our database we can take two routes. The first is to learn how to program or the second to learn how to use MS Access macros
Macros consists of actions which instruct Access to perform tasks. For example we may have a macro to backup our tables,forms etc into another database. We may even create a simple macro to open a form or report.
There are macro actions for practically anything you want to do in Access. You will find that learning how to use the MS Access macro is not as hard as you think.
You may even want to transfer data from your MS Access tables into a Microsoft Excel spreadsheet by clicking one button. Easily done with a macro. Forget about having to click various menu commands. Just create a macro in the designer and you are done.
Why not email that spreadsheet or even output it to Microsoft Word? Again, a macro can take care of this for you.
Forget about complex programming. The MS Access macro makes automating your database a breeze.
Check out this fantastic new resource to help you with MS Access macro learning
http://access-databases.com/ebooks/macros/