| | 01_01-Welcome.mp4 | 6.98 MB |
| | 01_02-Using the exercise files.mp4 | 1.41 MB |
| | 01_03-Challenges explained.mp4 | 926.69 KB |
| | 02_06-Using the Navigation pane.mp4 | 11.12 MB |
| | 02_05-Digging into Ribbon tabs.mp4 | 10.93 MB |
| | 02_01-Key database concepts.mp4 | 10.3 MB |
| | 02_04-Understanding the Trust Center.mp4 | 8.08 MB |
| | 02_08-Using the Quick Access Toolbar.mp4 | 8.02 MB |
| | 02_03-Creating the database file.mp4 | 7.59 MB |
| | 02_11-Accessing Access help.mp4 | 6.44 MB |
| | 02_10-Making backups.mp4 | 5.19 MB |
| | 02_07-Using the Tell Me feature.mp4 | 4.33 MB |
| | 02_09-Signing in to a Microsoft account.mp4 | 3.91 MB |
| | 02_02-Launching Access and the Backstage screen.mp4 | 1.59 MB |
| | 03_05-Importing tables.mp4 | 14.74 MB |
| | 03_04-Understanding primary and foreign keys.mp4 | 12.72 MB |
| | 03_02-Creating a table and setting data types.mp4 | 12.08 MB |
| | 03_03-Entering data.mp4 | 10.69 MB |
| | 03_01-Understanding table structure and relationships.mp4 | 9.69 MB |
| | 04_03-Controlling input with masks.mp4 | 16.2 MB |
| | 04_01-Establishing relationships and maintaining referential integrity.mp4 | 15.14 MB |
| | 04_07-Setting additional field properties.mp4 | 12.23 MB |
| | 04_09-Solution Creating tables.mp4 | 12.17 MB |
| | 04_02-Editing table structure in Design view.mp4 | 11.19 MB |
| | 04_06-Creating lookup fields.mp4 | 9.88 MB |
| | 04_05-Establishing validation rules.mp4 | 9.87 MB |
| | 04_04-Setting the default value.mp4 | 6.71 MB |
| | 04_08-Challenge Creating tables.mp4 | 1.8 MB |
| | 05_04-Searching and replacing values.mp4 | 16.64 MB |
| | 05_02-Sorting table data.mp4 | 12.3 MB |
| | 05_01-Formatting columns.mp4 | 12.21 MB |
| | 05_03-Filtering table data.mp4 | 10.47 MB |
| | 06_03-Building queries in Design view.mp4 | 23.19 MB |
| | 06_09-Building expressions.mp4 | 19.42 MB |
| | 06_10-Obtaining summary statistics.mp4 | 17.91 MB |
| | 06_06-Leveraging multiple criteria with AND and OR statements.mp4 | 16.38 MB |
| | 06_04-Establishing constraints with criteria.mp4 | 14.62 MB |
| | 06_08-Creating flexible queries with parameter requests.mp4 | 12.67 MB |
| | 06_05-Specifying criteria with wildcards.mp4 | 10.9 MB |
| | 06_02-Creating queries with the Simple Query Wizard.mp4 | 9.92 MB |
| | 06_12-Solution Creating queries.mp4 | 9.92 MB |
| | 06_07-Filtering with mathematical comparisons.mp4 | 9.64 MB |
| | 07_01-Using update queries.mp4 | 18.62 MB |
| | 07_06-Creating a union query in SQL view.mp4 | 13.13 MB |
| | 07_03-Finding unmatched records.mp4 | 10.57 MB |
| | 07_04-Using delete queries.mp4 | 10.27 MB |
| | 07_05-Using append queries.mp4 | 9.42 MB |
| | 07_02-Using make table queries.mp4 | 9.14 MB |
| | 07_07-Getting a different look with crosstab queries.mp4 | 8.13 MB |
| | 08_03-Adjusting form elements in Layout view.mp4 | 12.49 MB |
| | 08_02-Generating forms from tables.mp4 | 11.99 MB |
| | 08_04-Using the Form Wizard.mp4 | 10.71 MB |
| | 08_01-Understanding the role of forms.mp4 | 5.08 MB |
| | 09_04-Adding components with form controls.mp4 | 36.93 MB |
| | 09_03-Setting data sources.mp4 | 18.24 MB |
| | 09_02-Exploring the form property sheet.mp4 | 17.46 MB |
| | 09_05-Understanding input boxes.mp4 | 15.72 MB |
| | 09_12-Solution Creating forms.mp4 | 14.91 MB |
| | 09_09-Checking out the More Forms options.mp4 | 14.88 MB |
| | 09_01-Creating forms in Design view.mp4 | 14.43 MB |
| | 09_08-Assigning a tab order.mp4 | 14.27 MB |
| | 09_07-Adding buttons.mp4 | 13.73 MB |
| | 09_06-Record navigation.mp4 | 12.38 MB |
| | 10_05-Grouping and sorting records.mp4 | 20.05 MB |
| | 10_07-Applying conditional formatting rules.mp4 | 19.22 MB |
| | 10_04-Editing a report in Layout view.mp4 | 17.96 MB |
| | 10_11-Solution Creating reports.mp4 | 14.6 MB |
| | 10_08-Creating labels.mp4 | 13.22 MB |
| | 10_03-Creating a report in Design view.mp4 | 13.12 MB |
| | 10_01-Introducing reports.mp4 | 11.24 MB |
| | 10_02-Using the Report Wizard.mp4 | 11.24 MB |
| | 10_06-Creating calculated totals.mp4 | 10.56 MB |
| | 10_09-Adjusting print settings.mp4 | 9.38 MB |
| | 10_10-Challenge Creating reports.mp4 | 1.42 MB |
| | 11_03-Attaching data macros to tables.mp4 | 16.95 MB |
| | 11_01-Creating macros.mp4 | 15.47 MB |
| | 11_02-Embedding macros into buttons.mp4 | 12.78 MB |
| | 11_04-Launching macros at startup.mp4 | 6.53 MB |
| | 12_04-Setting up labels and mail merge documents in Word.mp4 | 11.72 MB |
| | 12_02-Emailing with macros.mp4 | 11.12 MB |
| | 12_01-Exporting tables to Excel.mp4 | 9.03 MB |
| | 12_03-Linking to data in an Outlook database.mp4 | 5.9 MB |
| | 13_04-Documenting your work.mp4 | 11.53 MB |
| | 13_09-Setting startup options and custom icons.mp4 | 10.43 MB |
| | 13_06-Splitting a database into front and back ends.mp4 | 9.74 MB |
| | 13_01-Organizing the Navigation pane with custom groups.mp4 | 8.52 MB |
| | 13_07-Protecting the database with a password.mp4 | 8.51 MB |
| | 13_08-Creating custom Ribbon tabs.mp4 | 8.45 MB |
| | 13_05-Printing the blueprint of your database with the Database Documenter.mp4 | 7.03 MB |
| | 13_03-Examining database object dependencies.mp4 | 6.71 MB |
| | 13_02-Compacting and repairing the database.mp4 | 2.87 MB |
| | 14_01-Next steps.mp4 | 2.71 MB |
| | LandonHotel-EmailMacro.accdb | 4.34 MB |
| | LandonHotel-MailMerge.accdb | 4.34 MB |
| | LandonHotel-ExportExcel.accdb | 4.34 MB |
| | LandonHotel-LinkingOutlook.accdb | 4.34 MB |
| | MailMergeLetter.docx | 117.65 KB |
| | MonthlyRevenueSummary.xlsx | 9.52 KB |
| | LandonHotel-CompactRepair.accdb | 4.34 MB |
| | LandonHotel-CustomGroups.accdb | 4.34 MB |
| | LandonHotel-CustomRibbon.accdb | 2.37 MB |
| | LandonHotel-StartupOptions.accdb | 2.37 MB |
| | LandonHotel-Password.accdb | 2.37 MB |
| | LandonHotel-Splitting.accdb | 2.37 MB |
| | LandonHotel-Blueprint.accdb | 2.37 MB |
| | LandonHotel-Documentation.accdb | 2.2 MB |
| | LandonHotel-Dependencies.accdb | 2.2 MB |
| | landon icon.ico | 19.79 KB |
| | LandonHotel-Macros.accdb | 4.25 MB |
| | LandonHotel-EmbeddingMacros.accdb | 4.23 MB |
| | LandonHotel-StartupMacro.accdb | 4.23 MB |
| | LandonHotel-DataMacro.accdb | 4.23 MB |
| | LandonHotel-ChallengeSolution.accdb | 4.08 MB |
| | LandonHotel-ChallengeStart.accdb | 4.08 MB |
| | LandonHotel-PrintPreview.accdb | 3.95 MB |
| | LandonHotel-Labels.accdb | 3.91 MB |
| | LandonHotel-ConditionalFormatting.accdb | 3.88 MB |
| | LandonHotel-Calculations.accdb | 3.85 MB |
| | LandonHotel-GroupSort.accdb | 3.76 MB |
| | LandonHotel-ReportLayout.accdb | 3.72 MB |
| | LandonHotel-ReportDesign.accdb | 3.72 MB |
| | LandonHotel-ReportWizard.accdb | 3.72 MB |
| | LandonHotel-ChallengeSolution.accdb | 3.67 MB |
| | LandonHotel-ChallengeStart.accdb | 3.63 MB |
| | LandonHotel-NavigationForm.accdb | 3.33 MB |
| | LandonHotel-MoreForms.accdb | 3.32 MB |
| | LandonHotel-TabOrder.accdb | 3.32 MB |
| | LandonHotel-Buttons.accdb | 3.3 MB |
| | LandonHotel-FormDataSource.accdb | 3.25 MB |
| | LandonHotel-FormControls.accdb | 3.25 MB |
| | LandonHotel-InputBoxes.accdb | 3.25 MB |
| | LandonHotel-FormDesign.accdb | 3.25 MB |
| | LandonHotel-FormWizard.accdb | 3.06 MB |
| | LandonHotel-FormLayout.accdb | 3.01 MB |
| | LandonHotel-GeneratingForms.accdb | 2.97 MB |
| | LandonHotel-Navigation.accdb | 3 MB |
| | LandonHotel-QuickAccessToolbar.accdb | 3 MB |
| | LandonHotel-Help.accdb | 3 MB |
| | LandonHotel-Backups.accdb | 3 MB |
| | LandonHotel-MicrosoftLive.accdb | 3 MB |
| | LandonHotel-TellMe.accdb | 3 MB |
| | LandonHotel-TrustCenter.accdb | 372 KB |
| | LandonHotel-Ribbon.accdb | 372 KB |
| | LandonHotel-Crosstab.accdb | 2.97 MB |
| | LandonHotel-Delete.accdb | 2.96 MB |
| | LandonHotel-Unmatched.accdb | 2.95 MB |
| | LandonHotel-Update.accdb | 2.95 MB |
| | LandonHotel-MakeTable.accdb | 2.95 MB |
| | LandonHotel-Append.accdb | 620 KB |
| | LandonHotel-Union.accdb | 620 KB |
| | LandonHotel-Archive.accdb | 336 KB |
| | LandonHotel-ChallengeSolution.accdb | 2.95 MB |
| | LandonHotel-ChallengeStart.accdb | 2.95 MB |
| | LandonHotel-Statistics.accdb | 2.93 MB |
| | LandonHotel-Wildcards.accdb | 2.93 MB |
| | LandonHotel-QueryDesign.accdb | 2.93 MB |
| | LandonHotel-Expressions.accdb | 2.93 MB |
| | LandonHotel-QueryWizard.accdb | 2.93 MB |
| | LandonHotel-MultipleCriteria.accdb | 2.93 MB |
| | LandonHotel-Parameters.accdb | 2.93 MB |
| | LandonHotel-Comparison.accdb | 2.93 MB |
| | LandonHotel-Constraints.accdb | 2.93 MB |
| | LandonHotel-ChallengeStart.accdb | 2.52 MB |
| | LandonHotel-ChallengeComplete.accdb | 2.52 MB |
| | LandonHotel-Lookup.accdb | 2.52 MB |
| | LandonHotel-Properties.accdb | 2.52 MB |
| | LandonHotel-EditingTables.accdb | 632 KB |
| | LandonHotel-Relationships.accdb | 632 KB |
| | LandonHotel-Masks.accdb | 632 KB |
| | LandonHotel-DefaultValue.accdb | 632 KB |
| | LandonHotel-Validation.accdb | 632 KB |
| | LandonHotel-Searching.accdb | 2.52 MB |
| | LandonHotel-Formatting.accdb | 2.52 MB |
| | LandonHotel-Filtering.accdb | 2.52 MB |
| | LandonHotel-Sorting.accdb | 2.52 MB |