[Lt]-Access 2016 Essential Training

seeders: 11
leechers: 31
Added on September 27, 2015 by signrcin Other > Tutorials
Torrent verified.



[Lt]-Access 2016 Essential Training (Size: 1.27 GB)
 01_01-Welcome.mp46.98 MB
 01_02-Using the exercise files.mp41.41 MB
 01_03-Challenges explained.mp4926.69 KB
 02_06-Using the Navigation pane.mp411.12 MB
 02_05-Digging into Ribbon tabs.mp410.93 MB
 02_01-Key database concepts.mp410.3 MB
 02_04-Understanding the Trust Center.mp48.08 MB
 02_08-Using the Quick Access Toolbar.mp48.02 MB
 02_03-Creating the database file.mp47.59 MB
 02_11-Accessing Access help.mp46.44 MB
 02_10-Making backups.mp45.19 MB
 02_07-Using the Tell Me feature.mp44.33 MB
 02_09-Signing in to a Microsoft account.mp43.91 MB
 02_02-Launching Access and the Backstage screen.mp41.59 MB
 03_05-Importing tables.mp414.74 MB
 03_04-Understanding primary and foreign keys.mp412.72 MB
 03_02-Creating a table and setting data types.mp412.08 MB
 03_03-Entering data.mp410.69 MB
 03_01-Understanding table structure and relationships.mp49.69 MB
 04_03-Controlling input with masks.mp416.2 MB
 04_01-Establishing relationships and maintaining referential integrity.mp415.14 MB
 04_07-Setting additional field properties.mp412.23 MB
 04_09-Solution Creating tables.mp412.17 MB
 04_02-Editing table structure in Design view.mp411.19 MB
 04_06-Creating lookup fields.mp49.88 MB
 04_05-Establishing validation rules.mp49.87 MB
 04_04-Setting the default value.mp46.71 MB
 04_08-Challenge Creating tables.mp41.8 MB
 05_04-Searching and replacing values.mp416.64 MB
 05_02-Sorting table data.mp412.3 MB
 05_01-Formatting columns.mp412.21 MB
 05_03-Filtering table data.mp410.47 MB
 06_03-Building queries in Design view.mp423.19 MB
 06_09-Building expressions.mp419.42 MB
 06_10-Obtaining summary statistics.mp417.91 MB
 06_06-Leveraging multiple criteria with AND and OR statements.mp416.38 MB
 06_04-Establishing constraints with criteria.mp414.62 MB
 06_08-Creating flexible queries with parameter requests.mp412.67 MB
 06_05-Specifying criteria with wildcards.mp410.9 MB
 06_02-Creating queries with the Simple Query Wizard.mp49.92 MB
 06_12-Solution Creating queries.mp49.92 MB
 06_07-Filtering with mathematical comparisons.mp49.64 MB
 07_01-Using update queries.mp418.62 MB
 07_06-Creating a union query in SQL view.mp413.13 MB
 07_03-Finding unmatched records.mp410.57 MB
 07_04-Using delete queries.mp410.27 MB
 07_05-Using append queries.mp49.42 MB
 07_02-Using make table queries.mp49.14 MB
 07_07-Getting a different look with crosstab queries.mp48.13 MB
 08_03-Adjusting form elements in Layout view.mp412.49 MB
 08_02-Generating forms from tables.mp411.99 MB
 08_04-Using the Form Wizard.mp410.71 MB
 08_01-Understanding the role of forms.mp45.08 MB
 09_04-Adding components with form controls.mp436.93 MB
 09_03-Setting data sources.mp418.24 MB
 09_02-Exploring the form property sheet.mp417.46 MB
 09_05-Understanding input boxes.mp415.72 MB
 09_12-Solution Creating forms.mp414.91 MB
 09_09-Checking out the More Forms options.mp414.88 MB
 09_01-Creating forms in Design view.mp414.43 MB
 09_08-Assigning a tab order.mp414.27 MB
 09_07-Adding buttons.mp413.73 MB
 09_06-Record navigation.mp412.38 MB
 10_05-Grouping and sorting records.mp420.05 MB
 10_07-Applying conditional formatting rules.mp419.22 MB
 10_04-Editing a report in Layout view.mp417.96 MB
 10_11-Solution Creating reports.mp414.6 MB
 10_08-Creating labels.mp413.22 MB
 10_03-Creating a report in Design view.mp413.12 MB
 10_01-Introducing reports.mp411.24 MB
 10_02-Using the Report Wizard.mp411.24 MB
 10_06-Creating calculated totals.mp410.56 MB
 10_09-Adjusting print settings.mp49.38 MB
 10_10-Challenge Creating reports.mp41.42 MB
 11_03-Attaching data macros to tables.mp416.95 MB
 11_01-Creating macros.mp415.47 MB
 11_02-Embedding macros into buttons.mp412.78 MB
 11_04-Launching macros at startup.mp46.53 MB
 12_04-Setting up labels and mail merge documents in Word.mp411.72 MB
 12_02-Emailing with macros.mp411.12 MB
 12_01-Exporting tables to Excel.mp49.03 MB
 12_03-Linking to data in an Outlook database.mp45.9 MB
 13_04-Documenting your work.mp411.53 MB
 13_09-Setting startup options and custom icons.mp410.43 MB
 13_06-Splitting a database into front and back ends.mp49.74 MB
 13_01-Organizing the Navigation pane with custom groups.mp48.52 MB
 13_07-Protecting the database with a password.mp48.51 MB
 13_08-Creating custom Ribbon tabs.mp48.45 MB
 13_05-Printing the blueprint of your database with the Database Documenter.mp47.03 MB
 13_03-Examining database object dependencies.mp46.71 MB
 13_02-Compacting and repairing the database.mp42.87 MB
 14_01-Next steps.mp42.71 MB
 LandonHotel-EmailMacro.accdb4.34 MB
 LandonHotel-MailMerge.accdb4.34 MB
 LandonHotel-ExportExcel.accdb4.34 MB
 LandonHotel-LinkingOutlook.accdb4.34 MB
 MailMergeLetter.docx117.65 KB
 MonthlyRevenueSummary.xlsx9.52 KB
 LandonHotel-CompactRepair.accdb4.34 MB
 LandonHotel-CustomGroups.accdb4.34 MB
 LandonHotel-CustomRibbon.accdb2.37 MB
 LandonHotel-StartupOptions.accdb2.37 MB
 LandonHotel-Password.accdb2.37 MB
 LandonHotel-Splitting.accdb2.37 MB
 LandonHotel-Blueprint.accdb2.37 MB
 LandonHotel-Documentation.accdb2.2 MB
 LandonHotel-Dependencies.accdb2.2 MB
 landon icon.ico19.79 KB
 LandonHotel-Macros.accdb4.25 MB
 LandonHotel-EmbeddingMacros.accdb4.23 MB
 LandonHotel-StartupMacro.accdb4.23 MB
 LandonHotel-DataMacro.accdb4.23 MB
 LandonHotel-ChallengeSolution.accdb4.08 MB
 LandonHotel-ChallengeStart.accdb4.08 MB
 LandonHotel-PrintPreview.accdb3.95 MB
 LandonHotel-Labels.accdb3.91 MB
 LandonHotel-ConditionalFormatting.accdb3.88 MB
 LandonHotel-Calculations.accdb3.85 MB
 LandonHotel-GroupSort.accdb3.76 MB
 LandonHotel-ReportLayout.accdb3.72 MB
 LandonHotel-ReportDesign.accdb3.72 MB
 LandonHotel-ReportWizard.accdb3.72 MB
 LandonHotel-ChallengeSolution.accdb3.67 MB
 LandonHotel-ChallengeStart.accdb3.63 MB
 LandonHotel-NavigationForm.accdb3.33 MB
 LandonHotel-MoreForms.accdb3.32 MB
 LandonHotel-TabOrder.accdb3.32 MB
 LandonHotel-Buttons.accdb3.3 MB
 LandonHotel-FormDataSource.accdb3.25 MB
 LandonHotel-FormControls.accdb3.25 MB
 LandonHotel-InputBoxes.accdb3.25 MB
 LandonHotel-FormDesign.accdb3.25 MB
 LandonHotel-FormWizard.accdb3.06 MB
 LandonHotel-FormLayout.accdb3.01 MB
 LandonHotel-GeneratingForms.accdb2.97 MB
 LandonHotel-Navigation.accdb3 MB
 LandonHotel-QuickAccessToolbar.accdb3 MB
 LandonHotel-Help.accdb3 MB
 LandonHotel-Backups.accdb3 MB
 LandonHotel-MicrosoftLive.accdb3 MB
 LandonHotel-TellMe.accdb3 MB
 LandonHotel-TrustCenter.accdb372 KB
 LandonHotel-Ribbon.accdb372 KB
 LandonHotel-Crosstab.accdb2.97 MB
 LandonHotel-Delete.accdb2.96 MB
 LandonHotel-Unmatched.accdb2.95 MB
 LandonHotel-Update.accdb2.95 MB
 LandonHotel-MakeTable.accdb2.95 MB
 LandonHotel-Append.accdb620 KB
 LandonHotel-Union.accdb620 KB
 LandonHotel-Archive.accdb336 KB
 LandonHotel-ChallengeSolution.accdb2.95 MB
 LandonHotel-ChallengeStart.accdb2.95 MB
 LandonHotel-Statistics.accdb2.93 MB
 LandonHotel-Wildcards.accdb2.93 MB
 LandonHotel-QueryDesign.accdb2.93 MB
 LandonHotel-Expressions.accdb2.93 MB
 LandonHotel-QueryWizard.accdb2.93 MB
 LandonHotel-MultipleCriteria.accdb2.93 MB
 LandonHotel-Parameters.accdb2.93 MB
 LandonHotel-Comparison.accdb2.93 MB
 LandonHotel-Constraints.accdb2.93 MB
 LandonHotel-ChallengeStart.accdb2.52 MB
 LandonHotel-ChallengeComplete.accdb2.52 MB
 LandonHotel-Lookup.accdb2.52 MB
 LandonHotel-Properties.accdb2.52 MB
 LandonHotel-EditingTables.accdb632 KB
 LandonHotel-Relationships.accdb632 KB
 LandonHotel-Masks.accdb632 KB
 LandonHotel-DefaultValue.accdb632 KB
 LandonHotel-Validation.accdb632 KB
 LandonHotel-Searching.accdb2.52 MB
 LandonHotel-Formatting.accdb2.52 MB
 LandonHotel-Filtering.accdb2.52 MB
 LandonHotel-Sorting.accdb2.52 MB


Description

Access 2016 Essential Training with Adam Wilbert
Duration: 6h 45m
Level: Beginner
Published: Sep 22, 2015


Learn how to build databases to store and retrieve your data more efficiently with Access 2016. Adam Wilbert shows how to use the powerful program to wrangle your data and create your first table, and highlights smart strategies to edit and modify fields and records.

The course also shows you how to build queries and action queries, create and design forms, use macros, integrate Access with the rest of the Office 2016 suite, and maintain your databases over time.

Topics include:

Creating a new database
Creating tables and new data types
Importing and entering data
Setting up relationships and primary keys
Adding validation rules
Sorting and filtering table data
Building queries
Designing forms
Creating reports
Attaching macros to buttons and tables
Working with Excel and Outlook data
Maintaining an Access database

Sharing Widget


Download torrent
1.27 GB
seeders:11
leechers:31
[Lt]-Access 2016 Essential Training