Microsoft Access Tables and Queries
- Instructor Unique
- Original
- Video Training
Master Microsoft Access Tables and Queries to organise data efficiently, create structured databases, build powerful queries, filter information accurately, and generate meaningful reports for improved business analysis and decision-making.
Microsoft Access Tables and Queries
Or
Take All courses for £49
1 Year Access -
Level 3
-
8 Students
-
6 days, 5 hours
1 Year Access 
8 Students 
6 days, 5 hours Get access to 5000+ courses including this for only £49. Learn More.
Learning Outcome
- Use design view to create tables.
- Use Lookup Wizard and import tables from other data sources.
- Know how to link tables to other data sources and export data from Access into different types of data.
- Understand the relationship between database tools and creating table relationships.
- Learn about basic queries.
- Prompt users for criteria, query wizards, subqueries, and calculated field queries.
- Learn to use multiple tables in a query.
- Know how to append, make a table, update, and delete queries.
- Show a certain amount of records in a query.
Description
The Microsoft Access Tables and Queries is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain an endorsed certificate after completing the course. Enrol now for a limited-time discounted price.
Like all the courses of One Education, this Microsoft Access Tables and Queries is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily.
We don’t just provide courses at One Education; we provide a rich learning experience. After purchasing a course from One Education, you get complete 1-year access with tutor support.
Our expert instructors are always available to answer all your questions and make your learning experience exquisite.
After completing the Microsoft Access Tables and Queries, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV.
If you want to learn about this topic and achieve a certificate, you should consider this Microsoft Access Tables and Queries from One Education.
We are very upfront and clear about all the costs of the course.
Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new achievement. Endorsed certificates can be ordered and get delivered to your home by post for only £79. There is an additional £10 postage charge for international students.
CPD Certification from One Education
After successfully completing the assessment of this course, you will qualify for the CPD Certificate from One Education as proof of your continued expert development. Certification is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.
Endorsement
This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Method of Assessment
In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate.
Why Study This Course
Whether you’re an existing practitioner or aspiring expert, this course will enhance your expertise and boost your CV with key skills and an endorsed lesson attesting to your knowledge.
The Microsoft Access Tables and Queries is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Course Curriculum
| Microsoft Access Tables and Queries | |||
| Tour of the screen | 00:11:00 | ||
| Using Design view to create and edit tables | 00:45:00 | ||
| Using the lookup wizard | 00:09:00 | ||
| Importing data from Other Data Sources into Access | 00:18:00 | ||
| Linking Tables from Other data Sources into Access | 00:10:00 | ||
| Exporting data from Access to other data types | 00:03:00 | ||
| Creating and Managing Table Relationships | 00:10:00 | ||
| Database Tools | 00:05:00 | ||
| Sort and Filter a Table | 00:06:00 | ||
| Basic Queries | 00:22:00 | ||
| Prompting the user for the criteria | 00:05:00 | ||
| Creating Calculated Fields in a Query | 00:10:00 | ||
| Creating Totals Queries | 00:08:00 | ||
| Multiple table Queries | 00:12:00 | ||
| Viewing the SQL code for an Access Query | 00:06:00 | ||
| Using the Query Wizards | 00:09:00 | ||
| Creating Subqueries | 00:03:00 | ||
| Creating Make Table, Append, Update and Delete Queries | 00:19:00 | ||
| Displaying a certain number of records | 00:01:00 | ||
| Assignment | |||
| Assignment – Microsoft Access Tables and Queries | 6 days, 2 hours | ||
| Order Your Certificate | |||
| Order Your Certificate QLS | 00:00:00 | ||
Microsoft Access Tables and Queries