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.
Tuition Time:
Date:
Course Location:
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.