Microsoft Office Access 2010 Advanced

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

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
  • Create crosstab queries Create parameter queries Use action queries Create a macro Import, export and link objects Optimize database resources Secure databases 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 Show more Show less Course content 7 sections • 151 lectures • 3h 18m total length Expand all sections Introduction 2 lectures • 1min Course Introduction Preview 00:42 Instructor Introduction Preview 00:37 Unit 01 ­ Querying with SQL 25 lectures • 30min ­ Querying with SQL Preview 00:17 Topic A: SQL and Access Preview 00:06 Sample SQL Statements Preview 01:31 A Query in SQL View Preview 00:43 Demo ­ A2: Examining a SQL Statement in Access Preview 02:28 Topic B: Writing SQL Statements Preview 00:26 Writing a SQL Statement Preview 00:21 Demo ­ B1: Writing a SQL SELECT Statement Preview 02:24 Syntax for WHERE Clause Preview 00:37 Demo ­ B2: Using the WHERE Clause 00:59 Aliases 00:59 Demo ­ B3: Creating Aliases 03:10 Syntax to Display Matched Records 01:04 Demo ­ B4: Displaying Matching Records from Related Tables 02:39 Syntax to Display Unmatched Records 01:22 Demo ­ B5: Finding Unmatched Records 02:21 Context - ­Sensitive Help 00:28 Demo ­ B6: Getting Context ­- Sensitive Help on SQL 01:09 Topic C: Attaching SQL Queries to Controls 00:07 SQL­ - Specific Queries 00:30 Create a Union Query 00:58 Attach a SQL Query to a Button 00:54 Command Button Wizard 00:17 Demo -­ C1: Assigning a SQL Query to a Command Button 03:24 Unit 01 Review 00:17 Unit 02 ­ Advanced Queries 25 lectures • 33min Advanced Queries 00:18 Topic A: Creating Crosstab Queries 00:05 A Crosstab Query Result 00:46 Demo ­- A­1: Viewing a Crosstab Query 00:57 Create a Crosstab Query 00:39 The Crosstab Query Wizard 00:29 Demo ­- A­2: Using the Crosstab Query Wizard 01:51 Topic B: Creating Parameter Querie 00:07 Create a Single - ­Criterion Query 01:21 Demo -­ B1: Creating a Single - ­Criterion Parameter Query 02:31 Create a Multiple-­Criteria Query 01:08 Demo - ­ B2: Creating a Query with Multiple Parameters 02:33 Create a Wildcard Query 01:19 Demo ­ B3: Using a Wildcard in a Parameter Query 02:25 Topic C: Using Action Queries 00:10 Types of Action Queries 00:18 Use an Append Query 00:43 Demo ­ C1: Adding Records to a Table with an Append Query 02:42 Use a Delete Query 01:13 Demo ­ C2: Deleting Records with a Delete Query 03:31 Use an Update Query 01:16 Demo ­ C3: Modifying Records with an Update Query 03:31 Use a Make Table Query 00:47 Demo ­ C4: Creating a Make Table Query 01:59 Unit 02 Review 00:20 Review - Question 5 questions Unit 03 ­ Macros 12 lectures • 14min ­ Macros 00:14 Topic A: Creating, Running, and Modifying Macros 00:08 Sample Macro 02:06 The Macro Tools | Design Tab 01:30 Demo ­ A1: Creating and Running a Macro 02:33 Demo ­ A2: Modifying a Macro 01:42 Topic B: Attaching Macros to the Events of Database Objects 00:07 The Event Tab 00:52 Demo ­ B1: Attaching a Macro to the Open Event of a Form 01:37 Attach Macro to Command Button 00:48 Demo ­ B2: Attaching a Macro to a Command Button 01:50 Unit 03 Review 00:18 Review - Question 5 questions Unit 04 ­ Advanced Macros 21 lectures • 39min Advanced Macros 00:30 Topic A: Creating Macros to Provide User Interaction 00:12 Sample Macro with a Condition 03:21 Create a Data Validation Macro 00:51 Demo ­ A1: Creating a Data Validation Macro 06:16 Create a Data Entry Macro 01:03 Demo ­ A2: Creating a Data Entry Macro 07:16 Topic B: Creating Macros that Require User Input 00:07 Macro to Run a Parameter Query 00:47 Demo ­ B1: Creating a Macro that Runs a Parameter Query 03:03 Topic C: Creating AutoKeys and AutoExec Macros 00:09 The AutoKeys Macro 02:05 Demo ­ C1: Creating an AutoKeys Macro 03:10 Create an AutoExec Macro 00:46 Demo ­ C2: Creating an AutoExec Macro 01:07 Topic D: Creating Macros for Data Transfer 00:07 The Import Export Data Action 01:47 Demo ­ D1: Importing a Database Object by Using a Macro 02:40 Export Data to a Spreadsheet 00:38 Demo ­ D2: Exporting Data to a Spreadsheet by Using a Macro 02:07 Unit 04 Review 00:32 Review - Question 5 questions Unit 05 ­ Importing, Exporting, and Linking 41 lectures • 54min Importing, Exporting, and Linking 00:27 Topic A: Importing Objects 00:08 Import Objects from a Database 01:01 The Import Objects Dialog Box 00:33 Demo ­ A1: Importing Multiple Objects 01:46 Import Objects from Excel 01:15 Demo ­ A2: Importing an Object from Excel 03:15 Manage Data Tasks 00:50 Demo ­ A3: Using a Saved Import Specification 01:21 Fixed Width vs. Delimited Format 01:43 Demo ­ A4: Importing a CSV File 02:03 Topic B: Exporting Objects 00:06 Export Objects from a Database 00:57 The Export Table Dialog Box 00:45 Demo ­ B1: Exporting an Object 03:06 Demo ­ B2: Using a Saved Export Specification 01:16 Topic C: Working with XML Documents 00:05 Export as XML 01:02 The Export XML Dialog Box 00:40 The Import XML Dialog Box 00:44 Demo ­ C1: Exporting and Importing XML Documents 03:56 Export with an XSL File 00:37 Demo ­ C2: Exporting to an XML Document with an XSL File 02:36 Publish as PDF or XPS 01:39 Demo ­ C3: Saving a Table as an XPS File 01:50 Topic D: Linking Access Objects 00:06 Link a Table 01:31 Demo ­ D1: Linking to an Access Table 03:40 Update a Link 01:14 Linked Table Manager 01:22 Demo ­ D2: Updating Links 02:24 Link to an Excel Workbook 01:02 Demo ­ D3: Linking to an Excel Workbook 01:52 Topic E: Using Hyperlink Fields 00:06 Create a Hyperlink Field 01:21 Demo ­ E1: Creating a Hyperlink Field 01:11 The Insert Hyperlink Dialog Box 00:56 Demo ­ E2: Inserting Data in a Hyperlink Field 00:40 Modify Hyperlink Data 00:25 Demo ­ E3: Modifying Data in a Hyperlink Field 01:36 Unit 05 Review 00:40 Review - Question 5 questions Unit 06 ­ Database Management 25 lectures • 29min Database Management 00:20 Topic A: Optimizing Resources 00:07 Convert to a Prior Version 01:58 Demo ­ A1: Converting a Database to a Prior Version 01:15 The Performance Analyzer 01:09 Performance Analyzer Results 01:15 Demo ­ A2: Analyzing Performance 01:49 Split a Database 01:15 Demo ­ A3: Splitting a Database 02:23 Compact and Repair a Database 01:28 Demo ­ A4: Using the Compact and Repair Database Utility 01:43 Back Up the Active Database 00:44 Demo ­ A5: Backing up a Database 00:52 Topic B: Protecting Databases 00:07 Encrypt and Password-­Protect 01:12 Demo ­ B1: Encrypting a Database with a Password 02:04 Remove Password and Encryption 00:31 Demo ­ B2: Removing a Password and Encryption 00:48 Topic C: Setting Options and Properties 00:07 The Access Options Dialog Box 01:16 Demo ­ C1: Setting Access Options 02:18 Database Properties Dialog Box 01:03 Demo ­ C2: Creating and Populating Database Properties 01:24 Unit 06 Review 00:21 Course Closure 01:12 Review - Question 5 questions Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781f0d8d8d0407d',m:'88a2496ba56eb0ae0ad2295e5dcba8e427f5e154-1627851050-1800-AQI6T3ZAT1MwAHV85Ii/DokgJnPg7bXitxxpUX3EyfJ8jKjHet2asbtqGht/s93LN42a+zOiaUG7ykCgIEaQen5sPV37AMVAOPBJZQOI/d4V8f0BfLZ3Rm8KmzZ1s1l1pXh0g+BOTiWYdGDBnqGlRsd5sy7d6XzzWMncEwfnR5S/',s:[0x1a2d5c5e6c,0x8350401cae],}})();
  • Create parameter queries Use action queries Create a macro Import, export and link objects Optimize database resources Secure databases 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 Show more Show less Course content 7 sections • 151 lectures • 3h 18m total length Expand all sections Introduction 2 lectures • 1min Course Introduction Preview 00:42 Instructor Introduction Preview 00:37 Unit 01 ­ Querying with SQL 25 lectures • 30min ­ Querying with SQL Preview 00:17 Topic A: SQL and Access Preview 00:06 Sample SQL Statements Preview 01:31 A Query in SQL View Preview 00:43 Demo ­ A2: Examining a SQL Statement in Access Preview 02:28 Topic B: Writing SQL Statements Preview 00:26 Writing a SQL Statement Preview 00:21 Demo ­ B1: Writing a SQL SELECT Statement Preview 02:24 Syntax for WHERE Clause Preview 00:37 Demo ­ B2: Using the WHERE Clause 00:59 Aliases 00:59 Demo ­ B3: Creating Aliases 03:10 Syntax to Display Matched Records 01:04 Demo ­ B4: Displaying Matching Records from Related Tables 02:39 Syntax to Display Unmatched Records 01:22 Demo ­ B5: Finding Unmatched Records 02:21 Context - ­Sensitive Help 00:28 Demo ­ B6: Getting Context ­- Sensitive Help on SQL 01:09 Topic C: Attaching SQL Queries to Controls 00:07 SQL­ - Specific Queries 00:30 Create a Union Query 00:58 Attach a SQL Query to a Button 00:54 Command Button Wizard 00:17 Demo -­ C1: Assigning a SQL Query to a Command Button 03:24 Unit 01 Review 00:17 Unit 02 ­ Advanced Queries 25 lectures • 33min Advanced Queries 00:18 Topic A: Creating Crosstab Queries 00:05 A Crosstab Query Result 00:46 Demo ­- A­1: Viewing a Crosstab Query 00:57 Create a Crosstab Query 00:39 The Crosstab Query Wizard 00:29 Demo ­- A­2: Using the Crosstab Query Wizard 01:51 Topic B: Creating Parameter Querie 00:07 Create a Single - ­Criterion Query 01:21 Demo -­ B1: Creating a Single - ­Criterion Parameter Query 02:31 Create a Multiple-­Criteria Query 01:08 Demo - ­ B2: Creating a Query with Multiple Parameters 02:33 Create a Wildcard Query 01:19 Demo ­ B3: Using a Wildcard in a Parameter Query 02:25 Topic C: Using Action Queries 00:10 Types of Action Queries 00:18 Use an Append Query 00:43 Demo ­ C1: Adding Records to a Table with an Append Query 02:42 Use a Delete Query 01:13 Demo ­ C2: Deleting Records with a Delete Query 03:31 Use an Update Query 01:16 Demo ­ C3: Modifying Records with an Update Query 03:31 Use a Make Table Query 00:47 Demo ­ C4: Creating a Make Table Query 01:59 Unit 02 Review 00:20 Review - Question 5 questions Unit 03 ­ Macros 12 lectures • 14min ­ Macros 00:14 Topic A: Creating, Running, and Modifying Macros 00:08 Sample Macro 02:06 The Macro Tools | Design Tab 01:30 Demo ­ A1: Creating and Running a Macro 02:33 Demo ­ A2: Modifying a Macro 01:42 Topic B: Attaching Macros to the Events of Database Objects 00:07 The Event Tab 00:52 Demo ­ B1: Attaching a Macro to the Open Event of a Form 01:37 Attach Macro to Command Button 00:48 Demo ­ B2: Attaching a Macro to a Command Button 01:50 Unit 03 Review 00:18 Review - Question 5 questions Unit 04 ­ Advanced Macros 21 lectures • 39min Advanced Macros 00:30 Topic A: Creating Macros to Provide User Interaction 00:12 Sample Macro with a Condition 03:21 Create a Data Validation Macro 00:51 Demo ­ A1: Creating a Data Validation Macro 06:16 Create a Data Entry Macro 01:03 Demo ­ A2: Creating a Data Entry Macro 07:16 Topic B: Creating Macros that Require User Input 00:07 Macro to Run a Parameter Query 00:47 Demo ­ B1: Creating a Macro that Runs a Parameter Query 03:03 Topic C: Creating AutoKeys and AutoExec Macros 00:09 The AutoKeys Macro 02:05 Demo ­ C1: Creating an AutoKeys Macro 03:10 Create an AutoExec Macro 00:46 Demo ­ C2: Creating an AutoExec Macro 01:07 Topic D: Creating Macros for Data Transfer 00:07 The Import Export Data Action 01:47 Demo ­ D1: Importing a Database Object by Using a Macro 02:40 Export Data to a Spreadsheet 00:38 Demo ­ D2: Exporting Data to a Spreadsheet by Using a Macro 02:07 Unit 04 Review 00:32 Review - Question 5 questions Unit 05 ­ Importing, Exporting, and Linking 41 lectures • 54min Importing, Exporting, and Linking 00:27 Topic A: Importing Objects 00:08 Import Objects from a Database 01:01 The Import Objects Dialog Box 00:33 Demo ­ A1: Importing Multiple Objects 01:46 Import Objects from Excel 01:15 Demo ­ A2: Importing an Object from Excel 03:15 Manage Data Tasks 00:50 Demo ­ A3: Using a Saved Import Specification 01:21 Fixed Width vs. Delimited Format 01:43 Demo ­ A4: Importing a CSV File 02:03 Topic B: Exporting Objects 00:06 Export Objects from a Database 00:57 The Export Table Dialog Box 00:45 Demo ­ B1: Exporting an Object 03:06 Demo ­ B2: Using a Saved Export Specification 01:16 Topic C: Working with XML Documents 00:05 Export as XML 01:02 The Export XML Dialog Box 00:40 The Import XML Dialog Box 00:44 Demo ­ C1: Exporting and Importing XML Documents 03:56 Export with an XSL File 00:37 Demo ­ C2: Exporting to an XML Document with an XSL File 02:36 Publish as PDF or XPS 01:39 Demo ­ C3: Saving a Table as an XPS File 01:50 Topic D: Linking Access Objects 00:06 Link a Table 01:31 Demo ­ D1: Linking to an Access Table 03:40 Update a Link 01:14 Linked Table Manager 01:22 Demo ­ D2: Updating Links 02:24 Link to an Excel Workbook 01:02 Demo ­ D3: Linking to an Excel Workbook 01:52 Topic E: Using Hyperlink Fields 00:06 Create a Hyperlink Field 01:21 Demo ­ E1: Creating a Hyperlink Field 01:11 The Insert Hyperlink Dialog Box 00:56 Demo ­ E2: Inserting Data in a Hyperlink Field 00:40 Modify Hyperlink Data 00:25 Demo ­ E3: Modifying Data in a Hyperlink Field 01:36 Unit 05 Review 00:40 Review - Question 5 questions Unit 06 ­ Database Management 25 lectures • 29min Database Management 00:20 Topic A: Optimizing Resources 00:07 Convert to a Prior Version 01:58 Demo ­ A1: Converting a Database to a Prior Version 01:15 The Performance Analyzer 01:09 Performance Analyzer Results 01:15 Demo ­ A2: Analyzing Performance 01:49 Split a Database 01:15 Demo ­ A3: Splitting a Database 02:23 Compact and Repair a Database 01:28 Demo ­ A4: Using the Compact and Repair Database Utility 01:43 Back Up the Active Database 00:44 Demo ­ A5: Backing up a Database 00:52 Topic B: Protecting Databases 00:07 Encrypt and Password-­Protect 01:12 Demo ­ B1: Encrypting a Database with a Password 02:04 Remove Password and Encryption 00:31 Demo ­ B2: Removing a Password and Encryption 00:48 Topic C: Setting Options and Properties 00:07 The Access Options Dialog Box 01:16 Demo ­ C1: Setting Access Options 02:18 Database Properties Dialog Box 01:03 Demo ­ C2: Creating and Populating Database Properties 01:24 Unit 06 Review 00:21 Course Closure 01:12 Review - Question 5 questions Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781f0d8d8d0407d',m:'88a2496ba56eb0ae0ad2295e5dcba8e427f5e154-1627851050-1800-AQI6T3ZAT1MwAHV85Ii/DokgJnPg7bXitxxpUX3EyfJ8jKjHet2asbtqGht/s93LN42a+zOiaUG7ykCgIEaQen5sPV37AMVAOPBJZQOI/d4V8f0BfLZ3Rm8KmzZ1s1l1pXh0g+BOTiWYdGDBnqGlRsd5sy7d6XzzWMncEwfnR5S/',s:[0x1a2d5c5e6c,0x8350401cae],}})();
  • Use action queries Create a macro Import, export and link objects Optimize database resources Secure databases 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 Show more Show less Course content 7 sections • 151 lectures • 3h 18m total length Expand all sections Introduction 2 lectures • 1min Course Introduction Preview 00:42 Instructor Introduction Preview 00:37 Unit 01 ­ Querying with SQL 25 lectures • 30min ­ Querying with SQL Preview 00:17 Topic A: SQL and Access Preview 00:06 Sample SQL Statements Preview 01:31 A Query in SQL View Preview 00:43 Demo ­ A2: Examining a SQL Statement in Access Preview 02:28 Topic B: Writing SQL Statements Preview 00:26 Writing a SQL Statement Preview 00:21 Demo ­ B1: Writing a SQL SELECT Statement Preview 02:24 Syntax for WHERE Clause Preview 00:37 Demo ­ B2: Using the WHERE Clause 00:59 Aliases 00:59 Demo ­ B3: Creating Aliases 03:10 Syntax to Display Matched Records 01:04 Demo ­ B4: Displaying Matching Records from Related Tables 02:39 Syntax to Display Unmatched Records 01:22 Demo ­ B5: Finding Unmatched Records 02:21 Context - ­Sensitive Help 00:28 Demo ­ B6: Getting Context ­- Sensitive Help on SQL 01:09 Topic C: Attaching SQL Queries to Controls 00:07 SQL­ - Specific Queries 00:30 Create a Union Query 00:58 Attach a SQL Query to a Button 00:54 Command Button Wizard 00:17 Demo -­ C1: Assigning a SQL Query to a Command Button 03:24 Unit 01 Review 00:17 Unit 02 ­ Advanced Queries 25 lectures • 33min Advanced Queries 00:18 Topic A: Creating Crosstab Queries 00:05 A Crosstab Query Result 00:46 Demo ­- A­1: Viewing a Crosstab Query 00:57 Create a Crosstab Query 00:39 The Crosstab Query Wizard 00:29 Demo ­- A­2: Using the Crosstab Query Wizard 01:51 Topic B: Creating Parameter Querie 00:07 Create a Single - ­Criterion Query 01:21 Demo -­ B1: Creating a Single - ­Criterion Parameter Query 02:31 Create a Multiple-­Criteria Query 01:08 Demo - ­ B2: Creating a Query with Multiple Parameters 02:33 Create a Wildcard Query 01:19 Demo ­ B3: Using a Wildcard in a Parameter Query 02:25 Topic C: Using Action Queries 00:10 Types of Action Queries 00:18 Use an Append Query 00:43 Demo ­ C1: Adding Records to a Table with an Append Query 02:42 Use a Delete Query 01:13 Demo ­ C2: Deleting Records with a Delete Query 03:31 Use an Update Query 01:16 Demo ­ C3: Modifying Records with an Update Query 03:31 Use a Make Table Query 00:47 Demo ­ C4: Creating a Make Table Query 01:59 Unit 02 Review 00:20 Review - Question 5 questions Unit 03 ­ Macros 12 lectures • 14min ­ Macros 00:14 Topic A: Creating, Running, and Modifying Macros 00:08 Sample Macro 02:06 The Macro Tools | Design Tab 01:30 Demo ­ A1: Creating and Running a Macro 02:33 Demo ­ A2: Modifying a Macro 01:42 Topic B: Attaching Macros to the Events of Database Objects 00:07 The Event Tab 00:52 Demo ­ B1: Attaching a Macro to the Open Event of a Form 01:37 Attach Macro to Command Button 00:48 Demo ­ B2: Attaching a Macro to a Command Button 01:50 Unit 03 Review 00:18 Review - Question 5 questions Unit 04 ­ Advanced Macros 21 lectures • 39min Advanced Macros 00:30 Topic A: Creating Macros to Provide User Interaction 00:12 Sample Macro with a Condition 03:21 Create a Data Validation Macro 00:51 Demo ­ A1: Creating a Data Validation Macro 06:16 Create a Data Entry Macro 01:03 Demo ­ A2: Creating a Data Entry Macro 07:16 Topic B: Creating Macros that Require User Input 00:07 Macro to Run a Parameter Query 00:47 Demo ­ B1: Creating a Macro that Runs a Parameter Query 03:03 Topic C: Creating AutoKeys and AutoExec Macros 00:09 The AutoKeys Macro 02:05 Demo ­ C1: Creating an AutoKeys Macro 03:10 Create an AutoExec Macro 00:46 Demo ­ C2: Creating an AutoExec Macro 01:07 Topic D: Creating Macros for Data Transfer 00:07 The Import Export Data Action 01:47 Demo ­ D1: Importing a Database Object by Using a Macro 02:40 Export Data to a Spreadsheet 00:38 Demo ­ D2: Exporting Data to a Spreadsheet by Using a Macro 02:07 Unit 04 Review 00:32 Review - Question 5 questions Unit 05 ­ Importing, Exporting, and Linking 41 lectures • 54min Importing, Exporting, and Linking 00:27 Topic A: Importing Objects 00:08 Import Objects from a Database 01:01 The Import Objects Dialog Box 00:33 Demo ­ A1: Importing Multiple Objects 01:46 Import Objects from Excel 01:15 Demo ­ A2: Importing an Object from Excel 03:15 Manage Data Tasks 00:50 Demo ­ A3: Using a Saved Import Specification 01:21 Fixed Width vs. Delimited Format 01:43 Demo ­ A4: Importing a CSV File 02:03 Topic B: Exporting Objects 00:06 Export Objects from a Database 00:57 The Export Table Dialog Box 00:45 Demo ­ B1: Exporting an Object 03:06 Demo ­ B2: Using a Saved Export Specification 01:16 Topic C: Working with XML Documents 00:05 Export as XML 01:02 The Export XML Dialog Box 00:40 The Import XML Dialog Box 00:44 Demo ­ C1: Exporting and Importing XML Documents 03:56 Export with an XSL File 00:37 Demo ­ C2: Exporting to an XML Document with an XSL File 02:36 Publish as PDF or XPS 01:39 Demo ­ C3: Saving a Table as an XPS File 01:50 Topic D: Linking Access Objects 00:06 Link a Table 01:31 Demo ­ D1: Linking to an Access Table 03:40 Update a Link 01:14 Linked Table Manager 01:22 Demo ­ D2: Updating Links 02:24 Link to an Excel Workbook 01:02 Demo ­ D3: Linking to an Excel Workbook 01:52 Topic E: Using Hyperlink Fields 00:06 Create a Hyperlink Field 01:21 Demo ­ E1: Creating a Hyperlink Field 01:11 The Insert Hyperlink Dialog Box 00:56 Demo ­ E2: Inserting Data in a Hyperlink Field 00:40 Modify Hyperlink Data 00:25 Demo ­ E3: Modifying Data in a Hyperlink Field 01:36 Unit 05 Review 00:40 Review - Question 5 questions Unit 06 ­ Database Management 25 lectures • 29min Database Management 00:20 Topic A: Optimizing Resources 00:07 Convert to a Prior Version 01:58 Demo ­ A1: Converting a Database to a Prior Version 01:15 The Performance Analyzer 01:09 Performance Analyzer Results 01:15 Demo ­ A2: Analyzing Performance 01:49 Split a Database 01:15 Demo ­ A3: Splitting a Database 02:23 Compact and Repair a Database 01:28 Demo ­ A4: Using the Compact and Repair Database Utility 01:43 Back Up the Active Database 00:44 Demo ­ A5: Backing up a Database 00:52 Topic B: Protecting Databases 00:07 Encrypt and Password-­Protect 01:12 Demo ­ B1: Encrypting a Database with a Password 02:04 Remove Password and Encryption 00:31 Demo ­ B2: Removing a Password and Encryption 00:48 Topic C: Setting Options and Properties 00:07 The Access Options Dialog Box 01:16 Demo ­ C1: Setting Access Options 02:18 Database Properties Dialog Box 01:03 Demo ­ C2: Creating and Populating Database Properties 01:24 Unit 06 Review 00:21 Course Closure 01:12 Review - Question 5 questions Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781f0d8d8d0407d',m:'88a2496ba56eb0ae0ad2295e5dcba8e427f5e154-1627851050-1800-AQI6T3ZAT1MwAHV85Ii/DokgJnPg7bXitxxpUX3EyfJ8jKjHet2asbtqGht/s93LN42a+zOiaUG7ykCgIEaQen5sPV37AMVAOPBJZQOI/d4V8f0BfLZ3Rm8KmzZ1s1l1pXh0g+BOTiWYdGDBnqGlRsd5sy7d6XzzWMncEwfnR5S/',s:[0x1a2d5c5e6c,0x8350401cae],}})();
  • Create a macro Import, export and link objects Optimize database resources Secure databases 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 Show more Show less Course content 7 sections • 151 lectures • 3h 18m total length Expand all sections Introduction 2 lectures • 1min Course Introduction Preview 00:42 Instructor Introduction Preview 00:37 Unit 01 ­ Querying with SQL 25 lectures • 30min ­ Querying with SQL Preview 00:17 Topic A: SQL and Access Preview 00:06 Sample SQL Statements Preview 01:31 A Query in SQL View Preview 00:43 Demo ­ A2: Examining a SQL Statement in Access Preview 02:28 Topic B: Writing SQL Statements Preview 00:26 Writing a SQL Statement Preview 00:21 Demo ­ B1: Writing a SQL SELECT Statement Preview 02:24 Syntax for WHERE Clause Preview 00:37 Demo ­ B2: Using the WHERE Clause 00:59 Aliases 00:59 Demo ­ B3: Creating Aliases 03:10 Syntax to Display Matched Records 01:04 Demo ­ B4: Displaying Matching Records from Related Tables 02:39 Syntax to Display Unmatched Records 01:22 Demo ­ B5: Finding Unmatched Records 02:21 Context - ­Sensitive Help 00:28 Demo ­ B6: Getting Context ­- Sensitive Help on SQL 01:09 Topic C: Attaching SQL Queries to Controls 00:07 SQL­ - Specific Queries 00:30 Create a Union Query 00:58 Attach a SQL Query to a Button 00:54 Command Button Wizard 00:17 Demo -­ C1: Assigning a SQL Query to a Command Button 03:24 Unit 01 Review 00:17 Unit 02 ­ Advanced Queries 25 lectures • 33min Advanced Queries 00:18 Topic A: Creating Crosstab Queries 00:05 A Crosstab Query Result 00:46 Demo ­- A­1: Viewing a Crosstab Query 00:57 Create a Crosstab Query 00:39 The Crosstab Query Wizard 00:29 Demo ­- A­2: Using the Crosstab Query Wizard 01:51 Topic B: Creating Parameter Querie 00:07 Create a Single - ­Criterion Query 01:21 Demo -­ B1: Creating a Single - ­Criterion Parameter Query 02:31 Create a Multiple-­Criteria Query 01:08 Demo - ­ B2: Creating a Query with Multiple Parameters 02:33 Create a Wildcard Query 01:19 Demo ­ B3: Using a Wildcard in a Parameter Query 02:25 Topic C: Using Action Queries 00:10 Types of Action Queries 00:18 Use an Append Query 00:43 Demo ­ C1: Adding Records to a Table with an Append Query 02:42 Use a Delete Query 01:13 Demo ­ C2: Deleting Records with a Delete Query 03:31 Use an Update Query 01:16 Demo ­ C3: Modifying Records with an Update Query 03:31 Use a Make Table Query 00:47 Demo ­ C4: Creating a Make Table Query 01:59 Unit 02 Review 00:20 Review - Question 5 questions Unit 03 ­ Macros 12 lectures • 14min ­ Macros 00:14 Topic A: Creating, Running, and Modifying Macros 00:08 Sample Macro 02:06 The Macro Tools | Design Tab 01:30 Demo ­ A1: Creating and Running a Macro 02:33 Demo ­ A2: Modifying a Macro 01:42 Topic B: Attaching Macros to the Events of Database Objects 00:07 The Event Tab 00:52 Demo ­ B1: Attaching a Macro to the Open Event of a Form 01:37 Attach Macro to Command Button 00:48 Demo ­ B2: Attaching a Macro to a Command Button 01:50 Unit 03 Review 00:18 Review - Question 5 questions Unit 04 ­ Advanced Macros 21 lectures • 39min Advanced Macros 00:30 Topic A: Creating Macros to Provide User Interaction 00:12 Sample Macro with a Condition 03:21 Create a Data Validation Macro 00:51 Demo ­ A1: Creating a Data Validation Macro 06:16 Create a Data Entry Macro 01:03 Demo ­ A2: Creating a Data Entry Macro 07:16 Topic B: Creating Macros that Require User Input 00:07 Macro to Run a Parameter Query 00:47 Demo ­ B1: Creating a Macro that Runs a Parameter Query 03:03 Topic C: Creating AutoKeys and AutoExec Macros 00:09 The AutoKeys Macro 02:05 Demo ­ C1: Creating an AutoKeys Macro 03:10 Create an AutoExec Macro 00:46 Demo ­ C2: Creating an AutoExec Macro 01:07 Topic D: Creating Macros for Data Transfer 00:07 The Import Export Data Action 01:47 Demo ­ D1: Importing a Database Object by Using a Macro 02:40 Export Data to a Spreadsheet 00:38 Demo ­ D2: Exporting Data to a Spreadsheet by Using a Macro 02:07 Unit 04 Review 00:32 Review - Question 5 questions Unit 05 ­ Importing, Exporting, and Linking 41 lectures • 54min Importing, Exporting, and Linking 00:27 Topic A: Importing Objects 00:08 Import Objects from a Database 01:01 The Import Objects Dialog Box 00:33 Demo ­ A1: Importing Multiple Objects 01:46 Import Objects from Excel 01:15 Demo ­ A2: Importing an Object from Excel 03:15 Manage Data Tasks 00:50 Demo ­ A3: Using a Saved Import Specification 01:21 Fixed Width vs. Delimited Format 01:43 Demo ­ A4: Importing a CSV File 02:03 Topic B: Exporting Objects 00:06 Export Objects from a Database 00:57 The Export Table Dialog Box 00:45 Demo ­ B1: Exporting an Object 03:06 Demo ­ B2: Using a Saved Export Specification 01:16 Topic C: Working with XML Documents 00:05 Export as XML 01:02 The Export XML Dialog Box 00:40 The Import XML Dialog Box 00:44 Demo ­ C1: Exporting and Importing XML Documents 03:56 Export with an XSL File 00:37 Demo ­ C2: Exporting to an XML Document with an XSL File 02:36 Publish as PDF or XPS 01:39 Demo ­ C3: Saving a Table as an XPS File 01:50 Topic D: Linking Access Objects 00:06 Link a Table 01:31 Demo ­ D1: Linking to an Access Table 03:40 Update a Link 01:14 Linked Table Manager 01:22 Demo ­ D2: Updating Links 02:24 Link to an Excel Workbook 01:02 Demo ­ D3: Linking to an Excel Workbook 01:52 Topic E: Using Hyperlink Fields 00:06 Create a Hyperlink Field 01:21 Demo ­ E1: Creating a Hyperlink Field 01:11 The Insert Hyperlink Dialog Box 00:56 Demo ­ E2: Inserting Data in a Hyperlink Field 00:40 Modify Hyperlink Data 00:25 Demo ­ E3: Modifying Data in a Hyperlink Field 01:36 Unit 05 Review 00:40 Review - Question 5 questions Unit 06 ­ Database Management 25 lectures • 29min Database Management 00:20 Topic A: Optimizing Resources 00:07 Convert to a Prior Version 01:58 Demo ­ A1: Converting a Database to a Prior Version 01:15 The Performance Analyzer 01:09 Performance Analyzer Results 01:15 Demo ­ A2: Analyzing Performance 01:49 Split a Database 01:15 Demo ­ A3: Splitting a Database 02:23 Compact and Repair a Database 01:28 Demo ­ A4: Using the Compact and Repair Database Utility 01:43 Back Up the Active Database 00:44 Demo ­ A5: Backing up a Database 00:52 Topic B: Protecting Databases 00:07 Encrypt and Password-­Protect 01:12 Demo ­ B1: Encrypting a Database with a Password 02:04 Remove Password and Encryption 00:31 Demo ­ B2: Removing a Password and Encryption 00:48 Topic C: Setting Options and Properties 00:07 The Access Options Dialog Box 01:16 Demo ­ C1: Setting Access Options 02:18 Database Properties Dialog Box 01:03 Demo ­ C2: Creating and Populating Database Properties 01:24 Unit 06 Review 00:21 Course Closure 01:12 Review - Question 5 questions Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781f0d8d8d0407d',m:'88a2496ba56eb0ae0ad2295e5dcba8e427f5e154-1627851050-1800-AQI6T3ZAT1MwAHV85Ii/DokgJnPg7bXitxxpUX3EyfJ8jKjHet2asbtqGht/s93LN42a+zOiaUG7ykCgIEaQen5sPV37AMVAOPBJZQOI/d4V8f0BfLZ3Rm8KmzZ1s1l1pXh0g+BOTiWYdGDBnqGlRsd5sy7d6XzzWMncEwfnR5S/',s:[0x1a2d5c5e6c,0x8350401cae],}})();
  • Import, export and link objects Optimize database resources Secure databases 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 Show more Show less Course content 7 sections • 151 lectures • 3h 18m total length Expand all sections Introduction 2 lectures • 1min Course Introduction Preview 00:42 Instructor Introduction Preview 00:37 Unit 01 ­ Querying with SQL 25 lectures • 30min ­ Querying with SQL Preview 00:17 Topic A: SQL and Access Preview 00:06 Sample SQL Statements Preview 01:31 A Query in SQL View Preview 00:43 Demo ­ A2: Examining a SQL Statement in Access Preview 02:28 Topic B: Writing SQL Statements Preview 00:26 Writing a SQL Statement Preview 00:21 Demo ­ B1: Writing a SQL SELECT Statement Preview 02:24 Syntax for WHERE Clause Preview 00:37 Demo ­ B2: Using the WHERE Clause 00:59 Aliases 00:59 Demo ­ B3: Creating Aliases 03:10 Syntax to Display Matched Records 01:04 Demo ­ B4: Displaying Matching Records from Related Tables 02:39 Syntax to Display Unmatched Records 01:22 Demo ­ B5: Finding Unmatched Records 02:21 Context - ­Sensitive Help 00:28 Demo ­ B6: Getting Context ­- Sensitive Help on SQL 01:09 Topic C: Attaching SQL Queries to Controls 00:07 SQL­ - Specific Queries 00:30 Create a Union Query 00:58 Attach a SQL Query to a Button 00:54 Command Button Wizard 00:17 Demo -­ C1: Assigning a SQL Query to a Command Button 03:24 Unit 01 Review 00:17 Unit 02 ­ Advanced Queries 25 lectures • 33min Advanced Queries 00:18 Topic A: Creating Crosstab Queries 00:05 A Crosstab Query Result 00:46 Demo ­- A­1: Viewing a Crosstab Query 00:57 Create a Crosstab Query 00:39 The Crosstab Query Wizard 00:29 Demo ­- A­2: Using the Crosstab Query Wizard 01:51 Topic B: Creating Parameter Querie 00:07 Create a Single - ­Criterion Query 01:21 Demo -­ B1: Creating a Single - ­Criterion Parameter Query 02:31 Create a Multiple-­Criteria Query 01:08 Demo - ­ B2: Creating a Query with Multiple Parameters 02:33 Create a Wildcard Query 01:19 Demo ­ B3: Using a Wildcard in a Parameter Query 02:25 Topic C: Using Action Queries 00:10 Types of Action Queries 00:18 Use an Append Query 00:43 Demo ­ C1: Adding Records to a Table with an Append Query 02:42 Use a Delete Query 01:13 Demo ­ C2: Deleting Records with a Delete Query 03:31 Use an Update Query 01:16 Demo ­ C3: Modifying Records with an Update Query 03:31 Use a Make Table Query 00:47 Demo ­ C4: Creating a Make Table Query 01:59 Unit 02 Review 00:20 Review - Question 5 questions Unit 03 ­ Macros 12 lectures • 14min ­ Macros 00:14 Topic A: Creating, Running, and Modifying Macros 00:08 Sample Macro 02:06 The Macro Tools | Design Tab 01:30 Demo ­ A1: Creating and Running a Macro 02:33 Demo ­ A2: Modifying a Macro 01:42 Topic B: Attaching Macros to the Events of Database Objects 00:07 The Event Tab 00:52 Demo ­ B1: Attaching a Macro to the Open Event of a Form 01:37 Attach Macro to Command Button 00:48 Demo ­ B2: Attaching a Macro to a Command Button 01:50 Unit 03 Review 00:18 Review - Question 5 questions Unit 04 ­ Advanced Macros 21 lectures • 39min Advanced Macros 00:30 Topic A: Creating Macros to Provide User Interaction 00:12 Sample Macro with a Condition 03:21 Create a Data Validation Macro 00:51 Demo ­ A1: Creating a Data Validation Macro 06:16 Create a Data Entry Macro 01:03 Demo ­ A2: Creating a Data Entry Macro 07:16 Topic B: Creating Macros that Require User Input 00:07 Macro to Run a Parameter Query 00:47 Demo ­ B1: Creating a Macro that Runs a Parameter Query 03:03 Topic C: Creating AutoKeys and AutoExec Macros 00:09 The AutoKeys Macro 02:05 Demo ­ C1: Creating an AutoKeys Macro 03:10 Create an AutoExec Macro 00:46 Demo ­ C2: Creating an AutoExec Macro 01:07 Topic D: Creating Macros for Data Transfer 00:07 The Import Export Data Action 01:47 Demo ­ D1: Importing a Database Object by Using a Macro 02:40 Export Data to a Spreadsheet 00:38 Demo ­ D2: Exporting Data to a Spreadsheet by Using a Macro 02:07 Unit 04 Review 00:32 Review - Question 5 questions Unit 05 ­ Importing, Exporting, and Linking 41 lectures • 54min Importing, Exporting, and Linking 00:27 Topic A: Importing Objects 00:08 Import Objects from a Database 01:01 The Import Objects Dialog Box 00:33 Demo ­ A1: Importing Multiple Objects 01:46 Import Objects from Excel 01:15 Demo ­ A2: Importing an Object from Excel 03:15 Manage Data Tasks 00:50 Demo ­ A3: Using a Saved Import Specification 01:21 Fixed Width vs. Delimited Format 01:43 Demo ­ A4: Importing a CSV File 02:03 Topic B: Exporting Objects 00:06 Export Objects from a Database 00:57 The Export Table Dialog Box 00:45 Demo ­ B1: Exporting an Object 03:06 Demo ­ B2: Using a Saved Export Specification 01:16 Topic C: Working with XML Documents 00:05 Export as XML 01:02 The Export XML Dialog Box 00:40 The Import XML Dialog Box 00:44 Demo ­ C1: Exporting and Importing XML Documents 03:56 Export with an XSL File 00:37 Demo ­ C2: Exporting to an XML Document with an XSL File 02:36 Publish as PDF or XPS 01:39 Demo ­ C3: Saving a Table as an XPS File 01:50 Topic D: Linking Access Objects 00:06 Link a Table 01:31 Demo ­ D1: Linking to an Access Table 03:40 Update a Link 01:14 Linked Table Manager 01:22 Demo ­ D2: Updating Links 02:24 Link to an Excel Workbook 01:02 Demo ­ D3: Linking to an Excel Workbook 01:52 Topic E: Using Hyperlink Fields 00:06 Create a Hyperlink Field 01:21 Demo ­ E1: Creating a Hyperlink Field 01:11 The Insert Hyperlink Dialog Box 00:56 Demo ­ E2: Inserting Data in a Hyperlink Field 00:40 Modify Hyperlink Data 00:25 Demo ­ E3: Modifying Data in a Hyperlink Field 01:36 Unit 05 Review 00:40 Review - Question 5 questions Unit 06 ­ Database Management 25 lectures • 29min Database Management 00:20 Topic A: Optimizing Resources 00:07 Convert to a Prior Version 01:58 Demo ­ A1: Converting a Database to a Prior Version 01:15 The Performance Analyzer 01:09 Performance Analyzer Results 01:15 Demo ­ A2: Analyzing Performance 01:49 Split a Database 01:15 Demo ­ A3: Splitting a Database 02:23 Compact and Repair a Database 01:28 Demo ­ A4: Using the Compact and Repair Database Utility 01:43 Back Up the Active Database 00:44 Demo ­ A5: Backing up a Database 00:52 Topic B: Protecting Databases 00:07 Encrypt and Password-­Protect 01:12 Demo ­ B1: Encrypting a Database with a Password 02:04 Remove Password and Encryption 00:31 Demo ­ B2: Removing a Password and Encryption 00:48 Topic C: Setting Options and Properties 00:07 The Access Options Dialog Box 01:16 Demo ­ C1: Setting Access Options 02:18 Database Properties Dialog Box 01:03 Demo ­ C2: Creating and Populating Database Properties 01:24 Unit 06 Review 00:21 Course Closure 01:12 Review - Question 5 questions Instructor Integrity Training Certification Trainers for Over 20 Years 4.2 Instructor Rating 10,621 Reviews 88,491 Students 155 Courses Hi, we're new to Udemy but we've been producing and selling high quality online training for over 20 years. Over a million students have taken our training through our corporate, government and education partners. Our content was developed for institutions that require the absolute highest standards in teaching quality. We're now bringing our content to consumers like you. Don't settle for anything less than the best quality content available. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781f0d8d8d0407d',m:'88a2496ba56eb0ae0ad2295e5dcba8e427f5e154-1627851050-1800-AQI6T3ZAT1MwAHV85Ii/DokgJnPg7bXitxxpUX3EyfJ8jKjHet2asbtqGht/s93LN42a+zOiaUG7ykCgIEaQen5sPV37AMVAOPBJZQOI/d4V8f0BfLZ3Rm8KmzZ1s1l1pXh0g+BOTiWYdGDBnqGlRsd5sy7d6XzzWMncEwfnR5S/',s:[0x1a2d5c5e6c,0x8350401cae],}})();
  • Optimize database resources Secure databases 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 t