Access 2010: Split Form Input Box

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

Import & Link HTML Datasheet In Access 2010

Access 2010 lets user import web datasheet which could be very useful, especially when you are dealing with data tables saved in HTML format. Through importing them to Access 2010 database you can easily start defining data types and apply constraints. Apart from importing data table, you can also link web datasheet with Access 2010 database table which enables smooth synchronization between data tables. Read More

Set Paper Size Of Access 2010 Report Before Printing

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

Change Format of “Number” Data Type

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

Export Access 2010 Table To XML Data File

A relational database may contain queries, tables, etc in an incompatible format, which unleashes downside of exchanging data between system over the internet. By converting them into XML format, which is widely accepted and compatible, it could be very beneficial since it eventually mitigates the chance of encountering any incompatibility problem. Access 2010 provides an easy way to export specified database table in XML format. Read More

Change Access 2010 Form Anchoring

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

Export Table To Plain Text In Access 2010

RDBMS (Relational Database Management System) are not abound, therefore, when sharing Access 2010 content with someone, you need to confirm if it is installed on the other end. For covering this up, Access 2010 provides an easy way to export database table into plain text file. Thus, you can easily exchange and share a text file which doesn't require any specific compiler/encoder to open it. Read More

Create Backup Of Access 2010 Database

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

Hide / Unhide Table’s Field In Access 2010

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

Access 2010: Quickly Set Form Control Padding

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

Access 2010: Save Form In PDF Format

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