A Skills Approach – Access Chapter 5 is now available, as are all the questions related to it. This means that In Practice Access will also have additional questions available for chapters 1, 2, 5, 8, and 9.
Access Projects using new Grading Technology
Access 2013 In Practice – Ch 1 Guided Project 1-2 (Upload .accdb)
Access 2013 In Practice – Ch 2 Improve It Project 2-7 (Upload .accdb)
Access 2013 In Practice – Ch 3 Independent Project 3-6 (Upload .accdb)
Access 2013 In Practice – Ch 4 Independent Project 4-4 (Upload .accdb)
Determine if table fields have the correct data types, field size, and whether the field is required.
Determine if relationships have been created between tables, whether the relationships are one-to-one or one-to-many, and whether enforce referential integrity, cascade on update, and cascade on delete have been checked.
Determine if a query contains specific fields including calculated fields.
Determine if a query has correct criteria including parameterized criteria.
Determine if a query searches for records with duplicate values in a table.
Check the control types on a form or report.
Check properties of controls on forms or reports such as format, height, width, and control source.
Determine if form and report headers and footers contain specific controls.
Check the type of form such as split form or data sheet.
Check if a form contains a sub form.
Determine if reports group records by specific fields.
Check report page setup properties.
Slide Master and Slide Layout Grading
Determine if placeholders exist, have the correct size, fill color, outline, fonts, and other properties.
Determine if shapes exist, have the correct shape type, size, fill color, outline, and other properties.
Determine if a picture background has been removed.
Determine if a picture has been cropped to a shape.
Determine if a picture has specific effects such as shadows and artistic effects such as gray scale.