This course teaches learners how to design, build, and interface with a robust database using Access. By the end of the course, students will be able to build tables, establish relationships, query data, and create user-friendly interfaces. The course is designed for individuals comfortable with spreadsheet programs like Excel who need more advanced database management skills. The teaching method includes hands-on exercises and practical examples to reinforce learning.
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.
