Name:
Project: aBRC1 Inventory and Suppliers / Project: BRC2 Company Management
Task / Points / Your Score / Task / Points / Your Score
BR1C Inventory table: / Create a backup of Company Management database / 2
Create fields with correct names and data types / 2 / Inventory Table
Enter two records into table / 2 / Add the Item Image field as an attachment / 2
Import 114 records from Excel spreadsheet / 2 / Add the Cost field as a calculated field with the expression [Retail Price]*0.40 / 3
Apply Best Fit to all fields / 1 / Populate the Item Image field / 1
BRC1 Suppliers table: / Employees Table
Create table by importing 11 records from Excel spreadsheet; set first row as headings; set primary key as Supplier ID; apply Best Fit (Note: 12 records display in table because of activity with form) / 2 / Create the fields in the new table / 3
Relationship Report: / Apply field properties / 2
Create relationship between tables using Supplier ID as common field. / 1 / Create validation rule and text / 2
BRC1 Hiking Query: / Employees Form
Include 4 fields: Item Name, Retail Price, Category, Sport / 1 / Design form to include all fields / 3
Criteria for Sport: hiking / 2 / Add logo and title for Form Header / 2
Sort Item Name; Do not show Sport / 1 / Apply theme to database; apply background color to Header and Footer and an outline to label controls / 2
BRC1 Hiking or Biking Shoes Query: / Add buttons to print current form and close the form / 2
Include 5 fields: Sport, Item Name, Retail Price, Supplier ID, and Category / 2 / Remove buttons and Empl ID as tab stops / 2
Criteria: Sport = hiking or biking; Category = shoes / 4 / Queries
Sort Sport and Item Name; do not show Category / 1 / Create the Average Query / 3
BRC1 S Category Query: / Create the Update Query / 3
Include 5 fields: Item Name, Category, Company, Business Phone, Sport / 1 / Create the Calculated Query / 3
Criteria: Sport = fitness; Category = s* / 4 / Create the Crosstab Query / 3
Sort Category; do not show Sport / 1
BRC1 Price $100 or Over Query: / Average Retail Price by Sport & Company Report / 2
Include 5 fields: Company, Item Name, Category, Sport, Retail Price / 1 / Create the report using a wizard / 3
Criteria: Retail Price - >=100 / 2 / Modify the report design
Sort ascending Sport; descending Retail Price / 1 / Inventory by Sport Report / 3
BRC1 10 Percent Markup Query: / Create the report in Design view / 3
Include 3 fields: Supplier ID, Item Name, Retail Price / 1 / Group the report by sport, sort by Item name / 3
Create two calculated fields; formatted Currency 2 decimal places / 4 / Add and modify controls to count the items per sport
Criteria: Supplier ID = SUPP-01 / 2 / Total Points Part 2 / 50 / 0
BRC1 Supplier Form: / Total Project Points / 100
Use Form tool to create form; create record with student name; change column width to 7.5" / 2
BRC1 Suppliers Contact List report:
Use Report tool to create report with three fields: Company, E-mail Address, Business Phone / 1
Apply Paper Theme; Sort Company; Bold field names; Center Company Name & E-mail Address field names. / 2
Visually center layout; move page# control / 1
BRC1 Avg Price by Category Report:
Use Report Wizard to create report with three fields: Category, Item Name, Retail Price / 1
Group by Category, Sort by Item Name, Average Retail Price / 1
Decrease width of Item Name field; increase width of Retail Price field, including summary calculated controls / 1
Delete summary label control; change text in Avg label control; move label control closer to calculated control / 1
Change font size of title to 16; apply bold and italic to field names. / 1
Keep whole group together on one page / 1
Total Points Part 1 / 50 / 3
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall