Access 2007 Advanced

Access 2007 Advanced, available at $19.99, has an average rating of 4.55, with 38 lectures, based on 18 reviews, and has 145 subscribers.

You will learn about Understand how to design an application Effectively use subforms, dialog boxes, and controls Unleash the power of macros Correctly wrap up development Learn helpful programming tips This course is ideal for individuals who are Students who are familiar with creating and expanding upon basic databases looking to automate their databases through the use of macros, create more effective reports and use controls It is particularly useful for Students who are familiar with creating and expanding upon basic databases looking to automate their databases through the use of macros, create more effective reports and use controls.

Enroll now: Access 2007 Advanced

Summary

Title: Access 2007 Advanced

Price: $19.99

Average Rating: 4.55

Number of Lectures: 38

Number of Published Lectures: 38

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 38

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Understand how to design an application
Effectively use subforms, dialog boxes, and controls
Unleash the power of macros
Correctly wrap up development
Learn helpful programming tips

Who Should Attend

Students who are familiar with creating and expanding upon basic databases looking to automate their databases through the use of macros, create more effective reports and use controls

Target Audiences

Students who are familiar with creating and expanding upon basic databases looking to automate their databases through the use of macros, create more effective reports and use controls

This course builds on the Introduction and Intermediate courses to show you how to bring all of the different Access objects and development phases together to make a cohesive application. It also teaches you many different techniques to make Access even more interactive by using dialog boxes, subforms, and more controls. Finally, the course shows you how to create different types of macros and how to select the proper Control and Event for the best possible outcome. The course will cover programming tips as well.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Designing the Application

Lecture 1: The Access Development Phases

Lecture 2: Putting the Entire Database on a Server

Lecture 3: Splitting the Database

Lecture 4: Creating a Database Project

Chapter 3: Subforms

Lecture 1: Creating a Subform Automatically

Lecture 2: Creating a Subform Manually

Lecture 3: Linking a Subform

Lecture 4: Referencing Controls in a Subform

Chapter 4: Dialog Boxes

Lecture 1: Understanding Dialog Boxes

Lecture 2: Creating a Dialog Box

Lecture 3: Setting Dialog Box Properties

Lecture 4: Setting Dialog Events

Chapter 5: Controls

Lecture 1: Using the Option Group Control

Lecture 2: Using the Command Button Contro

Lecture 3: Using the Combo Box Control

Lecture 4: Examining the Query and Form

Chapter 6: Passing Form Values to Queries

Lecture 1: Using the Expression Builder

Chapter 7: Simple Macros

Lecture 1: Understanding Macro types

Lecture 2: Creating a Simple Macro

Chapter 8: Macro Groups

Lecture 1: Understanding Macro Groups

Lecture 2: Creating a Macro Group

Chapter 9: Conditional Macros

Lecture 1: Understanding Conditional Macros

Lecture 2: Creating a Conditional Macro

Lecture 3: Using the StopMacro Command

Lecture 4: Fixing Syntax Errors

Lecture 5: Handling a False Condition

Lecture 6: Validating input

Chapter 10: System Wrap-Up

Lecture 1: Importance of Documenting the Database

Lecture 2: Using the Database Documenter

Lecture 3: Setting Autostart Options

Lecture 4: Setting a Password

Chapter 11: Programming Tips

Lecture 1: Data First

Lecture 2: Table Properties

Lecture 3: Form Design

Lecture 4: Follow Windows

Lecture 5: Close Buttons

Lecture 6: Simple is Best

Chapter 12: Conclusion

Instructors

Intellezy Trainers
Multi-Award-Winning eLearning Specialists

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 3 votes
5 stars: 12 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu