Tips for tackling a MS Access Project

Some useful skills that you probably should exhibit in your MS Access project

Structuring A Database

·Create Access databases

·Create and modify tables

·Define and create field types

· Modify field properties

· Create and modify one-to-many relationships (if necessary)

· Enforce referential integrity

·Create and modify queries

· Create forms

· Add and modify form controls and properties

·Create reports

·Add and modify report control properties

· Create a data access page

Entering Data

· Enter, edit and delete records

·Find and move among records

· Import data to Access (if necessary)

Organizing Data

· Create and modify calculated fields and aggregate functions

· Modify form layout

· Modify report layout and page setup

· Format data sheets

·Sort records

· Filter records

Managing Databases

· Identify and modify object dependencies

·View objects and object data in other views

·Print database objects and data

· Export data from Access (if necessary)

· Back up a database

· Compact and repair databases (if necessary)

·Enforce data security (e.g use of password or encrypt DB)

DISCLAIMER: The above are in no way the marking guidelines followed by the Examination Council

Some useful skills that you probably should exhibit in your MS Access project

Structuring A Database

·Create Access databases

·Create and modify tables

·Define and create field types

· Modify field properties

· Create and modify one-to-many relationships (if necessary)

· Enforce referential integrity

·Create and modify queries

· Create forms

· Add and modify form controls and properties

·Create reports

·Add and modify report control properties

· Create a data access page

Entering Data

· Enter, edit and delete records

·Find and move among records

· Import data to Access (if necessary)

Organizing Data

· Create and modify calculated fields and aggregate functions

· Modify form layout

· Modify report layout and page setup

· Format data sheets

·Sort records

· Filter records

Managing Databases

· Identify and modify object dependencies

·View objects and object data in other views

·Print database objects and data

· Export data from Access (if necessary)

· Back up a database

· Compact and repair databases (if necessary)

·Enforce data security (e.g use of password or encrypt DB)

DISCLAIMER: This is not the KNEC marking, just some useful tips that will put you above the rest