This courses Introduces delegates to basic database software tools, enabling them to enter information, set up single tables and retrieve information by running database queries.
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: 10 hours
Full Course Fee £150
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: 10 hours
Full Course Fee £150
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 are either self-taught or new to Database Software and would like to improve the quality and efficiency of their documents. Users are required to be able to use a keyboard and mouse and comfortable with Windows 10.
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 Tables • Use the Table Wizard • Fields, Data Types and Properties Data Input and Selection • Amending records using the Table View • Adding records • Deleting records • Using data fields Editing a Database • Search and replace • Search using two criteria • Widening columns • Using Headers and Footers Printing • Using Print Preview • Printing records • Printing in landscape File Management • Creating and saving a database • Rename a database • Deleting a database Queries • Create a query • Run a query using one criteria • Sort a query |
Reports
• Creating Reports • Report Wizard • Printing Reports Using a Comparison Operator • Greater than • Less than • Equal to • Greater than and equal to • Less than or equal to |
Course Objectives
By the end of Level 1 Database Software you will be able to:
• Identify Database Software.
• Produce a Database document using editing and formatting techniques.
• Demonstrate techniques to retrieve information.
• Identify Database Software.
• Produce a Database document using editing and formatting techniques.
• Demonstrate 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.