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