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.
Date: This is a roll-on, roll-off course and learners can enrol at any time.
Tuition Time: 12 hours
Full Course Fee £200
Location: Riverside Innovation Centre, 1 Castle Drive, Chester CH1 1SL
This course can be offered as group training. Please click here for a quote.
Pre-Requisites
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 |
Course Objectives
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.
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:
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.
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.