Skip to content

Microsoft Access Foundation

Interactive Video Lessons | Free E-Certificate | Tutor Support


Princeton X

Summary

Price
£12 inc VAT
Study method
Online, On Demand What's this?
Duration
3.5 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students

1 student purchased this course

Add to basket or enquire

Overview

In Microsoft Access Volume 1, you'll embark on a comprehensive exploration of tables and queries, the cornerstone elements of database management. Through a structured series of modules, you'll learn to create and design tables with precision, establishing relationships and ensuring data integrity. Delving into queries, you'll master the art of extracting, filtering, and analyzing data with select, action, and crosstab queries, gaining insights into advanced techniques such as joins, aggregations, and parameterization. By the course's conclusion, you'll possess a solid foundation in Microsoft Access, equipped to tackle real-world database challenges with confidence and proficiency.

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Curriculum

5
sections
19
lectures
3h 33m
total
    • 1: Access Tables and Queries - 1 - Tour of the screen 10:55
    • 2: Access Tables and Queries - 2 - Using Design view to create and edit tables 45:16
    • 3: Access Tables and Queries - 3 - Using the lookup wizard 08:36
    • 4: Access Tables and Queries - 4 - Importing data from Other Data Sources into Acce 17:52
    • 5: Access Tables and Queries - 5 - Linking Tables from Other data Sources into Acce 10:15
    • 6: Access Tables and Queries - 6 - Exporting data from Access to other data types 02:43
    • 7: Access Tables and Queries - 7 - Creating and Managing Table Relationships 10:28
    • 8: Access Tables and Queries - 8 - Database Tools 04:33
    • 9: Access Tables and Queries - 9 - Sort and Filter a Table 05:31
    • 10: Access Tables and Queries - 10 - Basic Queries 22:28
    • 11: Access Tables and Queries - 11 - Prompting the user for the criteria 04:32
    • 12: Access Tables and Queries - 12 - Creating Calculated Fields in a Query 10:19
    • 13: Access Tables and Queries - 13 -Creating Totals Queries 07:43
    • 14: Access Tables and Queries - 14 - Multiple table Queries 11:58
    • 15: Access Tables and Queries - 15 - Viewing the SQL code for an Access Query 05:51
    • 16: Access Tables and Queries - 16 - Using the Query Wizards 08:59
    • 17: Access Tables and Queries - 17 - Creating Subqueries 03:23
    • 18: Access Tables and Queries - 18 - Creating Make Table, Append, Update and Delete 19:27
    • 19: Access Tables and Queries - 19 - Displaying a certain number of records 01:29

Course media

Description

**Microsoft Access Volume 1: Tables and Queries Overview**

Welcome to Microsoft Access Volume 1! In this course, we will dive into the fundamentals of Microsoft Access, focusing specifically on tables and queries.

**Module 1: Introduction to Microsoft Access**
- Understanding the purpose and benefits of Microsoft Access
- Exploring the Access interface: Ribbons, Navigation Pane, and Quick Access Toolbar
- Creating a new database and selecting appropriate templates

**Module 2: Creating Tables**
- Understanding the importance of tables in accessing databases
- Designing table structures: Fields, data types, and properties
- Creating tables using the Table Design View and Datasheet View
- Defining primary keys and establishing relationships between tables

**Module 3: Working with Table Data**
- Entering and editing data in tables
- Sorting and filtering table records for better data management
- Applying validation rules and input masks to ensure data integrity
- Importing and exporting data between Access and external sources

**Module 4: Introduction to Queries**
- Understanding the purpose and benefits of queries in Access
- Different types of queries: Select, Action, Parameter, and Crosstab queries
- Creating queries using the Query Design View and Query Wizard

**Module 5: Building Select Queries**
- Creating simple select queries to retrieve data from tables
- Adding criteria to filter query results
- Utilizing calculated fields to perform calculations on query results
- Sorting query results and formatting output

**Module 6: Advanced Query Techniques**
- Joining multiple tables in queries to retrieve related data
- Using aggregate functions (SUM, AVG, COUNT, etc.) to perform calculations
- Creating nested queries and subqueries for more complex analysis
- Applying query parameters to prompt users for input

**Module 7: Action Queries**
- Understanding action queries: Append, Update, Delete, and Make-Table queries
- Using action queries to add, update, or delete records in tables
- Executing action queries safely and understanding their impact on data integrity

**Module 8: Crosstab Queries**
- Understanding the purpose and structure of crosstab queries
- Creating crosstab queries to summarize and pivot table data
- Specifying row and column headings, as well as value fields
- Formatting crosstab query results for better presentation

**Module 9: Optimization and Performance**
- Optimizing table design for better performance
- Indexing fields to improve query speed
- Monitoring query performance and identifying bottlenecks
- Implementing best practices for efficient database management

**Module 10: Final Project and Review**
- Applying the knowledge gained throughout the course to a final project
- Reviewing key concepts and techniques learned
- Reflecting on the learning journey and setting goals for further exploration

Throughout this course, you will gain a solid understanding of tables and queries in Microsoft Access, empowering you to create and manage databases effectively. Get ready to dive into the world of database management with Microsoft Access Volume 1!

Who is this course for?

  • Construct select queries to retrieve specific data from tables.
    Add criteria and calculated fields to refine query results.
    Sort and format query output for better visualization.
  • Explore advanced query techniques, including joins and subqueries.
    Use aggregate functions to perform calculations on query results.
    Implement parameter queries to prompt user input.

Requirements

No prior knowledge or experience required

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.