Access assessment task

[Trish]

Hi, I am about to do a level 2 or 3 Access test using typical Access
features, like sorting, queries etc. Is there a generic marking guide
anywhere that can suggest to me what the main features are that might be
assessed and the weighting given to each of these? Eg I would like some idea
of a typical marking scale apportioned by the degree of difficulty etc. I
hope this makes sense. There must be some Access teachers out there that can
throw some light on this. What do they look for and how is it marked? This
will assist be greatly in my preparation. PS - I have to do a similar
assignment in Excel so will be posting a similar question under Excel. Many
thanks in advance for any assistance.

 

[Arvin Meyer [MVP]]

Degree of difficulty is very subjective. I do not think there is any
particular guide out there, although some of the commercial tutorials have
divided tasks into Beginner, Intermediate, and Advanced. Here's one of them:

Access 2003: Beginner Level
a.. 1.0 Introduction
b.. 1.1 Starting Access
c.. 1.2 The Access Window, Menu Bar, Tool Bars and Task Pane
d.. 1.3 Help in Access
e.. 1.4 Creating a Database - Fields, Properties, and Datasheet View
f.. 1.5 Copying Databases
a.. 2.0 Working with an Existing Database
b.. 2.1 Viewing & Navigating Table Data
c.. 2.2 Widening Datasheet Columns and Editing Table Data
d.. 2.3 Adding Records to a Table
e.. 2.4 Selecting & Deleting Records
f.. 2.5 Find & Replace
g.. 2.6 Modifying the Appearance of a Datasheet
h.. 2.7 Spell-Check & Auto-correct
a.. 3.0 Form Basics
b.. 3.1 Using a Form Wizard and Moving from Record to Record
c.. 3.2 Finding Data
d.. 3.3 Sorting Data
e.. 3.4 Filtering Data
f.. 3.5 AutoForms
a.. 4.0 Report Basics
b.. 4.1 AutoReports & the Report Wizard
c.. 4.2 Zooming In & Out
d.. 4.3 Moving from Page to Page
e.. 4.4 Viewing Multiple Pages
f.. 4.5 Printing
Access 2003: Intermediate Level
a.. 1.0 Planning & Designing a Database
b.. 1.1 Copy Database for Intermediate Lessons
c.. 1.2 Creating a Database Using a Wizard
a.. 2.0 Building & Modifying Tables
b.. 2.1 Evaluating Inputs and Outputs
c.. 2.2 Creating Tables Using a Wizard
d.. 2.3 Creating Tables without the Use of a Wizard, Field Properties,
Input Masks
e.. 2.4 The Lookup Wizard
f.. 2.5 Format, Default Value, Validation Rules and Validation Text
a.. 3.0 Working with Relationships
b.. 3.1 Introduction to Relationships
c.. 3.2 Setting Primary Keys
d.. 3.3 Indexes, Relationships and Normalization
e.. 3.4 Printing Relationships
Access 2003: Advanced Level
a.. 1.0 Designing Simple Queries
b.. 1.1 Selecting Fields in Single and Multiple Tables
c.. 1.2 Ordering the Query Result & Refining Queries with Criteria
d.. 1.3 Updatability of Query Results
a.. 2.0 Building and Modifying Forms
b.. 2.1 Adding Controls
c.. 2.2 Selecting, Moving, Sizing, Deleting and Aligning Controls
d.. 2.3 Changing Control Properties
e.. 2.4 Changing the Tab Order Controls and Form Properties
f.. 2.5 Working with Combo Boxes & List Boxes
a.. 3.0 Building & Modifying Reports
b.. 3.1 Creating Groups and Total Reports
c.. 3.2 Understanding Report Bands
d.. 3.3 Working with Controls
e.. 3.4 Working with Report Properties
f.. 3.5 Modifying Selection Criteria
a.. 4.0 Managing Databases
b.. 4.1 Identify Object Dependencies
c.. 4.2 Import Data to Access
d.. 4.3 Export data from Access
e.. 4.4 Create and Modify Calculated Fields and Aggregate Functions
f.. 4.5 Create a Data Access Page
g.. 4.6 Back up a database
h.. 4.7 Compact and repair databases

 

[Trish]

Thanks so much, Arvin. That was very helpful.