226051 MS Access DB Modification

Database Changes:

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.

Kemahiran: Semua Boleh, Microsoft Access, Visual Basic

Lihat lagi: time stamp, remove object, microsoft access database modification, EMP, change column, add access, code database access, access center, red status code, add code access database, access floor, access report code, access code report, access database employees, changes access, name full, code access report, access code database, basic page report, access office database, hide phone, phone modification, report access, must access page, add record access database

Tentang Majikan:
( 6 ulasan ) Washington,

ID Projek: #1972288

Dianugerahkan kepada:


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

$20 USD dalam sehari
(0 Ulasan)