Signature 2010 Grading Sheet - EMC Publishing



Grading SheetBenchmark Microsoft Access 2010 Level 1AssignmentTitleStart from ScratchDate DueGradeUnit 1: Creating Table and QueriesChapter 1 Managing and Creating Tables Concepts CheckSkills Check Assessment 1Inserting and Deleting Rows and Columns Skills Check Assessment 2Create a Departments Table Skills Check Assessment 3Create a Benefits TableSkills Check Assessment 4Sort Data Visual BenchmarkCreate an Absences Table Case Study Part 1Elite Limousines: Limousines Table Case Study Part 2Elite Limousines: Drivers Table Case Study Part 3Elite Limousines: Customers Table Case Study Part 4Elite Limousines: Bookings Table SNAP Tutorial 1.1Opening Access, Navigating and Printing a TableSNAP Tutorial 1.2Adding Records in Datasheet ViewSNAP Tutorial 1.3Creating a New DatabaseSNAP Tutorial 1.4Creating a Table Using Quick Start FieldsChapter 2 Creating Relationships between TablesConcepts CheckSkills Check Assessment 1Create Relationships in an Insurance Company DatabaseSkills Check Assessment 2Create a New Table and Relate the TableSkills Check Assessment 3Delete and Edit Records in TablesSkills Check Assessment 4Display and Edit Records in a SubdatasheetVisual BenchmarkCreate an Agents TableCase Study Part 1Gold Star Cleaning Services: Billing TableCase Study Part 2Gold Star Cleaning Services: Connect Tables with One-to-Many RelationshipsCase Study Part 3Gold Star Cleaning ServicesSNAP Tutorial 2.1Creating a Relationship between Two Tables in a DatabaseSNAP Tutorial 2.2Printing, Editing, and Deleting RelationshipsChapter 3 Performing QueriesConcepts CheckSkills Check Assessment 1Design Queries in a Legal Services DatabaseSkills Check Assessment 2Use the Simple Query Wizard and Design QueriesSkills Check Assessment 3Create a Crosstab Query and Use the Find Duplicates and Find Unmatched Query WizardsSkills Check Assessment 4Design and Hide Fields in a QueryVisual BenchmarkCreating Relationships and Designing a QueryCase Study Part 1Skyline Restaurant: Create RelationshipsCase Study Part 2Skyline Restaurant: Create Queries Case Study Part 3Skyline Restaurant: Query WizardsCase Study Part 4Skyline Restaurant: Design QueriesSNAP Tutorial 3.1Creating Queries in Design ViewSNAP Tutorial 3.2Using Criteria Statements in QueriesSNAP Tutorial 3.3Using And/Or Criteria in Queries SNAP Tutorial 3.4Creating Queries Using the Simple Query WizardSNAP Tutorial 3.5Performing Calculations in a QuerySNAP Tutorial 3.6Using Aggregate FunctionsSNAP Tutorial 3.7Using Advanced QueriesSNAP Tutorial 3.8Creating Duplicate and Unmatched QueriesChapter 4 Creating and Modifying Tables in Design ViewConcepts CheckSkills Check Assessment 1Create an Employees Table with the Input Mask and Lookup WizardsSkills Check Assessment 2Create a Projects TableSkills Check Assessment 3Create an Expenses Table with a Validation Rule and Input MaskSkills Check Assessment 4Edit the Employees TableVisual BenchmarkEdit the Expenses Table Case Study Part 1Blue Ridge Enterprises: Representatives TableCase Study Part 2Blue Ridge Enterprises: Clients TableCase Study Part 3Blue Ridge Enterprises: RelationshipsCase Study Part 4Blue Ridge Enterprises: QueriesSNAP Tutorial 4.1Creating a Table and Setting a Primary KeySNAP Tutorial 4.2Modifying Field PropertiesSNAP Tutorial 4.3Using the Input Mask Wizard and the Lookup WizardSNAP Tutorial 4.4Validating Data in a TableSNAP Tutorial 4.5Modifying Table FieldsSNAP Tutorial 4.6Deleting and Sorting RecordsSNAP Tutorial 4.7Completing a Spelling Check and Printing Specific RecordsSNAP Tutorial 4.8Finding and Replacing Specific Data in RecordsSNAP Tutorial 4.9Formatting a DatasheetSNAP Tutorial 4.10Using HelpUnit 1 Performance AssessmentsAssessment 1Create Tables in a Cornerstone Catering DatabaseAssessment 2Create Relationships between TablesAssessment 3Modify TablesAssessment 4Design QueriesAssessment 5Design a Query with a Calculated Field EntryAssessment 6Design a Query with Aggregate FunctionsAssessment 7Design a Query Using Fields from Tables and a QueryAssessment 8Use the Find Duplicates Query WizardAssessment 9Use the Find Unmatched Query WizardWriting Activity 1Create a Payroll Table and Word ReportInternet ResearchVehicle SearchSupplemental Assessment 1Meridian Sales: Use a Database to Track InventoryUnit 2: Creating Forms and ReportsChapter 5 Creating FormsConcepts CheckSkills Check Assessment 1Create and Customize a Sales FormSkills Check Assessment 2Create and Customize an Orders Form and a Products FormSkills Check Assessment 3Create a Split Form with the Products TableSkills Check Assessment 4Create and Customize an Employees FormSkills Check Assessment 5Create and Customize a Benefits FormVisual BenchmarkCreate and Format a Properties FormCase Study Part 1Lewis Vision Care Center: Create RelationshipsCase Study Part 2Lewis Vision Care Center: Create Forms for Tables and Apply ThemeCase Study Part 3Lewis Vision Care Center: Apply Form ConditionsCase Study Part 4Lewis Vision Care Center: Procedures ManualSNAP Tutorial 5.1Create a Form Using the Form ButtonSNAP Tutorial 5.2Adding Records and Navigating in a FormSNAP Tutorial 5.3Adding and Modifying ObjectsSNAP Tutorial 5.4Modifying a FormSNAP Tutorial 5.5Modifying Forms Using Labels and Calculated Controls SNAP Tutorial 5.6Creating a Split Form and Multiple Items Form SNAP Tutorial 5.7Creating a FormChapter 6 Creating Reports and Mailing LabelsConcepts CheckSkills Check Assessment 1Create and Format Reports in the Hilltop DatabaseSkills Check Assessment 2Create Reports Using the Report Wizard Skills Check Assessment 3Create Mailings Labels Skills Check Assessment 4Add a Field to a Report Visual BenchmarkDesign a Query and Create a Report with the Query Case Study Part 1Millstone Legal Services: Enter DataCase Study Part 2Millstone Legal Services: Create and Print Queries, Reports, and LabelsCase Study Part 3Millstone Legal Services: Apply Conditions to FieldsCase Study Part 4Millstone Legal Services: Procedures ManualSNAP Tutorial 6.1Creating a ReportSNAP Tutorial 6.2Modifying a ReportSNAP Tutorial 6.3Modifying Reports Using Calculated Columns and Conditional FormattingSNAP Tutorial 6.4Creating a Report Using the Report WizardSNAP Tutorial 6.5 Creating Mailing LabelsChapter 7 Modifying, Filtering, and Viewing DataConcepts CheckSkills Check Assessment 1Filter Records in TablesSkills Check Assessment 2Save a Table and Database in Different File FormatsSkills Check Assessment 3Delete and Rename ObjectsVisual BenchmarkDesign a Query and Filter the QueryCase Study Part 1Summit View Medical Services: Add Database InformationCase Study Part 2Summit View Medical Services: Create Filters and QueriesCase Study Part 3Summit View Medical Services: Save a Table as a PDFCase Study Part 4Summit View Medical Services: Procedures ManualSNAP Tutorial 7.1Filtering RecordsSNAP Tutorial 7.2Compacting, Repairing, and Backing Up a DatabaseSNAP Tutorial 7.3Encrypting a Database with a Password and Modifying Document PropertiesSNAP Tutorial 7.4Customizing the Recent tab in Backstage viewSNAP Tutorial 7.5 Saving Databases and Database Objects in Different FormatsChapter 8 Importing and Exporting DataConcepts CheckSkills Check Assessment 1Export a Form to Excel and a Report to WordSkills Check Assessment 2Merge Table and Query Data with a Word DocumentSkills Check Assessment 3Import and Link an Excel WorkbookVisual BenchmarkCreate a Report and Export the Report to WordCase Study Part 1Woodland Dermatology Center: Update a DatabaseCase Study Part 2Woodland Dermatology Center: Merge Database Information Into a LetterCase Study Part 3Woodland Dermatology Center: Save a Database Object as a PDFCase Study Part 4Woodland Dermatology Center: Procedures ManualSNAP Tutorial 8.1Exporting Access Data to Excel and WordSNAP Tutorial 8.2Merging Access Data with a Word DocumentSNAP Tutorial 8.3Importing and Link Data to a New TableSNAP Tutorial 8.4Using the Office ClipboardUnit 2 Performance AssessmentsAssessment 1Create Tables in a Clinic DatabaseAssessment 2Relate Tables and Create Forms in a Clinic DatabaseAssessment 3Create Forms Using the Form WizardAssessment 4Create Labels with the Label WizardAssessment 5Filter Records in TablesAssessment 6Export a Table to ExcelAssessment 7Merge Records to Create Letters in WordAssessment 8Import and Link Excel Data to an Access TableWriting Activity 1Add a Table to the Clinic DatabaseWriting Activity 2Merge Records to Create Letters to Insurance CompaniesInternet ResearchHealth Information researchJob StudyCity Improvement ProjectsSupplemental AssessmentExtreme Ski RentalsFinal Case StudyCellOne Phones ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download