How to Insert Predefined Fields in MS Office Access

Inserting Predefined Fields in MS Office Access
To insert a predefined field:
1. In datasheet view, on the Ribbon, in the Fields and Columns section, click New Field.
2. In the Field Templates pane, select the field you want, and then drag it to your table.

Read more »

Posted in: MS Access 2007

How to Modifying Data Types in MS Access

Modifying Data Types in MS Access
To view or change the data type:
1. Click a cell.
2. In the Datasheet contextual tab, the Data Type and Formatting section displays the data type.
3. To change the data type, in the Data Type box, click the arrow, and then select the type you want. (Note: You may need to retype the value in your cell or cells if the type is not compatible.)
4. In the Format box, click the arrow to format how the data is displayed.
5. Select Is Required if you need to make this field mandatory. To make table and field definitions easier, Microsoft Office Access has a set of predefined templates.

Read more »

Posted in: MS Access 2007

How to Create a New Table in MS Access

To Create a New Table in MS Access
Microsoft Office Access 2007 has made creating tables easy by providing a handful of common schemas.
1. On the Ribbon, on the Create tab, in the Tables section, click Table.
2. Type the first value in the cell, just as you would in a Microsoft Office Excel spreadsheet, and then press ENTER.
3. Double-click the column heading to rename the field.

Based on the value typed, Access automatically defines the data type, although it does so differently from a spreadsheet. In Access, each field—a column in your datasheet—is defined by a data type.

Read more »

Posted in: MS Access 2007

How to Work with Prebuilt Templates in MS Access

Working with Prebuilt Templates in MS Access
The new Getting Started window includes a variety of prebuilt database solutions. You can use these solutions right out of the box, or you can enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. To open a template:
1. Start Microsoft Office Access 2007.
2. Browse the categories to find the template you want, and then click it.
3. Browse for a folder, and then click Download

Read more »

Posted in: MS Access 2007

How to Collect Data via E-Mail in MS Access

Collecting Data via E-Mail in MS Access
Microsoft Office Access 2007 simplifies the process of collecting information from others. It builds the data collection form automatically by using Microsoft Office InfoPath 2007 or HTML in the body of an e-mail message. Microsoft Office Outlook 2007 processes the incoming forms and helps you save the data in your Office Access 2007 data store—effectively updating the database without retyping.

To collect new information via e-mail:
1. Open or select the table containing the fields that you want to collect.
2. On the External Data tab, click Create E-mail.
3. Follow the wizard to create an e-mail form.
a. Select HTML or InfoPath form (if you select the latter, the recipients must have Office InfoPath 2007 and Office Outlook 2007 deployed).
b. Select Automatically process replies and add data to Table if you don’t have to approve each entry before it is saved in the database.

Returned forms will go to a newly created folder named Access Data Collections in your Inbox in Office Outlook 2007. Each time you receive a filled form, it will be flagged as a task for you to review.

To export collected data to Access:
1. If you have not selected automatic processing, right-click the returned e-mail message, and then click Export to Access. Or you can open the message and click the same command from the Ribbon.
2. Green or red icons will flag whether the export was successful or not.

After sending a data collection e-mail message, you can use the Manage Replies command on the External Data tab of the Ribbon to change some of the message options and resend the message.

Read more »

Posted in: MS Access 2007

How to Modify the Report in MS Access

Modifying the Report in MS Access
Here’s how you can modify a report in Microsoft Office Access 2007.
1. Ensure you are in Layout view, which is the default view if you have just created a new report.
2. Select the fields (columns) that you want to delete (press SHIFT to select multiple fields), and then press DELETE.
3. Resize columns by dragging the column edge to the width you want.
4. To reorder columns, select the column that you want to move, and then drag it to another location.
5. Double-click the report title to modify it.
6. To add banded rows, select a row. Then on the Formatting contextual tab, in the Font section, choose a color from Alternate Fill/Back Color.
7. To add a group, in the Grouping pane, click Add a group. If the pane is not open, on the Ribbon, on the Formatting tab, click Grouping. Select the fields that you want to group.
8. To change to Landscape mode or adjust margins, go to the contextual Page Setup tab.

Read more »

Posted in: MS Access 2007

How to Create a New Report in Microsoft Office Acess

Microsoft Office Access 2007 helps you make sense of complex information by offering easy-to-use interactive design tools that you can use to quickly create rich reports that display sorted, filtered, and grouped information. In addition to the traditional Report Designer (Design view), Office Access 2007 introduces a Layout view, so you can look at your data while you’re authoring the report.

To create a report:
1. Open, or select in the navigation pane, a table, a form, or a query.
2. On the Create tab, in the Reports section, click Report. Access automatically includes all the fields in the object selected and opens the report in Layout view.

Read more »

Posted in: MS Access 2007

How I can Make Form Automatically Resize able in MS Access?

Question:-How to Make Your Form Automatically Resize able in MS Access?
Answer:-Make Your Form Automatically Resize able in MS Access 
 
To help your form best use the available screen space, use the Anchoring gallery on the Layout tab. From there you can anchor a control to the right or bottom of your form, or even stretch it. In seconds, you can make your forms automatically resize as your window size varies.

Read more »

Posted in: MS Access 2007

How to Modify Forms in MS Office Access?

Question:-How I can Modify Forms in MS Office Access?
Answer:-Modifying Forms in MS Office Access
To assist with customizing your form, Microsoft Office Access 2007 has a new Layout view (which is open by default after you create a new form) that offers what you see is what you get (WYSIWYG) editing capabilities. To use Layout view to modify a form:
1. Open the form.
2. Switch to Layout view.
3. Select a field by clicking the data entry box.
a. To delete it, press DELETE.
b. To resize it, drag the corner to make it the size you want.
4. To detach a field from the stack, on the contextual Layout tab, in the Control Layout section, click Remove, and then drag it to where you want it on the form.

Read more »

Posted in: MS Access 2007

How to Create Forms in MS Access?

Question:-How I can Create Forms in MS Access?
Answer:-Creating Forms in MS Access?
To assist with data entry, Microsoft Office Access 2007 offers different types of forms. To create a simple form:
1. Open the table that has the fields you want to include in your form.
2. On the Ribbon, on the Create tab, click Form.

The split form is new to Office Access 2007, and it enables you to see both a datasheet view of your data and a traditional form view of your data at the same time. You can use the splitter bar to adjust the size of the datasheet.

Read more »

Posted in: MS Access 2007

How to use Lookups and Relationships

Question:-How I can Use Lookups and Relationships
Answer:-Lookups and Relationships
Often you need to add fields that look up data from other tables. For example, you may want to assign a task to someone in your Contacts table. To add such a field:
1. In datasheet view, on the Ribbon, in the Fields and Columns group, click Lookup Column.
2. If you want to type the lookup values instead of looking up a field from a different table, select I will type in the values; if not, click Next.
3. Select the table that you want to look up from, and then click Next.
4. Select the fields that you want to include in your lookup, and then click Next.
5. Select the sorting method you want, click Next, and then click Next again on the following screen.
6. Label the lookup column and check the box if you want to allow the selection of multiple values. Click Finish.

Read more »

Posted in: MS Access 2007