This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Step by step instructions for creating a Reports: To Show all employees sorted by Name (AllEmpByName) To Show all employees sorted by SSNO (AllEmpBySSNO) To Show all employees sorted by Branch Group (AllEmpByBranchGroup) To Show all employees sorted by Position Group (AllEmpByPositionGroup) Open the Access Database (PPS…), under Objects, Highlight "Reports" In the "Choose the table or query where the object's data comes from" prompt box in the query. All employee's data (record) will be displayed from the QAllEmpByName in tabular form. When Reports and AllEmpByName are highlighted click "Design" in Access window Place cursor between the "Report Header" and the "Page Header" until a black line with up/down arrow appears Click and drag the "Page Header" section down one inch, leaving room to create the header. Click out of the label, then click it again to change the font size 18-22. Click Bold While header section of the form is highlighted, click "insert" from "menu bar", then select "Picture" to insert a picture for the logo. You may also cut and paste a picture from another source. (picture must be less than 5kb) Choose a background color for the header. (Ensure that it is a light color) Note : Before you begin this process make sure you have created the relevant queries *Creating a Report to show all employees sorted by Name (AllEmpByName) Click "New" In New Report dialog box, Highlight " Report Wizard " Click the drop down arrow and select the query " QAllByName " Select the double arrows " >> " to select all Available Fields to go into the Selected Fields box. Click "Next" Select " by PPSBASIC " for " How do you want to view your data? " option. Click "Next" Select the appropriate grouping levels Click "Next" For the " What sort order do you want for your records? " Do not select anything as this has already been done Click "Next" Select " Tabular " for " How yould you like to lay out your report? " Click "Next" Select " Formal " for " What style would you like? " Click "Next" In the " What title do you want for your report " type "AllEmpByName" Select the "Open the report to view or enter information" option. Click " Finish " From the "toolbar" select the " Aa " to create a label/ header. Type " ABC Company" Repeat the steps above, creating another label. Type " Personnel Payroll System" Repeat the steps above, creating another label. Type " List of All Employees by Name " Right mouse click inside the header section, select " Fill/Back Color " In the page header section of the report, change the field labels to user friendly terms for example: Change (PL-Name) to (Last Name) Arrange the Unbound and Bound controls in the detail section so that they are all properly lined up Click and drag the controls for page number and date to the report header next to the company logo In the page footer select the "Line" from the "toolbar" and draw a line across the center....
View Full Document
- Spring '11
- Management, Click, Page footer, AllEmpByName