Monday, July 29, 2013

Purchasing review for Philips AJ7040D 30-Pin iPod/iPhone Speaker Dock


 photo shopping-online-cheap.gif
Philips AJ7040D 30-Pin iPod/iPhone Speaker Dock It’s the ‘must do’ to searching for Philips AJ7040D 30-Pin iPod/iPhone Speaker Dock information before decide to purchase the Philips AJ7040D 30-Pin iPod/iPhone Speaker Dock. You can looking for the electronics update new in the technology stories and breaking IT news to keep you up to date and learn about the features information technology including cloud computing, security, development, virtualization, mobile and more. Beware and it’s necessary to take some time to learn the facts about the terms used to describe so you can’t go wrong with Philips AJ7040D 30-Pin iPod/iPhone Speaker Dock searching at several stores compare quality, price, and service from several different retailers, mostly about the price and features and ask the website to provide you full details of Philips AJ7040D 30-Pin iPod/iPhone Speaker Dock.

Tuesday, March 5, 2013

Computer Training for Programming

Computer training for programmers can be quite the difficult hurdle to overcome. With such extensive computer training courses and years of studying, it is no wonder that they get paid so well! Although it is difficult coursework, it is extremely rewarding, especially when you are certified and can start earning a good amount of money.

If you are unsure if computer programming is for you, you should take a look at the coursework involved. Many computer students already have a basic grasp on some of the concepts, thus making it easier to understand the rest. The majority of computer training courses focus on skill. After all, computer programmers need to know everything about the machine. For that reason, students are expected to get inside the computer's head and act as if they know what the machine will do at every moment. Without fully knowing a computer's behavior, they will never be able to master harder concepts.

Although this may sound difficult, computer training classes do not stop there. Students are also expected to map out on graphs what the particular program is supposed to do. After accomplishing this task, they begin to learn BASIC; a common computer language between all computer programmers. From there, students can break down what they would like to do. Many students want to go into C++ or windows programming. On the other hand, there are also those who would rather study programming script and focus on analyzing information. Either path is a great industry with an abundance of jobs. However, both require a lot of language coding and they will need to prove that they know how to work the programs.

Computer Training for Programming

No matter what a student decides to do, computer training is a must. It is also quite easy to find a computer training program in your area. By searching for a certified one through the internet, you can easily take courses on your own time. Although it may take years, you will finally be able to become certified. It is a great opportunity for someone who works, yet still wants to become a computer programmer down the road.

One must know that computer programmers are expected to know a lot of information. For some, this amount of information is almost impossible, but with hard work is can be attained. This is why computer programmers excel in almost anything that they are presented with. They develop computer skills above the rest, thus allowing them to think with the computer. One could even say that they become the machine. With such extensive knowledge, the opportunities are endless for a computer programmer. Computer training classes are wonderful for anyone who wants to succeed in the computer industry. It is quite the difficult hurdle to overcome, but once you accomplish it, there will be no going back. Therefore, no matter what you choose, computer programming will allow you to financially be comfortable and enjoy your job.

Computer Training for Programming
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Natalie Aranda writes on computer and information technology. Computer classes are wonderful for anyone who wants to succeed in the computer industry. It is quite the difficult hurdle to overcome, but once you accomplish it, there will be no going back. The majority of computer training focus on skill. After all, computer programmers need to know everything about the machine. For that reason, students are expected to get inside the computer’s head and act as if they know what the machine will do at every moment.

watch cell phone Best Price Art S8 Balanced 8 Channel Microphone

Monday, February 25, 2013

DPF, What and Where Is It? How Does it Work? Should I Buy a DPF Delete Kit?

This is a question we get a million times a day. Since 2007 all Dodge Cummins 6.7, Ford Powerstroke 6.4, and Chevy Duramax 6.6 trucks come from the factory equipped with a particulate filter to meet tougher emissions standards. A diesel particulate filter (DPF) is a device that traps the soot and unburnt fuel from diesel combustion. You may have noticed if you have one the 07+ diesel pickups that it never puts out any black smoke at all. The DPF will capture 90% or better of all harmful diesel emissions. Once the DPF has become "full" of soot, it will need to have a regeneration cycle in order to burn all the soot out. You may have noticed a light on your dash from time to time that alerts you that the DPF is in "regen" or "cleaning filter."

Basically what is happening during this process is that the engine's computer has decided from the information that it receives from the sensors installed in the exhaust that the DPF has filled up past it's acceptable limit. The computer then opens the EGR (exhaust recirulation valve) introducing hot exhaust into the intake to help get get exhaust gas temps higher and also injects a small shot of fuel into the cylinders when the exhaust valves are open. The raised exhaust temps and the small amount of fuel then burn out the particulate (soot) that the DPF has collected since it's last regen. Once the computer gets readings from the sensors in the exhaust that the filter is flowing an acceptable limit again, it ends the regen cycle. The frequency of this cleaning cycle is different from vehicle to vehicle depending on use, mileage, and engine condition.

Myths about the DPF system:

DPF, What and Where Is It? How Does it Work? Should I Buy a DPF Delete Kit?

1. The lines on the side of the exhaust are fuel lines that dump fuel directly into the filter and the other connections are glow or spark plugs that ignite the fuel to clean the filter.

Not at all. As I stated above, the fuel needed for cleaning the dpf is entered into the engine cylinders by route of the regular fuel injectors during the exhaust stroke of the engine. A small shot of fuel is pushed out with the rest of the exhaust gas. The metal lines everyone sees on the side of the DPF filter are for a pressure sensor that is usually attached to the side of the transmission or frame. They have the long metal tubes on them to get the temperature of the exhaust they are measuring down before it reaches the sensor. Again, I don't care what the tech at the dealership says about those lines, if he says they are fuel lines (which I hear all the time), he is an idiot and you should remove your truck from there as quickly as possible. The other wires you see going to the exhaust before and after the DPF filter are not spark or glow plugs. They are thermocouples that measure exhaust temperature. The computer uses exhaust temperature and pressure before, at, and after the dpf to measure how plugged the dpf is and when it's time to perform a regen.

2. I can just remove the DPF filter and put a piece of pipe in there.

Sorry, no. If you remove the DPF filter and make no adjustments to the engine's computer, it will enter either a limp mode or a constant state of regen. Simply put, all the sensors and the dpf have to be in perfect working order when running the stock vehicle's programming or else your truck will go haywire and you will not be able to drive it.

Common problems with the DPF system:

1. Poor Fuel economy - This is the number one complaint we get from customers who have trucks equipped with a DPF. Most customers who traded in their pre-07 diesel pickups have been completely unhappy with the lack of fuel mileage that used to enjoy. The average fuel economy we hear people report on the DPF equipped trucks is usually 12-14 mpg. Many of these folks traded in trucks that did 18-22 mpg and are completely disgusted.

2. Excessive regens - Many of our customers who use their trucks for work complain about very frequent regens that kill their fuel mileage and performance. Many customers who work outdoors in the winter were used to leaving their old diesels run all day while they were on the job site. The DPF equipped trucks don't handle this very well. The cooler idling temperature of the exhaust gas will soot up the DPF on an accelerated rate. It is not uncommon for these customers to be on their second or third filter change because the truck went into constant limp mode. The usually dealership response is: "You can't let these new trucks idle." Which goes over pretty well with guys who are stuck at a job site five miles back in the woods all day and the temperature never gets above ten degrees.

3. High replacement cost - If any of you have had to pay for a DPF replacement out of warranty, you probably had a heart attack when you got the bill. A replacement DPF (which isn't available aftermarket yet) runs roughly 00-00 for the just the filter alone. And hears the scary part. DPF life is estimated between 120,000 and 150,000 miles. If you plan on keeping your new diesel pickup for a few hundred thousand miles better start a DPF fund.

4. Restricts performance modifications - With the new diesel pickups, the potential for horsepower improvements is tremendous. We have taken all three brands of pickups to close to or over 500 rear wheel horsepower and 1000 ft/lbs of torque with just intake, exhaust, and programming modifications. Never has so much performance been so easy and affordable while still maintaining street manners. The only problem is anything past a small tow type tune will aggravate the particulate filter. Turning up the engine will produce more soot which will plug the dpf sooner causing more regens. Many customers who run a 100 horsepower program report very poor fuel mileage and constant regens.

What can be done to extend DPF life and limit regens?:

Since we are not allowed by law to remove the DPF system, we are stuck with it if you want to comply with Federal emissions and keep your truck legal. Here are a few tips to help mileage and DPF life:

1. Use the right fuel - It is absolutely crucial and necessary to use ultra low sulphur fuel in any vehicle equipped with a particulate filter. High amounts of sulfur in the fuel will plug the DPF immediately. We get lots of questions from farmers about the red fuel. As far as we know you can't buy high sulfur fuel commercially anymore. We have a refinery roughly ten minutes from the shop that refines diesel. Both fuels are exactly the same, their is just red dye added to the offroad fuel. It won't hurt anything to run the low sulphur red fuel. The other question we get asked is about additives. Our advice is to only run products that were made for diesel fuel. Power Service, K100, Standyne, and Flash Lube for example are brands that we see no problems running. DO NOT add any sort of homemade fixes. Adding a quart of saw oil, atf, or anything else probably isn't a good idea. It will burn dirty and may clog the dpf.

2. Use the proper engine oil - Make sure you are using an engine oil that is rated properly for your truck. Some engine oil gets burnt up in combustion no matter what. If you are running oil that is not formulated for a DPF equipped vehicle, it will soot up the filter sooner.

3. Keep idling to a minimum - Simply put, idling contributes to dpf problems. Period. Keeping the rpm's elevated during will help. Keeping idling to a minimum is best for these trucks.

4. Run it hard once in a while - Don't be afraid once in a while when going up a hill to matt the throttle for a few seconds. Running the truck hard and getting things nice and warm will help clear out soot deposits.

I want to remove the DPF. What can I do and what will be the benefits?

First thing, it is absolutely against the law to remove or disable any emissions device for any vehicle that is going to be operated on the public highways. If you decide you want to remove emissions equipment for any reason, it is solely up to you and your mechanic to decide what is safe and legal for your application. I do not condone nor advise removing the dpf or any other emissions device. All the examples I speak about below were tested off-road and the mileage tests were performed on our Superflow chassis dyno that simulate the load the truck has alone and when towing.

We have done some testing on all three brands of trucks to see what results could be achieved by removing the dpf filter system. There are many products available for off-road and competition use that will disable the dpf system. You have to run some sort of aftermarket device to disable the system or there will be problems when you remove the DPF. There are several options that will allow the removal of the DPF without any horsepower increase and also several options that will add up to 250 horsepower along with removing the DPF.

Here are the test trucks we have done controlled tests on our chassis dyno with:

Truck #1: 2007.5 Ford F-350 6.4 Powerstroke
Mods: S&B Cold Air Intake, Edge Race Evolution, DPF Delete pipe (rest factory exhaust)
Stock RWHP: 285
After Mods RWHP: 471
Average Mileage stock: 11.8 mpg
Average Mileage mods: 17.4 mpg

Notes: Very basic delete package. Overall mileage jumped 5.6 mpg on simulated highway driving. Horsepower levels range from 40HP increase to 185 hp increase on the EDGE Race Evolution. Stock air box would pull filter restriction gauge with clean factory filter on even lower levels. Air box upgrade a must for this package.

Truck #2: 2008 Dodge 3500 6.7 Cummins
Mods: Full 4" DPF and Cat delete exhaust, Flo-Pro DPF electronics package
Stock RWHP: 294
Mod RWHP: 311
Average Mileage Stock: 12.1 mpg
Average Mileage Mods: 18.9 mpg

Notes: We were really impressed with this package. The Flo-Pro electronics only disable the DPF system and add absolutely no horsepower. The free flowing exhaust showed some horsepower gains. Mileage test was simulated highway driving with a truck weight of 8700lbs. Great mileage gain of 6.8 over stock. Inexpensive delete package for off-road work trucks.

Truck #3: 2008 F-550 6.4 Powerstroke

Mods: DPF delete into dual 5" exhaust, S&B Cold Air Intake, Power Hungry Performance Gryphon programmer
Stock RWHP: 268
Mod RWHP: 447
Avg HWY Mileage Stock: 9.2 mpg
Avg HWY Mileage Mods: 17.3 mpg
Avg TOW mileage Stock: 6.4 mpg
Avg TOW mileage Mods: 14.2 mpg

Notes: This is a package that we put together to simulate the gains possible on one of the hard working trucks that tows alot. The horsepower increase was dramatic, but the mileage gains were tremendous. We simulated a truck weight of 11,500 lbs for the highway tests and a trailer weight of 12,000 lbs for the tow test. The highway mileage tests of the mods showed a 8.1 mpg gain while the towing test also showed an amazing 8 mpg gain.

Truck #4: 2009 Dodge 2500 Cummins 6.7
Mods: 5" straight DPF/Cat delete exhaust, S&B Cold Air Intake, H&S XRT programmer
Avg HWY mileage stock:14.6 mpg
Avg HWY mileage mods:21.2 mpg

Notes: We only did simulated hwy mileage tests on this truck. We just used the XRT programmer to remove the DPF functions from the computer and left the horsepower stock. The XRT has horsepower increase levels of 60, 120, 175 horsepower. It will also shut the egr system off as well.

Truck #5: 2008 Ford F-350 6.4 Powerstroke
Mods: 4" DPF delete pipe, 5" MBRP dpf back exhaust, S&B cold air intake, Innovative Diesel custom tuned SCT Livewire
Stock RWHP:289
Mod RWHP: 536
Stock MPG: 11.6 mpg
Mod MPG: 17.4 mpg

Notes: This truck was an animal! The custom tunes were some of the smoothest shifting of any of the options we have tried and the power was crazy. There was a 247 rear wheel horsepower increase over stock on the highest level and the rear wheel torque was over 1000 ft/lbs! You would think there would be a serious drop in the mileage department, but we were surprised to see the truck gain nearly 6 mpg at even this horsepower level.

In conclusion, if you are looking for some serious horsepower for the drag strip or the pulling track, these new common rail diesels make serious horsepower with very little modification once the dpf is out of the way. Also, if you only operated your truck off-road there are some extremely impressive fuel economy gains to be had by removing the dpf filter. It is really too bad that we couldn't run the trucks on public roads with the dpf removed. We truly would have incredibly powerful trucks that get great mileage and have wonderful street manners.

Thanks for reading,
John Anderson

DPF, What and Where Is It? How Does it Work? Should I Buy a DPF Delete Kit?
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Little Power Shop - [http://www.littlepowershop.com] - 1-877-227-0823

watch cell phone Buy 2008 2010 Mitsubishi Lancer Without Turbo Radiator

Sunday, February 17, 2013

A Complete Preschool Lesson Plan - Jungle Theme

Hop on the Safari Bus. We are going on a Jungle Tour in the Preschool Classroom. It's going to be so much fun for the children, and I guarantee you are going to enjoy yourself.

Here are some ideas on how to get your jungle theme lesson plan started and some ideas to keep it going for as long as your preschoolers are interested in the activity.

Here's how to introduce the theme:

A Complete Preschool Lesson Plan - Jungle Theme

Day 1. Ask the children if they know what the word 'jungle' means. Explain what a jungle is for those who may not know, and have a picture of a jungle so they can associate your description with the picture.

Day 2. Have books* in the library on jungles and animals that live in the jungle. They can be a mix of cartoon type kids books and real-to-life kids books. (Your local library should be able to help you out with finding books.)

Day 3. Find pictures* of jungle animals from magazines, books, the internet, calendars, or anywhere you can find them, laminate them, and post them on the walls around the classroom.

Day 4. Place jungle themed toys on the toy shelf and place a few jungle themed puzzles in the puzzle area

Day 5. Find a CD with jungle themed music and play that throughout playtime after you talk about the jungle.

*If any pictures or books you have, show any sort of tribal people, you could make tribal masks for a creative art activity and the children can wear them in the dramatic play centre.

You can also place some paper towel tubes, pipe cleaners, markers, googly eyes, etc., on the art shelf and see which animals they create.

Here are some examples of animals you can introduce through books and pictures:
Panthers
Snakes
Bears
Monkeys
Zebras
Giraffes
Elephants
Cheetahs
Alligators
Rhinoceros
Birds
Hippopotamus

Feel free to have an open discussion with the children. Talk about the colors of the animals, their teeth, their eyes, which animal does each child like best, etc.

If you want, you can also touch on what the animals eat but make sure you keep it simple. The children at this stage in life don't need to start learning about the words carnivores, herbivores, etc. Just keep things simple like saying, a panther eats meat, a monkey eats fruit, a giraffe eats leave from tall trees, etc.

The children will probably want to know where the animals homes are in the jungle. This information should be easy to find through the books and pictures you have. If not, the library will have books on the individual animals you are talking about which will give you the information you need.

Here are some examples to get you started:

The animals will find homes within their habitat (the jungle) which they make into a home for them and their animal families.

Animals homes in the jungle could be a nest, a den, a burrow, under a rock, in a hollow tree trunk, up high in trees, etc.

You can then talk about which animal might live in a tree, which one would live under a rock, etc.

To incorporate this theme into the different programming areas of the classroom, some examples could be:

Creating a jungle themed dramatic play center:

Make a jungle jeep, safari jeep or car out of a box or, place 4 chairs together with a stand up steering wheel in front of one chair.

Get some safari looking hats.

Children's binoculars.

Pretend cameras.

Post jungle animal pictures on the wall and watch your preschool children go wild over this theme. :)

Here is a sandy sensory idea:

Place some sand in the sensory bin.

Find some small rubber or plastic sand animals* you would find in the jungle. (Snakes, beetles, insects, etc.)

Place these items in the sensory bin and your done.

*I have had great success finding almost everything I need at dollar stores. Search them out, I am sure you will find what you are looking for.

Just be as creative as you can with this theme. The possibilities are endless if you put your mind to it. When you are listening to the jungle music you can incorporate creative movement into this. Ask the children to pick an animal they would like to pretend to be and move to the music like that animal. There is no right or wrong movement, the children will have so much fun.

You could also move this theme into outdoor gross motor play. You could bring some of the dramatic play items outside like the hats, binoculars, cameras etc. Place some stuffed toys here and there around the play yard (make sure they get washed when you bring them in for the day) and go on an outdoor safari hunt.

The children can ride their bikes and go on their own tour, they can go on a "lion/bear hunt," you can run from animals 'scare' you, you can tip toe and walk around animals that are 'sleeping'.

Remember to use your imagination and expand on what the children are doing and saying.

Have a wonderful Jungle Themed Lesson and go wild with adventure.

A Complete Preschool Lesson Plan - Jungle Theme
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

My name is Marisa and I am a Registered Early Childhood Educator. I have been actively practicing in the field for over 10 years and am one of the operators of the free resource website for teachers, parent's and caregivers: http://www.preschoollearningonline.com

Be sure to click the above link and visit my web site if you are looking to get more free Early Childhood Educational resources such as games, art activities, science activities, song ideas, circle time ideas, sensory ideas, snack ideas, programming ideas, printables, and so much more.

watch mobile phone Buy 2008 2010 Mitsubishi Lancer Without Turbo Radiator Best Price Art S8 Balanced 8 Channel Microphone

Saturday, February 9, 2013

Wednesday, February 6, 2013

How to Mind Control Someone - 5 Psychological Tactics Used to Control Our Actions

Discussing how to mind control someone can be a controversial topic because of the many negative ways mind control has been used and is still being used to this day. Governments around the world, especially the totalitarian variety, use brainwashing methods and thought control against prisoners of war and other criminal elements in order to cement their hold on authority and repress subversive elements in their societies. Religious sects use mind control in order to strengthen their grip on the minds of adherents. Sometimes the methods of control are physical in nature, involving various methods of torture that over time have an effect on the psyche of a person. And other times the methods are psychological in nature, involving a direct psychological attack on the person to get them to change their views or behavior. This article will deal with 5 common ways though control is used to control the actions of people.

There are many methods that someone wanting to know how to mind control someone can learn and practice. Not all of these methods are proven ones so you will have to try them to see what works best for you. But you need to be aware that some of these methods really aren't in all good conscience ethically sound.

1) Hypnosis is an age old method used to induce a hypnotic trance, wherein suggestions are made to the subject's subconscious mind. Once in a trance a person becomes hyper sensitive to suggestions and this can have the effect of mind control in the dramatic changes that can occur in a person's behavior and mindset.

How to Mind Control Someone - 5 Psychological Tactics Used to Control Our Actions

2) Another method is popular in religious cults. In such a case, a person may donate all of their worldly wealth and assets to the movement, becoming totally dependent on the group and its leader. With all connections to the past severed, the person is a very easy subject for mind control, as all of their hopes, dreams, and relationships are attached to the group.

3) A high pressure bombardment of complex lectures that encourage blind acceptance of certain principles, values, norms, standards, rejecting logical thinking along the way, is another method.

4) A non-stop barrage of verbal abuse can break down the strongest defenses and crush the toughest spirit, leading to effective control of a person's mind.

5) In addition, strict rules like what we see in prisons today are another method. In such places, mealtimes, showers, workout times, and lockdowns are all fixed, and permission is needed for everything. These seemingly simple rules can disorient a person and make them psychologically dependent to the extent that it becomes easy to implant thought control.

Learning how to mind control someone is a serious endeavor and it should be taken very seriously by those who want to walk down that road. Complete control over another person is almost always unethical, but there is nothing wrong with using techniques to persuade others. The key is to have some moral standards to avoid taking advantage of people.

How to Mind Control Someone - 5 Psychological Tactics Used to Control Our Actions
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

If you want to learn how to mind control someone, discover the secrets of a rebel psychologist enabling you to put someone in a covert hypnotic trance in seconds, without them even realizing it! Visit http://www.hypnosismysteries.com today.

watches cell phone Best Price Dual Motor Deluxe Power Unit For Buy 2008 2010 Mitsubishi Lancer Without Turbo Radiator Buy Auburn Gear 5420113 High Performance Series Differential

Sunday, February 3, 2013

Access Visual Basic and Excel VBA Macros - A Comparison of the MS Office Programming Languages

Similarities between Excel VBA and Access VBA

In theory it should be easy to switch from one MS Office VBA programming language to another, since all the underlying principles are the same. It doesn't matter whether you're writing VBA macros within Access, Excel, Outlook, PowerPoint or Word, you're still using:

- objects, collections, methods and properties

Access Visual Basic and Excel VBA Macros - A Comparison of the MS Office Programming Languages

- variables (the DIM statement)

- IF conditions and loops

- message boxes and input boxes

- subroutines and functions

In fact, the only thing which is different is the object and collections defined within the application. So how hard can it be to switch from (say) Excel VBA to Access VBA? The answer, sadly, is... fairly hard. Here's why!

Differences between Excel Visual Basic and Access Visual Basic

The main differences between the two programming languages are that Access supports two macro languages, doesn't support recording, has two different ways to create Visual Basic macros, hides a lot of its functionality in the DoCmd object and has two separate object models. If that didn't make much sense, worry not - the rest of this article will explain each of these points in turn.

