Access 2010 Intermediate

Access 2010 Intermediate, available at $44.99, has an average rating of 4.4, with 40 lectures, 1 quizzes, based on 34 reviews, and has 296 subscribers.

You will learn about Understand table relationships Design advanced tables Use action queries with imported data Create and use calculated and parameter queries Use advanced form features Create and use advanced report functions This course is ideal for individuals who are Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features It is particularly useful for Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features.

Enroll now: Access 2010 Intermediate

Summary

Title: Access 2010 Intermediate

Price: $44.99

Average Rating: 4.4

Number of Lectures: 40

Number of Quizzes: 1

Number of Published Lectures: 40

Number of Published Quizzes: 1

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Understand table relationships
Design advanced tables
Use action queries with imported data
Create and use calculated and parameter queries
Use advanced form features
Create and use advanced report functions

Who Should Attend

Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features

Target Audiences

Students who are familiar with creating basic databases looking to better understand table relationships, learn advanced table design, create queries and use advanced form and report features

This course goes into more detail on how to make the database objects more interactive within Microsoft Access 2010. Starting with an explanation of the different table relationships and setting advanced properties within a Table, this course shows you how to effectively use the tools within Microsoft Access to verify data as it gets entered into the database. Additionally, this course shows you how to import an Excel spreadsheet and use the different Action Queries to create a relational database. Finally, the course shows how to create interactive forms and reports by adding calculated controls.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Understanding Table Relationships

Lecture 1: Understanding Table Relationships

Lecture 2: The 1 to 1 Relationship

Lecture 3: The 1 to Many Relationship

Lecture 4: The Many to Many Relationship

Lecture 5: Creating a 1 to 1 Relationship

Lecture 6: Enforcing Referential Integrity

Lecture 7: Creating a 1 to Many Relationship

Lecture 8: Creating a Many to Many Relationship

Chapter 3: Introducing Advanced Table Design

Lecture 1: Reviewing the Field Data Types

Lecture 2: Setting the Format Property

Lecture 3: Using the Input Mask Property

Lecture 4: Setting Default Values and Validation Rules

Lecture 5: Using the Required and Indexed Properties

Lecture 6: Reviewing the Unicode Compression Property

Chapter 4: Using Action Queries with Imported Data

Lecture 1: Importing vs. Linking External Data

Lecture 2: Using the Delete Query

Lecture 3: Using the Update Query

Lecture 4: Using the Make Table Query

Lecture 5: Using the Append Query

Chapter 5: Creating Calculated and Parameter Queries

Lecture 1: Calculating Numbers

Lecture 2: Calculating Totals and Using Group By

Lecture 3: Concatenating Text

Lecture 4: Creating Parameter Queries

Lecture 5: Using Wildcards with Your Parameter Entry

Chapter 6: Using Advanced Form Features

Lecture 1: Reviewing the Invisible Table

Lecture 2: Removing a Single Control from the Table

Lecture 3: Locking and Hiding a Control

Lecture 4: Modifying the Layout

Lecture 5: Adding an Unbound Control

Lecture 6: Adding Calculated Controls

Lecture 7: Adding a Combo Box Control

Lecture 8: Changing a Control Type

Chapter 7: Advanced Report Functions

Lecture 1: Using the Report Wizard

Lecture 2: Reviewing the Report Bands

Lecture 3: Manipulating Controls in a Report

Lecture 4: Adding Parameters to a Report

Lecture 5: Using a Parameter Query with a Report

Lecture 6: Using the Group/Sort Panel

Chapter 8: Conclusion

Lecture 1: Conclusion

Chapter 9: Access 2010 Intermediate Assessment

Instructors

Intellezy Trainers
Multi-Award-Winning eLearning Specialists

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 14 votes
5 stars: 18 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