How To Print Only Access 2010 Reports Data

Access 2010 let users view Reports in print preview to set the report elements in a way they want. Along with printing complete report with all the applied formatting, it also allows user to print only data contained in report. To print only the data in reports, open the report in Print Preview mode and under Page Size group, enable Print Data Only option. Read More

Change Access 2010 Table Field’s Data Type

In Access 2010, you will a lot of Table Tools to let user change table fields settings. Since data type has to be specified for each field, it also allows user to change the data type on the fly without opening database in design mode. Let’s see how to change the data type of an existing field. Read More

Access 2010: Add Field For Currency Number Format

Access 2010 offers a great number of pre-defined fields which you can easily insert in the database table. Out of many, Currency field is widely used for inserting values in specified currency. For inserting a new field that will contain Currency values, open the table in which you need to create a field and from Table Tools Fields tab, under Add & Delete group, click Currency. Read More

Hide Access 2010 Database Elements In Main Navigation Bar

Access 2010 allows user to handle database elements in many ways. Along with other features it offer to customize navigation bar, you can also hide any element, including, table, query, form or report.  For hiding out database elements; Tables, Queries, Forms, Reports etc, from navigation pane, right click the element you need to hide and click Hide in this Group. Read More

Encrypt Access 2010 Database With Password

Access 2010 offers an easy way to encrypt database with passwords, you can while saving a database choose to set it to exclusive for protecting with password. To encrypt database, Open the database exclusively, i.e from Access 2010, press Ctrl+O to bring up Open dialog, from Open options, click Open Exclusive. Read More