Udemy | Microsoft Access: Beyond the Basics of Access Bundle 2020/3

Microsoft Access: Beyond the Basics of Access Bundle

Udemy | Microsoft Access: Beyond the Basics of Access Bundle 2020/3

What you’ll learn

  • This bundle combines 3 courses to help you conquer Access in weeks – not months or years (because who’s got time for that?)
  • Learn TIME-SAVING Database Tips, AUTOMATE Your Database with MACROS, and SCRIPT SQL all in one course!
  • ———-
  • ———-
  • SET Field Validations. Make sure users are entering the correct data.
  • IMPORT and EXPORT Data Using Microsoft Excel, an application you probably use daily.
  • CREATE Cascading Combo Boxes. Base the items in a combo box off what was selected in another combo box.
  • CONDITIONALLY FORMAT Forms & Reports to make your data easier to understand.
  • CREATE Parameter & Action Queries. Go beyond standard Select Queries
  • CUSTOMIZE the Access Environment Ribbon, Navigation Pane & Startup
  • UNDERSTAND Database Maintenance Tools to keep your data intact.
  • USE the Macro Builder Window to automate your database
  • CREATE Data Macros for Table Automation
  • CREATE Macros for Forms & Reports
  • CREATE AutoExec Macros to run Macros when starting your database
  • SCRIPT SQL to Query Your Tables
  • CREATE Database Tables with SQL
  • CREATE Table Joins with SQL
  • CREATE Action Queries with SQL
  • … and so much more!

Requirements

  • Download the Northwind database to follow along with examples in this course. The Northwind database is available through the Access application. Please see Lecture 2 for details.

Description

Microsoft Access Three Course Bundle:

→ Access: Customizing Tables, Forms, Reports & Action Queries

→ Microsoft Access Macros: Automate Your Access Database

→ Microsoft Access SQL: SQL for Non-Programmers

 Microsoft Access: Beyond the Basics of Access Bundle

Part 1 Part 2

Source : www.udemy.com

, ,

Related Posts

No results found.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Menu