[Lt]-Access 2016 Essential Training

seeders: 11

leechers: 31

Download torrent

Added on September 27, 2015 by signrcin Other > Tutorials
Torrent verified.

Main

add to bookmarks

[Lt]-Access 2016 Essential Training (Size: 1.27 GB)

		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

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