Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.
|Section 2: Understanding Table Relationships|
Understanding Table RelationshipsPreview
The 1 to 1 RelationshipPreview
The 1 to Many RelationshipPreview
The Many to Many Relationship
Creating a 1 to 1 Relationship
Enforcing Referential Integrity
Creating a 1 to Many Relationship
Creating a Many to Many Relationship
|Section 3: Introducing Advanced Table Design|
Reviewing the Field Data Types
Setting the Format Property
Using the Input Mask Property
Setting Default Values and Validation Rules
Using the Required and Indexed Properties
Reviewing the Unicode Compression Property
|Section 4: Using Action Queries with Imported Data|
Importing vs. Linking External Data
Using the Delete Query
Using the Update Query
Using the Make Table Query
Using the Append Query
|Section 5: Creating Calculated and Parameter Queries|
Calculating Totals and Using Group By
Creating Parameter Queries
Using Wildcards with Your Parameter Entry
|Section 6: Using Advanced Form Features|
Reviewing the Invisible TablePreview
Removing a Single Control from the Table
Locking and Hiding a Control
Modifying the Layout
Adding an Unbound Control
Adding Calculated Controls
Adding a Combo Box Control
Changing a Control Type
|Section 7: Advanced Report Functions|
Using the Report Wizard
Reviewing the Report Bands
Manipulating Controls in a Report
Adding Parameters to a Report
Using a Parameter Query with a Report
Using the Group/Sort Panel
|Section 8: Conclusion|
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.