Level 3 Database Software


Level 3 Database Software course helps the delegate to get more from database applications, by using the many advanced tools available to better organise and manage information. By completing this course you will learn advanced digital skills such as performing advanced queries, creating form controls and running macros. ​

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

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

  • Produce professional spreadsheets using powerful features
  • Have an increased knowledge and expertise sort by employers
  • Demonstrate more advanced techniques to retrieve information.

Download the course content

Tuition Time:

14 hours


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

Course Location:

Book this course

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


Level 3 Database Software course is suitable for existing Microsoft Access users who use the features listed on our level 2 course content on a weekly basis or have either attended our Level 2 Database Software course and are seeking to improve their understanding and knowledge to produce effective, powerful and robust databases.

Course Content

Creating a New Database and Table
• Creating a new database
• Designing a Table
• Using Field Properties
• Entering records in Datasheet View

• Using Wildcards in a Query
• Sum , Count,
• Not and Null Queries
• Group by
• Using Mathematical Operators
• Average Values
• Maximum and Minimum Values
• Calculated Fields in Queries
• Parameter Queries

• Applying a Primary Key
• Applying Relationships
• Creating other Relationships
• Querying Related Tables
• Applying Joins
• Referential Integrity
• Updating and deleting records
• Viewing a Subdatasheet

Field Properties
• Lookup Fields
• Format Field Properties
• Default Values
• Setting a mandatory field
• Validation rules/text
• Input Masks

• Form Wizard, Subform Wizard and Manual
• Linking Forms
• Multiple Table Forms
• Calculated Fields
• Command Button
• List and check boxes

• Grouped Reports: Wizard
• Grouped Reports: Manual
• Calculated Fields
• Calculating Percentages
• Report Headers & Footers
• Printing Reports

Import and Export Data
• Importing and exporting Data
• Linking Data

• Macro Actions
• Create a new Macro
• Create a Macro to a Control
• Create a Macro from a Control
• Multiple Action Macros
• AutoExec Macro


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.