Level 2 Database Software


This course is designed for users who wish to improve on their existing Access skills to produce a more professional database. Delegates will gain the digital skills to use more complex features of Access such as creating relationships and retrieving and manipulating information using additional criterias when querying and sorting data.

You will receive an Academy certificate on completion of this course.

By the end of Level 2 Database Software you will be able to:

  • Produce high-quality Database documents using editing and formatting techniques
  • Have an increased knowledge sort by employers
  • Demonstrate more complex techniques to retrieve information.

Download the course content

Tuition Time:

12 hours


This is a roll-on, roll-off course and learners can enrol at any time

Course Location:

Riverside Innovation Centre, 1 Castle Drive, Chester CH1 1SL
Book this course

​This course can be offered as group training, please click here for a quote.


This course is suitable for those who have either attended our Level 1 Database Software course or use the features listed on our level 1 course content on a weekly basis.

Course Content

Getting started with Microsoft Access
• Introduction to Database
• Opening a Database file
• Closing a Database file
• Using Help
• Working with the Ribbon
• Customising the Quick Access Toolbar

File Management
• Creating and saving a database
• Rename a database
• Deleting a database

• Fields, Data Types and Properties
• Indexing records
• Use a Primary Key

Data Input and Selection
• Amending records using the Table View
• Adding records
• Deleting records
• Using data fields

Editing a Database Table
• Sort
• Use field selectors and data types
• Find and replace

• Create a one-to-one relationship
• Create a one-to-many relationship
• Delete a relationship

• Use Criteria Operators => < <>>= <=
• Sort, Run and modify a Query
• Hide a Query
• Delete a field from a Query
• Print a Query

• Navigate a Form
• Modify a Form
• Use Tab Order
• Print a Form
• Delete a Form

• Sort a Report
• Use Summary options (Sum, Avg, Min or Max)
• Editing a Report
• Moving a Field
• Change Sort order
• Delete, edit and move an Object
• Format a Report

About the Provider

​We are two highly qualified teachers with extensive experience of working in further education and can provide a range of digital training opportunities. We offer a high quality customised service that recognises each organisation’s challenges. We will also provide digital skills training for individuals so they can reap the benefits of long-term success.

We offer:

  • Upskilling ‘non-qualification’ training
  • Flexible Delivery
  • Cost and time effective
  • Delivered by ‘Outstanding Treachers’ as recently identified by Ofsted
  • Consultation to identify your specific training needs

Want to know more

To find out more about our tailored Digital Skills Training for Businesses, Groups and Individuals, please email: info@cdsacademy.co.uk or telephone us for an initial informal chat on 01244 515525 to discuss your requirements.