Login

Register

Login

Register

Level 3 Database Software

£250.00

This 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 covers 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 Presentation 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

Date:

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
Delegates:
Book this course

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

Pre-Requisite

This 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

Queries
• 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

Relationships
• 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

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

Reports
• 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

Macros
• 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.