Building Access 2010 databases in pdf

Aims and Learning Objectives

This course provides participants with the basic skills necessary to develop a simple Access 2010 database from a paper-based design. 

The core learning objectives for this course are to:

• gain a simple overview of the core relational database concepts
• build a simple database from a paper-based design – to achieve this candidates will:
• create tables and set relationships between tables
• import pre-existing data and enter data manually
• use the wizard to create and use data entry forms to simplify data input
• base a form on a parameter query to view filtered data (if time allows)
• add automation to a form using buttons and macros (if time allows)

Note on versions of Access: 

• Access 2013 users: should have little problem using this document.
• Access 2007 users: should have few problems using this document if they keep in mind that the 2007 Office button has been replaced by a File tab in 2010 and that various command icons have moved, mostly to new locations within the same Ribbon tab.
• Access 2003 users: this document will be of little or no use.