Make a backup! (Copy, paste, rename "backup.mdb")

As far as the migration goes, use the Microsoft Upsizing Wizard (http://support.microsoft.com/default.aspx/kb/237980) or SQL Server Migration for...

Make the exe in Visual Studio. Access is a desktop database platform, not a software developing platform.

You could write a batch file to copy the db into a backup folder. Then use Scheduled Tasks to run the script daily or weekly or how ever often you need it to run.

What server language will you be using (php, asp, jsp, coldfusion...)?

Use the asterisk for the wildcard:SELECT *
FROM report
WHERE product_no like 't*';

You can use VBA (http://www.databasejournal.com/features/msaccess/article.php/3077791) to remove duplicates or export it to excel and click data->remove duplicates, then reimport.

Also, see http://www.daniweb.com/forums/thread136175.html on how to set up the connection string for accdb.

Yes, Access can communicate with asp, asp.net, php, jsp, and coldfusion. Figure out which one's your web server supports and move forward from there. Also, Access may not be enough for the job. It...

This will only work locally (and may not work at all). I have only got this to work on XP-Professional. Go to Control Panel->Administrative Tools. You may have to click Switch to Classic View to...

Save the union query. Create a new create table query that uses the union you just created.

I would go with PHP and MySQL, however it's all up to you. PHP and Access will work fine as long as the site doesn't receive a lot of traffic.

Connecting to access with php is very simple. You will need to be able to access the IIS control panel to set things up. Otherwise you need to talk to the server admin to set an ODBC Connection for...

Yes. You'll need some JavaScript and a server side script like PHP, ASP, JSP, or ColdFusion.
The form field will populate using an onclick event. You could also incorporate an xmlhttprequest (AJAX)...

We need to know more about your situation. Be more specific in regards to what language you are using to communicate between the form and access.

UPDATE Table SET HomePhone=MobilePhone WHERE (HomePhone) Is null;