Microsoft Office Access 2010 Advanced

Name: Microsoft Office Access 2010 Advanced
Rating: 5.0 (4 reviews)

Created byStone River eLearning

Last updated 10/2023

English

What you'll learn

Write SQL statements
Create crosstab queries
Create parameter queries
Use action queries
Create a macro
Import, export and link objects
Optimize database resources
Secure databases

Course content

7 sections • 151 lectures • 3h 18m total length

Course Introduction0:42
Instructor Introduction0:37

Querying with SQL0:17
Topic A: SQL and Access0:06
Sample SQL Statements1:31
A Query in SQL View0:43
Demo A2: Examining a SQL Statement in Access2:28
Topic B: Writing SQL Statements0:26
Writing a SQL Statement0:21
Demo B1: Writing a SQL SELECT Statement2:24
Syntax for WHERE Clause0:37
Demo B2: Using the WHERE Clause0:59
Aliases0:59
Demo B3: Creating Aliases3:10
Syntax to Display Matched Records1:04
Demo B4: Displaying Matching Records from Related Tables2:39
Syntax to Display Unmatched Records1:22
Demo B5: Finding Unmatched Records2:21
Context - Sensitive Help0:28
Demo B6: Getting Context - Sensitive Help on SQL1:09
Topic C: Attaching SQL Queries to Controls0:07
SQL - Specific Queries0:30
Create a Union Query0:58
Attach a SQL Query to a Button0:54
Command Button Wizard0:17
Demo - C1: Assigning a SQL Query to a Command Button3:24
Unit 01 Review0:17
Review - Question

Advanced Queries0:18
Create crosstab queries to summarize and analyze large data sets. Build parameter queries that prompt users for information, and implement action queries that modify data inside the database.
Topic A: Creating Crosstab Queries0:05
A Crosstab Query Result0:46
Demo - A1: Viewing a Crosstab Query0:57
Create a Crosstab Query0:39
The Crosstab Query Wizard0:29
Demo - A2: Using the Crosstab Query Wizard1:51
Topic B: Creating Parameter Querie0:07
Create a Single - Criterion Query1:21
Demo - B1: Creating a Single - Criterion Parameter Query2:31
Create a single-criterion parameter query in Access 2010 by using a parameter prompt to filter unit prices greater than a user-specified value, and run the query with different thresholds.
Create a Multiple-Criteria Query1:08
Demo - B2: Creating a Query with Multiple Parameters2:33
Create a Wildcard Query1:19
Demo B3: Using a Wildcard in a Parameter Query2:25
Topic C: Using Action Queries0:10
Types of Action Queries0:18
Use an Append Query0:43
Demo C1: Adding Records to a Table with an Append Query2:42
Use a Delete Query1:13
Demo C2: Deleting Records with a Delete Query3:31
Use an Update Query1:16
Demo C3: Modifying Records with an Update Query3:31
Use a Make Table Query0:47
Demo C4: Creating a Make Table Query1:59
Unit 02 Review0:20
Review - Question

Macros0:14
Topic A: Creating, Running, and Modifying Macros0:08
Sample Macro2:06
The Macro Tools | Design Tab1:30
Demo A1: Creating and Running a Macro2:33
Demo A2: Modifying a Macro1:42
Modify a macro in access by adding a message box action, prompting ‘click OK to edit records,’ then edit a record and learn how not saving changes affects the action.
Topic B: Attaching Macros to the Events of Database Objects0:07
The Event Tab0:52
Use the event tab in the property sheet to connect events on controls, or the form itself—such as open, close, resize, or key press—to macros.
Demo B1: Attaching a Macro to the Open Event of a Form1:37
Attach Macro to Command Button0:48
Demo B2: Attaching a Macro to a Command Button1:50
Unit 03 Review0:18
Review - Question

Advanced Macros0:30
Topic A: Creating Macros to Provide User Interaction0:12
Sample Macro with a Condition3:21
Create a Data Validation Macro0:51
Demo A1: Creating a Data Validation Macro6:16
Create a Data Entry Macro1:03
Demo A2: Creating a Data Entry Macro7:16
Topic B: Creating Macros that Require User Input0:07
Learn how to create a macro that involves interaction with the user and gathers data from them in Microsoft Access 2010 advanced.
Macro to Run a Parameter Query0:47
Demo B1: Creating a Macro that Runs a Parameter Query3:03
Topic C: Creating AutoKeys and AutoExec Macros0:09
The AutoKeys Macro2:05
Demo C1: Creating an AutoKeys Macro3:10
Create an AutoKeys macro in Access 2010 to assign keyboard shortcuts for opening forms, using sub macros named with the caret symbol to trigger retailer and order item forms.
Create an AutoExec Macro0:46
Demo C2: Creating an AutoExec Macro1:07
Topic D: Creating Macros for Data Transfer0:07
The Import Export Data Action1:47
Demo D1: Importing a Database Object by Using a Macro2:40
Export Data to a Spreadsheet0:38
Demo D2: Exporting Data to a Spreadsheet by Using a Macro2:07
Unit 04 Review0:32
Review - Question

