Login

Register

Login

Register

Level 2 Database Software

£200.00

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

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

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

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

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

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

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