The ruler is a great way to ensure that your reports print accurately or your form controls are right where you want them. However, you may not know exactly what measurement units Access' ruler indicates. If you're more comfortable with the metric system (centimeters instead of inches), you can adjust your ruler permanently. Or, if you have Access 2003, you can simply input measurements in your preferred unit.
Database management is broken into three general sections: design, engineering (or development) and database administration (DBA). Sometimes the designers and engineers work together, or one person may fill both roles. Once the database is designed and developed, then the administrators make minor tweaks as needed and manage the data to ensure consistency and continuity. Database admins also work to clean, archive and compress the database to ensure optimal operation. In smaller businesses, these jobs are almost non-existent, so look to larger corporations that manage large quantities of data for positions. No matter which direction you go, take some SQL (not server) classes first to get to know the language. It varies a little between programs, but it pretty consistent for the most part. Here are my top five database career recommendations and why:
The Microsoft Office 2007 suite is full of so many upgrades, new twists and bright ideas it's hard to imagine that not everyone has updated already. But some of you are holding out. Here's an improvement on an Access feature that made me stand up and cheer.