The names of objects in the database need to be changed.
The affected objects are the reports and the queries. They must be changed from what they currently are, (see below) to the new name.
Change #1: Object Names.
Current Name Change To
Employees Added People Added
Employees Changed CostCenter People Changed CostCenter
Employees Changed EmpCode People Changed EmpCode
Employees Changed EmpType People Changed EmpType
Employees Changed FullName People Changed FullName
Employees Changed Location People Changed Location
Employees Changed Phone People Changed Phone
Employees Changed Status People Changed Status
Employees Changed StatusCode People Chnaged StatusCode
Employees Changed Title People Changed Title
Employees Removed People Removed
Change #2: Record Totals.
At the bottom of every report on the first page. There must be a total of the number of records in that report. This must appear on the bottom of the right hand corner of the page.
Change #3: Column Widths.
The column widths in the reports should be narrowed as much as possible to allow for as much information as possible to be shown on as few pages as possible.
Please add a total number of record at the bottom right hand side of each report page.
Change #4: Remove Column From Report.
a. Remove or hide the column “Status Code” (marked in red) from all reports.
b. Remove or hide the column “Emp. Number” (marked in red) from all reports.
c. Hide the columns “First Name, Middle name, Last Name” (marked in red) from all reports
Emp. Number First Name Middle Name Last Name Full Name Emp. Type Status Status Code Cost Center Title Phone MailStop Building Floor Office Emp. Code User ID Time Stamp
Change #5: Column Heading Font Size.
Change column heading font size.
Rearrange column fields so that as many column fields fit onto a page as possible.
Hi sir, please check the mail i had sent. I have completed the MAx work.. Some small changes i am doing. i will send you the updated db ASAP. Thanks Somala