Microsoft Access Programmer Jamaica, New York

Microsoft Access Programmer Information

Call MS Access Solutions at (323) 285-0939 for a Complimentary Consultation.

The material below originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development. Reprinted here by author's permission. There may be references to "Figures" or "Chapters"that are not reprintable and are not used on this page.

Creating A Report From Design View

Although you usually start most of your reports by using a Report Wizard, you should understand how to create a new report from Design view. To create a report without using a wizard, click the Report Design button in the Reports group of the Create tab. The Report Design window appears. You must then set the Record Source of the report to the table or query upon which you want the report to be based.

Working With The Report Design Window

You use the Report Design window to build and modify a report. Using this window, you can add objects to a report and modify their properties. Microsoft provides numerous Report, Report Grouping, and Control properties. By modifying these properties, you can create reports with diverse looks and functionality.

Understanding Tthe Report Design Tools

To help you design reports, several report design tools are available, including the Ribbon, Property Sheet, Field List, and Sorting and Grouping windows. Three tabs are also available to make developing and customizing your reports easier: Design, Arrange, and Page Setup. The Design tab contains tools that allow you to group and total your report, add controls to your report, add existing fields to the report, and view and modify the property sheet associated with the report. The Arrange tab is specifically designed to help you customize the look of your report. It includes tools for applying an AutoFormat to a report, aligning and positioning control on the report, and sizing report objects.

The Properties, Toolbox, Field List, and Sorting and Grouping windows are all designed as toggles. This means that buttons on the Report Design toolbar alternately hide and show these valuable windows. If you have a high-resolution monitor (or multiple monitors), you might want to leave the windows open at all times. If you have a low-resolution monitor, you need to get a feel for when it's most effective for each window to be opened or closed.

Adding Fields To A Report

You can most easily add fields to a report by using the Field List window. With the Field List window open (see Figure 6.11), click and drag a field from the field list onto the appropriate section of the report. You can add several fields at one time, just as you can do with forms. Use the Ctrl key to select noncontiguous fields, use the Shift key to select contiguous fields, or double-click the field list's title bar to select all the fields; then click and drag them to the report as a unit.

Selecting, Moving, Aligning, And Sizing Report Objects In Microsoft Access

Microsoft Access offers several techniques to help you select, move, align, and size report objects. Different techniques are effective in different situations. Experience will tell you which technique you should use and when. The steps for selecting, moving, aligning, and sizing report objects are quite similar to performing the same tasks with form objects. The techniques are covered briefly in this chapter; for a more detailed explanation of each technique, refer to Chapter 5, "What Every Developer Needs to Know About Forms."

This material originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development. Reprinted here by author's permission.

Expert Microsoft Access Programmer In Jamaica, New York

When you need a Microsoft Access programmer for your Jamaica, New York business, call MS Access Solutions at (323) 285-0939. We have over 25 years of experience as a Microsoft Access programmer agency. We create Access database applications for all sectors, including but not limited to: hospitals, government agencies, agriculture, the human resources companies and departments, and insurance providers, the U.S. military, and universities. We work with the most difficult and complex Microsoft Access and SQL Server database programming for businesses; including slow Microsoft Access database processing. We also work on smaller projects, like repairing damaged Access database forms, stalled MS Access reports, broken Access queies, fixing and reprogramming Access macros, and recoding broken Visual Basic For Applicattions (VBA) code. Our Microsoft Access programmers can create a reliable and robust database application that will work properly and provide you with the best Microsoft Access database for your business.

Find out more about our services at the Access Programmer New York, New York web page.