Importing, Exporting, and Linking0:27
Topic A: Importing Objects0:08
Import Objects from a Database1:01
The Import Objects Dialog Box0:33
Demo A1: Importing Multiple Objects1:46
Import Objects from Excel1:15
Demo A2: Importing an Object from Excel3:15
Manage Data Tasks0:50
Demo A3: Using a Saved Import Specification1:21
Fixed Width vs. Delimited Format1:43
Demo A4: Importing a CSV File2:03
Topic B: Exporting Objects0:06
Export Objects from a Database0:57
The Export Table Dialog Box0:45
Demo B1: Exporting an Object3:06
Demo B2: Using a Saved Export Specification1:16
Topic C: Working with XML Documents0:05
Export as XML1:02
The Export XML Dialog Box0:40
The Import XML Dialog Box0:44
Demo C1: Exporting and Importing XML Documents3:56
Export with an XSL File0:37
Demo C2: Exporting to an XML Document with an XSL File2:36
Publish as PDF or XPS1:39
Demo C3: Saving a Table as an XPS File1:50
Topic D: Linking Access Objects0:06
Link a Table1:31
Demo D1: Linking to an Access Table3:40
Update a Link1:14
Maintain access to linked tables by updating their paths when the source database moves. Use the External Data tab, linked table manager, and update.
Linked Table Manager1:22
Demo D2: Updating Links2:24
Link to an Excel Workbook1:02
Demo D3: Linking to an Excel Workbook1:52
Topic E: Using Hyperlink Fields0:05
Create a Hyperlink Field1:21
Demo E1: Creating a Hyperlink Field1:11
The Insert Hyperlink Dialog Box0:56
Demo E2: Inserting Data in a Hyperlink Field0:40
Modify Hyperlink Data0:25
Demo E3: Modifying Data in a Hyperlink Field1:36
Unit 05 Review0:40
Review - Question

Database Management0:20
Topic A: Optimizing Resources0:07
Convert to a Prior Version1:58
Demo A1: Converting a Database to a Prior Version1:15
The Performance Analyzer1:09
Performance Analyzer Results1:15
Run the performance analyzer to view results, apply optimized recommendations automatically when possible or manually implement fixes; rerun analysis to see updates and close the results when done.
Demo A2: Analyzing Performance1:49
Split a Database1:15
Demo A3: Splitting a Database2:23
Compact and Repair a Database1:28
Demo A4: Using the Compact and Repair Database Utility1:43
Back Up the Active Database0:44
back up the active database regularly using the file tab, save and publish, and backup database option; select location and name to restore data if needed.
Demo A5: Backing up a Database0:52
Topic B: Protecting Databases0:07
Encrypt and Password-Protect1:12
Demo B1: Encrypting a Database with a Password2:04
Remove Password and Encryption0:31
Demo B2: Removing a Password and Encryption0:48
Topic C: Setting Options and Properties0:07
The Access Options Dialog Box1:16
Demo C1: Setting Access Options2:18
Database Properties Dialog Box1:03
Demo C2: Creating and Populating Database Properties1:24
Unit 06 Review0:21
Course Closure1:12
Review - Question

Requirements

The course requires the students to have hands-on experience and knowledge of Microsoft Office 2007 or any other older version of Microsoft Office especially Microsoft Office Access.
In addition to that, a good knowledge of getting around with Microsoft Windows 10 is required as well.
The course is part of the three course series on Microsoft Office Access 2010.
It is recommended that the students complete the previous levels before opting for this course.

Description

The Microsoft Office Access 2010: Advanced course builds upon the Microsoft Access skills acquired by the candidates in Access 2010 Basic and Intermediate courses and helps the students become the masters of Microsoft Office Access 2010. In this Microsoft Access course, students will delve deeper into the program by studying more complex topics such as query with SQL, create crosstab, parameter, and action queries, create macros, import, export and link database objects, interact with XML documents, create hyperlink fields, optimize, split and backup databases. The students will also learn to secure the databases by implementing password-protection, encryption and access options.

Microsoft Office is critical to the day to day operations of any organization. This three leveled set of courses is specifically focused on the Microsoft Office Access 2010 that is an essential data management tool used by many organizations. The course is essential to allow smooth transition from the older Microsoft Office Access versions to the latest Microsoft Office Access 2010.

Who this course is for:

Individuals looking to update their skill-set to Microsoft Office Access 2010
Data entry operators
Writers and publishers
Candidates seeking to move to the latest version of Microsoft Office Access

Microsoft Office Access 2010 Advanced

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 1min

Unit 01 ­ Querying with SQL25 lectures • 30min

Unit 02 ­ Advanced Queries25 lectures • 33min

Unit 03 ­ Macros12 lectures • 14min

Unit 04 ­ Advanced Macros21 lectures • 39min

Unit 05 ­ Importing, Exporting, and Linking41 lectures • 54min

Unit 06 ­ Database Management25 lectures • 29min

Requirements

Description

Who this course is for: