AFAIK the Nikon D40 won't autofocus with the Tamon 70-300, you would have to focus manually. The kit 18-55 lens also takes pretty good close ups and does autofocus.
AFAIK you can only buy the D40 bundled with the kit lens.
Most better point and shoots will also take pretty good close ups with good depth of field, so if you are on a budget this might be worth considering. The key is good lighting, and don't use the on board flash.
Regards, Mike