Dive into an advanced 5-hour tutorial on Microsoft Access, designed for users familiar with spreadsheet programs who need more powerful data analysis and management tools. Learn to create and manage robust databases for small to medium-sized businesses. Begin with database fundamentals before progressing to building tables, establishing relationships, querying data, and designing user-friendly interfaces. Master advanced techniques such as multi-table queries, wild card symbols, parameter queries, and various query types including crosstab, make-table, delete, update, and append. Explore data export and import functionalities with PDF, Word, and Excel, as well as linking between Access databases. Gain practical skills through hands-on exercises and comprehensive examples, equipping you to efficiently design and manage databases for your organization.
Overview
Syllabus
Start
Introduction
Showing File Name Extensions
Opening Query.mdb
Updating File Formats and Showing Document Tabs
Hiding Table Fields
Unhiding Table Fields
Creating and Running Queries
Sorting the Query
More Ways to Select Views
Filtering Using OR
Filtering Using AND
Combining AND with OR
Filtering Using NOT and NULL
Multi-Table Queries
Wild Card Symbols
Calculations
Concatenating Words
Parameter Queries
Introduction
Multiplying and Aggregating
Subtotals via a Totals-Query
Crosstab-Query
Make-Table Query
Delete-Query
Update-Query
Append-Query
Exporting to PDF
Exporting to Word-RTF
Exporting to Excel
Importing from Excel
Linking to Excel
Linking from Access to Access
Lookup List in a Query
Taught by
Learnit Training
Related Courses
Related articles
Reviews
5.0 rating, based on 2 Class Central reviews
-
Another great couple of modules thanks Dan - excellent overview of queries and importing/exporting data and making links. You've created an engaging learning environment where we work alongside you, learning and practicing as we go. Great to have you throw out regular challenges to recall earlier material, along with us creating first and then watching you to check we've got it right. I thought your pirate impression was top notch! If you ever feel like a career change, I hear Pirates of the Caribbean might be looking for new people (smiley face with tears).
-
This course builds nicely off of the beginner course. Looking forward to jumping into the expert course next.