Access has Two Macro Languages

This is a red herring. Microsoft Access has two separate languages for writing macros: one called macros, the other called either modules or Visual Basic. If you have any knowledge of VBA, you should ignore the first; it is provided for people who have no programming experience, and doesn't support proper looping, error-handling and many other structures. So although the Access database window contains a MACROS tab, you should ignore this completely!

Access doesn't Support Recording

Want to know how to colour a cell red with pink spots in Excel? If you can't guess the macro command (unlikely), you can just record a macro and have a look at the resulting code. This is a vital aide-memoire even when you're a VBA guru.

Access, on the other hand, doesn't support recording - not even in the latest version at the time of writing, Access 2010. This is, to say the least, a shame (interestingly, while Word supports VBA recording, PowerPoint doesn't any more: Microsoft removed the facility from version 2007 onwards). This means that you're often forced to resort to Google, Microsoft help or phoning a friend to find out how to do something in Access VBA.

Two Different Ways to Write Macros in Access

Want to create a VBA macro in Access? To do this, you need to go to the VBA code editor. Strangely, you can do this in two different ways: either press ALT + F11 as normal, or click on the Modules tab in the database window and choose to create a new module. Why are there two different ways to do the same thing? Historical reasons, we think.

Access Uses the DoCmd Object for Many Commands

Access VBA is complicated (or simplified?) by the fact that about half the commands begin with DoCmd. For example:

DoCmd.OpenForm - to open a form

DoCmd.Maximize - to maximise a window

Features like this make Excel a far more logical programming language than Access.

Access has Two Separate Object Models

Excel is pretty self-contained (although if you're creating your own dialog boxes, you'll be using a separate applications called Microsoft Forms). Access, however, splits into two almost equal parts:

- tables and queries are part of the Access database engine

- forms, reports, macros and modules are part of the Microsoft Access application

Although you'll probably only hit this complication when you get into advanced programming in Access, it's another Access feature to muddy the VBA water.

In summary, then, we'd say that Excel macros are far more straightforward than Access ones. Added to this is the fact that it's much quicker to learn Excel than it is to learn Access, and you get two unequal learning curves!

Access Visual Basic and Excel VBA Macros - A Comparison of the MS Office Programming Languages
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Andy Brown is a trainer and developer for Wise Owl Training, a company providing Microsoft computer training in the UK.

For Wise Owl courses specific to Excel Visual Basic, go to http://www.wiseowl.co.uk/excel/courses/vba.htm; for courses specific to Access Visual Basic, go to http://www.wiseowl.co.uk/ms-access/training/visual-basic.htm.

mobile phone watches Best Price Dual Motor Deluxe Power Unit For Buy Acdelco D1483D Ignition Lock Cylinder For 118 Buy 7 8 X 10 4 Rectangular Home