4-30. Access Application: DD-Designs

1. Devon Degosta set up an Access database to manage her web design business. She has asked you to create a report that summarizes and identifies projects that are assigned to more than one employee. Recreate the Access database with the table names, attributes, and relationships as illustrated in Figure 4-29 . Download and use the information in the spreadsheet Ch04Ex02 to populate the tables. Create a report that lists each project by name and the names of the employees assigned to it. Devon wants the report to include the client name and the project budget. What other reports would Devon find useful?

bookshelt.vita source.com spreadsheet Ch04ExO2 to populate the tables. Create a report that lists each project by name and the names of the employees assigned to it. Devon wants the report to include the client name and the project budget. What other repo would Devon find useful? FLE Replace HOME CREATE * Cut Copy Paste Format Painter Clipboard Relationships EXTERNAL DATA DATABASE TOOLS 21 Ascending Selection 31 Descending Advanced Remove Sort Toggle Filter Sort & Fit RELATIONSHIP TOOLS CH4_00 Designs DESIGN New Totals Pc Save Spelling Go To Refresh Find All X Delete. More Select Records Find View Filter BIO Views Employees Employee Last name First name Date of birth Address Employees Projects Employee Project Departments y Department Department name Department building Department office Department phone State Zip Code Email address Phone number Department Projects Project Project name Start date Budget Client Clients Client Company name Contact person Address State Zip Code Phone number Figure 4-29 DD_Designs database schema. Source: Microsol Access, Microsoft Corporation