Overview
Microsoft Access offers a powerful, feature-packed solution for building a robust data landing pad. This 10-hour video training course gives your team the knowledge and skills you need to make this cost effective and easy-to-use database application work for your organisation.
Access is now much more than a way to create desktop databases. Its an easy-to-use tool for quickly creating browser-based database applications that help you run your business. Your data is automatically stored in a SQL database, so its more secure than ever, and you can easily share your applications with colleagues.
In this course we will cover the basics of Access working up to more intermediate uses of Access. Areas to be covered include: setting up a database, exploring the ribbon, understanding macros and much more.
Pre-requisites
- PC or Mac with a full version of Microsoft Access 2013/2016
- Not a requirement but a benefit to have some work-related projects to which you can readily apply what you learn.
Relevant audiences
- People who have never used either a database or Access before but have reasonable knowledge of other Microsoft applications
- Access 2000/2003 users who are unfamiliar with the newer versions of Access
Learning Outcomes
- Set-up a database on your desktop, or on the web
- Explore the Ribbon interface and how to work with touch devices
- Use table templates to create forms and add custom elements
- Understand Macros and how they work
- Import data from external sources
Syllabus
Section 1: Foundation
- Unit 1.1 - Introduction
- Unit 1.2 - Getting Started
Section 2: The User Interface
- Unit 2.1 - The Ribbon and Toolbars
- Unit 2.2 - Keyboard Shortcuts and Key Tips
- Unit 2.3 - Access Options
Section 3: Tables, Forms & Data
- Unit 3.1 - Tables
- Unit 3.2 - Importing Data
- Unit 3.3 - Backup, Restore, and Repair
- Unit 3.4 - Datasheet View
- Unit 3.5 - Relationships
- Unit 3.6 - Forms
- Unit 3.7 - Subforms
Section 4: Queries, Expressions and Reports
- Unit 4.1 - Queries
- Unit 4.2 - Expressions
- Unit 4.3 - Reports
- Unit 4.4 - Printing
Section 5: Data Types and Form Controls
- Unit 5.1 - Data Types
- Unit 5.2 - Form Controls
Section 6: Streamlining workflow
- Unit 6.1 - Modal, Dialogs, and Macros
- Unit 6.2 - Web App Basics
- Unit 6.3 - Exporting
- Unit 6.4 - Application Parts
- Unit 6.5 - Advanced Access Options
- Unit 6.6 - Info Tab
- Unit 6.7 - Security
Section 7: Closure
- Unit 7.1 - Conclusion