Database Principles using Microsoft Access
This one day course allows the participants to become familiar with the Microsoft Access software using Access 2010. The course will demonstrate the principles of database design and how to set up and use non-relational database tables.
Delegates should be familiar with the keyboard and Microsoft Windows Operating System. A familiarity of Microsoft Access would be an advantage.
Understand the components of a database design
How data is structured in a single table non-relational database
Create and modify database tables using a range of field types
Add, amend and delete fields.
Ensuring data entry meets needs
Understanding field characteristics
Data type, field name, field size, format, validation; primary key
Queries and Searches
Routine queries to find specific information
Creating forms to enter, edit and organise data in a database
Alphanumeric sorting and filtering
Plan and produce database reports from a single table non-relational database
* There may be some flexibility in content according to the audience on the day