For business IT peace of mind call
01553 609969

Database Principles using Microsoft Access 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.

Course details

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
Data validation

Queries and Searches
Routine queries to find specific information
Using wildcards

Creating forms to enter, edit and organise data in a database
Alphanumeric sorting and filtering

Database reports
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

Reserve Your Place(s)


Please contact us for details


Yours Business Network
Bishops Lynn House
18 Tuesday Market Place
King's Lynn
PE30 1JW

This course can also be held at your own premises or at a venue of your choice, please contact us for details.

Our Blog

How to Keep Your Data Safe Online

For both individuals and business, keeping data secure is crucial - whether it is passwords, financial information and any other personal data. Cyber attacks have... Read More »

Windows 7 end of life, what does it mean for my business?

On the 14th of January 2020 Windows 7 will be entering its end of life, the implications for machines running this are far reaching as... Read More »

Is your phone recording your conversations?

We are always on guard when talking -- whether on the phone or in public -- we obviously do not want any stranger to listen... Read More »

Call today if you would like to learn more about how you can protect and streamline your IT and data with Anglia IT Solutions.

King's Lynn Office01553 609969

Norwich Office01603 959000