Tag Archives: Access 2010

Access 2010 offer many options to setup Form and its control in way you want. Many a times while creating form, we need to split a form control vertically or horizontally. You can for instance split a form control to let user enter his middle or surname. Read More

Access 2010 offers a long list of Print sizes, so you can choose the required one. Before printing a Report or Form, it’s recommended to check the Print size. To set the size of the report, navigate to Report Layout Tools Page Setup tab and under Page Size group, from Size options, select a suitable one. Read More

Access 2010 doesn’t place squiggly red line beneath the unknown words/phrases, however, if you want to check the database for spelling mistakes, it allows checking up mistakes through Spelling feature. Read More

Like previous Access versions, Access 2010 also allows user to change format of all supported data types. This post covers changing format of Number data type. To change the format of the field having number data type, open the table in Design view, right click the table and click Design View. Read More

Access 2010 offers a long list of database templates to let you easily fill out pre-defined database elements, including, table, queries, reports and forms. In this post we will cover how to download Access 2010 compatible templates. Read More

Access 2010 supports a great deal of file format in which database table can be converted and exported directly. One of the widely used database file format is dBase, it not only allows user to convert database file in  dBase but supports conversion into many dBase file formats as well. Read More

By default, Access 2010 applies Flat effect over database cells, however, it allows user to change the default effect to either Sunken or Raised. To do so,  on File menu, click Options. Read More

Access 2010 offers many options related with arranging different Form controls boxes. It provides users with Anchoring options to set the Form at required position of the screen. You will find 9 options in total under Anchoring pull-down menu. Read More

Memos data type in Access 2010 lets user apply formatting over the table’s content, you can also convert the memo data type into Rich text or Plain Text to remove all the applied formatting. Read More

Creating backup of databases is the most important thing and must not be overlooked. Access 2010 offers a simple and easy way of creating backup of database you’re working on. To begin, open the Access 2010 database and close down all table fields. Now on File menu, click Save & Publish. Read More

Access 2010 lets user easily hide and unhide table’s fields. This will come useful in situation when you want to see two non-contiguously placed fields side-by-side. For hiding the table’s field, select the field by clicking field title, now navigate to Home tab and from Records group, under More options, click Hide Fields. Read More

By default, Access 2010 report size is set to Letter, however, before printing the report you can verify the size and adjust it to required size. To begin, open Report in Layout View and head over to Page Layout tab, from Size Options, select size of page. Read More

Access 2010 provides a long list of date/time formats, so you can pick out one which fulfills your database needs. Since military time format has been widely used, sometime you may want to add time in Military time format (24 hour format). Let’s see how to change the time format. Read More

Setting Forms in required shape is no less than a laborious work, as you have to adjust each element at the position you want. Access 2010 offers 3 types of padding control to set the padding in Narrow, Medium, and Wide layout. To begin setting up Form Controls, open form in Layout View and select form by pressing Ctrl+A on keyboard. Navigate to Form Layout Tools Arrange tab, and from Control Padding options, Choose a desired padding option. Read More

Unlike previous versions, Access 2010 offers a direct way to publish reports and forms in widely used document publishing format – PDF. Once you’ve done creating your forms in Access 2010, you can export the form into PDF and XPS format. For converting form and to save in PDF format, open the database Form and head over to External Data, and click PDF or XPS button. Read More

In Access 2010, there are  a lot of Form Layout controls which enables user to change every aspect of Forms. Along with many other options, you can also change the default Font according to your likings. Read More

If you like to open Access 2010 database elements with a single click, you can easily let Access 2010 change database elements opening behavior. Let’s see how to do it. For opening database elements with single click, in main navigation pane, right click to select Navigation Pane options. Read More