Download Lynda - Office 2016 Essential Training - Access 2016 Torrent

Torrent Contents Size: 1.27 GB

Lynda - Office 2016 Essential Training - Access 2016

01. Introduction

01_01-Welcome.mp4	MP4	6.98 MB
01_02-Using the exercise files.mp4	MP4	1.41 MB
01_03-Challenges explained.mp4	MP4	926.69 KB

02. Getting Started

02_01-Key database concepts.mp4	MP4	10.3 MB
02_02-Launching Access and the backstage screen.mp4	MP4	1.59 MB
02_03-Creating the database file.mp4	MP4	7.59 MB
02_04-Understanding the Trust Center.mp4	MP4	8.08 MB
02_05-Digging into Ribbon tabs.mp4	MP4	10.93 MB
02_06-Using the Navigation pane.mp4	MP4	11.12 MB
02_07-Using the Tell Me feature.mp4	MP4	4.33 MB
02_08-Using the Quick Access Toolbar.mp4	MP4	8.02 MB
02_09-Signing in to a Microsoft account.mp4	MP4	3.91 MB
02_10-Making backups.mp4	MP4	5.19 MB
02_11-Accessing Access help.mp4	MP4	6.44 MB

03. Creating Tables

03_01-Understanding table structure and relationships.mp4	MP4	9.69 MB
03_02-Creating a table and setting data types.mp4	MP4	12.08 MB
03_03-Entering data.mp4	MP4	10.69 MB
03_04-Understanding primary and foreign keys.mp4	MP4	12.72 MB
03_05-Importing tables.mp4	MP4	14.74 MB

04. Setting Field Properties

04_01-Establishing relationships and maintaining referential integrity.mp4	MP4	15.14 MB
04_02-Editing table structure in Design view.mp4	MP4	11.19 MB
04_03-Controlling input with masks.mp4	MP4	16.2 MB
04_04-Setting the default value.mp4	MP4	6.71 MB
04_05-Establishing validation rules.mp4	MP4	9.87 MB
04_06-Creating lookup fields.mp4	MP4	9.88 MB
04_07-Setting additional field properties.mp4	MP4	12.23 MB
04_08-Challenge Creating tables.mp4	MP4	1.8 MB
04_09-Solution Creating tables.mp4	MP4	12.17 MB

05. Organizing Records

05_01-Formatting columns.mp4	MP4	12.21 MB
05_02-Sorting table data.mp4	MP4	12.3 MB
05_03-Filtering table data.mp4	MP4	10.47 MB
05_04-Searching and replacing values.mp4	MP4	16.64 MB

06. Using Queries

06_01-Understanding queries.mp4	MP4	7.57 MB
06_02-Creating queries with the Simple Query Wizard.mp4	MP4	9.92 MB
06_03-Building queries in Design view.mp4	MP4	23.19 MB
06_04-Establishing constraints with criteria.mp4	MP4	14.62 MB
06_05-Specifying criteria with wildcards.mp4	MP4	10.9 MB
06_06-Leveraging multiple criteria with AND and OR statements.mp4	MP4	16.38 MB
06_07-Filtering with mathematical comparisons.mp4	MP4	9.64 MB
06_08-Creating flexible queries with parameter requests.mp4	MP4	12.67 MB
06_09-Building expressions.mp4	MP4	19.42 MB
06_10-Obtaining summary statistics.mp4	MP4	17.91 MB
06_11-Challenge Creating queries.mp4	MP4	1.66 MB
06_12-Solution Creating queries.mp4	MP4	9.92 MB

07. Working with Specialty Queries

07_01-Using update queries.mp4	MP4	18.62 MB
07_02-Using make table queries.mp4	MP4	9.14 MB
07_03-Finding unmatched records.mp4	MP4	10.57 MB
07_04-Using delete queries.mp4	MP4	10.27 MB
07_05-Using append queries.mp4	MP4	9.42 MB
07_06-Creating a union query in SQL view.mp4	MP4	13.13 MB
07_07-Getting a different look with crosstab queries.mp4	MP4	8.13 MB

08. Creating Forms

08_01-Understanding the role of forms.mp4	MP4	5.08 MB
08_02-Generating forms from tables.mp4	MP4	11.99 MB
08_03-Adjusting form elements in Layout view.mp4	MP4	12.49 MB
08_04-Using the Form Wizard.mp4	MP4	10.71 MB

09. Designing Forms

09_01-Creating forms in Design view.mp4	MP4	14.43 MB
09_02-Exploring the form property sheet.mp4	MP4	17.46 MB
09_03-Setting data sources.mp4	MP4	18.24 MB
09_04-Adding components with form controls.mp4	MP4	36.93 MB
09_05-Understanding input boxes.mp4	MP4	15.72 MB
09_06-Record navigation.mp4	MP4	12.38 MB
09_07-Adding buttons.mp4	MP4	13.73 MB
09_08-Assigning a tab order.mp4	MP4	14.27 MB
09_09-Checking out the More Forms options.mp4	MP4	14.88 MB
09_10-Creating a navigation form.mp4	MP4	12.12 MB
09_11-Challenge Creating forms.mp4	MP4	1.66 MB
09_12-Solution Creating forms.mp4	MP4	14.91 MB

10. Creating Reports

10_01-Introducing reports.mp4	MP4	11.24 MB
10_02-Using the Report Wizard.mp4	MP4	11.24 MB
10_03-Creating a report in Design view.mp4	MP4	13.12 MB
10_04-Editing a report in Layout view.mp4	MP4	17.96 MB
10_05-Grouping and sorting records.mp4	MP4	20.05 MB
10_06-Creating calculated totals.mp4	MP4	10.56 MB
10_07-Applying conditional formatting rules.mp4	MP4	19.22 MB
10_08-Creating labels.mp4	MP4	13.22 MB
10_09-Adjusting print settings.mp4	MP4	9.38 MB
10_10-Challenge Creating reports.mp4	MP4	1.42 MB
10_11-Solution Creating reports.mp4	MP4	14.6 MB

11. Working with Macros

11_01-Creating macros.mp4	MP4	15.47 MB
11_02-Embedding macros into buttons.mp4	MP4	12.78 MB
11_03-Attaching data macros to tables.mp4	MP4	16.95 MB
11_04-Launching macros at startup.mp4	MP4	6.53 MB

12. Integrating Access with Office Suite

12_01-Exporting tables to Excel.mp4	MP4	9.03 MB
12_02-Emailing with macros.mp4	MP4	11.12 MB
12_03-Linking to data in an Outlook database.mp4	MP4	5.9 MB
12_04-Setting up labels and mail merge documents in Word.mp4	MP4	11.72 MB

13. Maintaining the Database

13_01-Organizing the Navigation pane with custom groups.mp4	MP4	8.52 MB
13_02-Compacting and repairing the database.mp4	MP4	2.87 MB
13_03-Examining database object dependencies.mp4	MP4	6.71 MB
13_04-Documenting your work.mp4	MP4	11.53 MB
13_05-Printing the blueprint of your database with the Database Documenter.mp4	MP4	7.03 MB
13_06-Splitting a database into front and back ends.mp4	MP4	9.74 MB
13_07-Protecting the database with a password.mp4	MP4	8.51 MB
13_08-Creating custom Ribbon tabs.mp4	MP4	8.45 MB
13_09-Setting startup options and custom icons.mp4	MP4	10.43 MB

14. Conclusion

14_01-Next steps.mp4

MP4

2.71 MB

Project_Files

Ex_Files_Access_2016_EssT

Exercise Files

Chapter 1

LandonHotel-Backups.accdb	ACCDB	3 MB
LandonHotel-Help.accdb	ACCDB	3 MB
LandonHotel-MicrosoftLive.accdb	ACCDB	3 MB
LandonHotel-Navigation.accdb	ACCDB	3 MB
LandonHotel-QuickAccessToolbar.accdb	ACCDB	3 MB
LandonHotel-Ribbon.accdb	ACCDB	372 KB
LandonHotel-TellMe.accdb	ACCDB	3 MB
LandonHotel-TrustCenter.accdb	ACCDB	372 KB

Chapter 10

LandonHotel-DataMacro.accdb	ACCDB	4.23 MB
LandonHotel-EmbeddingMacros.accdb	ACCDB	4.23 MB
LandonHotel-Macros.accdb	ACCDB	4.25 MB
LandonHotel-StartupMacro.accdb	ACCDB	4.23 MB

Chapter 11

LandonHotel-EmailMacro.accdb	ACCDB	4.34 MB
LandonHotel-ExportExcel.accdb	ACCDB	4.34 MB
LandonHotel-LinkingOutlook.accdb	ACCDB	4.34 MB
LandonHotel-MailMerge.accdb	ACCDB	4.34 MB
MailMergeLetter.docx	DOCX	117.65 KB
MonthlyRevenueSummary.xlsx	XLSX	9.52 KB

Chapter 12

LandonHotel-Blueprint.accdb	ACCDB	2.37 MB
LandonHotel-CompactRepair.accdb	ACCDB	4.34 MB
LandonHotel-CustomGroups.accdb	ACCDB	4.34 MB
LandonHotel-CustomRibbon.accdb	ACCDB	2.37 MB
LandonHotel-Dependencies.accdb	ACCDB	2.2 MB
LandonHotel-Documentation.accdb	ACCDB	2.2 MB
LandonHotel-Password.accdb	ACCDB	2.37 MB
LandonHotel-Splitting.accdb	ACCDB	2.37 MB
LandonHotel-StartupOptions.accdb	ACCDB	2.37 MB
landon icon.ico	ICO	19.79 KB

Chapter 2

Guests.xlsx	XLSX	24.47 KB
LandonHotel-EnteringData.accdb	ACCDB	632 KB
LandonHotel-ImportingTables.accdb	ACCDB	632 KB
LandonHotel-Tables.accdb	ACCDB	372 KB
LandonHotel-UsingKeys.accdb	ACCDB	632 KB

Chapter 3

LandonHotel-ChallengeComplete.accdb	ACCDB	2.52 MB
LandonHotel-ChallengeStart.accdb	ACCDB	2.52 MB
LandonHotel-DefaultValue.accdb	ACCDB	632 KB
LandonHotel-EditingTables.accdb	ACCDB	632 KB
LandonHotel-Lookup.accdb	ACCDB	2.52 MB
LandonHotel-Masks.accdb	ACCDB	632 KB
LandonHotel-Properties.accdb	ACCDB	2.52 MB
LandonHotel-Relationships.accdb	ACCDB	632 KB
LandonHotel-Validation.accdb	ACCDB	632 KB

Chapter 4

LandonHotel-Filtering.accdb	ACCDB	2.52 MB
LandonHotel-Formatting.accdb	ACCDB	2.52 MB
LandonHotel-Searching.accdb	ACCDB	2.52 MB
LandonHotel-Sorting.accdb	ACCDB	2.52 MB

Chapter 5

LandonHotel-ChallengeSolution.accdb	ACCDB	2.95 MB
LandonHotel-ChallengeStart.accdb	ACCDB	2.95 MB
LandonHotel-Comparison.accdb	ACCDB	2.93 MB
LandonHotel-Constraints.accdb	ACCDB	2.93 MB
LandonHotel-Expressions.accdb	ACCDB	2.93 MB
LandonHotel-MultipleCriteria.accdb	ACCDB	2.93 MB
LandonHotel-Parameters.accdb	ACCDB	2.93 MB
LandonHotel-QueryDesign.accdb	ACCDB	2.93 MB
LandonHotel-QueryWizard.accdb	ACCDB	2.93 MB
LandonHotel-Statistics.accdb	ACCDB	2.93 MB
LandonHotel-Wildcards.accdb	ACCDB	2.93 MB

Chapter 6

LandonHotel-Append.accdb	ACCDB	620 KB
LandonHotel-Archive.accdb	ACCDB	336 KB
LandonHotel-Crosstab.accdb	ACCDB	2.97 MB
LandonHotel-Delete.accdb	ACCDB	2.96 MB
LandonHotel-MakeTable.accdb	ACCDB	2.95 MB
LandonHotel-Union.accdb	ACCDB	620 KB
LandonHotel-Unmatched.accdb	ACCDB	2.95 MB
LandonHotel-Update.accdb	ACCDB	2.95 MB

Chapter 7

LandonHotel-FormLayout.accdb	ACCDB	3.01 MB
LandonHotel-FormWizard.accdb	ACCDB	3.06 MB
LandonHotel-GeneratingForms.accdb	ACCDB	2.97 MB

Chapter 8

LandonHotel-Buttons.accdb	ACCDB	3.3 MB
LandonHotel-ChallengeSolution.accdb	ACCDB	3.67 MB
LandonHotel-ChallengeStart.accdb	ACCDB	3.63 MB
LandonHotel-FormControls.accdb	ACCDB	3.25 MB
LandonHotel-FormDataSource.accdb	ACCDB	3.25 MB
LandonHotel-FormDesign.accdb	ACCDB	3.25 MB
LandonHotel-FormProperties.accdb	ACCDB	3.25 MB
LandonHotel-InputBoxes.accdb	ACCDB	3.25 MB
LandonHotel-MoreForms.accdb	ACCDB	3.32 MB
LandonHotel-Navigation.accdb	ACCDB	3.25 MB
LandonHotel-NavigationForm.accdb	ACCDB	3.33 MB
LandonHotel-TabOrder.accdb	ACCDB	3.32 MB
landon bug.png	PNG	18.8 KB
landon logo.png	PNG	23.13 KB

Chapter 9

LandonHotel-Calculations.accdb	ACCDB	3.85 MB
LandonHotel-ChallengeSolution.accdb	ACCDB	4.08 MB
LandonHotel-ChallengeStart.accdb	ACCDB	4.08 MB
LandonHotel-ConditionalFormatting.accdb	ACCDB	3.88 MB
LandonHotel-GroupSort.accdb	ACCDB	3.76 MB
LandonHotel-Labels.accdb	ACCDB	3.91 MB
LandonHotel-PrintPreview.accdb	ACCDB	3.95 MB
LandonHotel-ReportDesign.accdb	ACCDB	3.72 MB
LandonHotel-ReportLayout.accdb	ACCDB	3.72 MB
LandonHotel-ReportWizard.accdb	ACCDB	3.72 MB
LandonHotel-Reports.accdb	ACCDB	3.67 MB
landon bug.png	PNG	18.8 KB

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
[ DevCourseWeb ] Lynda - Excel - Setting Up a Database (Office 365 - Microsoft 365) Posted by freecoursewb in Other Posted in Other 0 207.9 MB 5 years ago freecoursewb	Size 207.9 MB	Files 1	Age 5 years ago	Seeds 0	Leechs 0	Source
Lynda - Excel: Setting Up a Database (Office 365/Microsoft 365) Posted by tutsnode in Other Posted in Other 12 215.36 MB 5 years ago tutsnode	Size 215.36 MB	Files 36	Age 5 years ago	Seeds 12	Leechs 1	Source
[ DevCourseWeb ] Lynda - Word Essential Training (Office 365 - Microsoft 365) Posted by freecoursewb in Other Posted in Other 0 466.3 MB 5 years ago freecoursewb	Size 466.3 MB	Files 1	Age 5 years ago	Seeds 0	Leechs 1	Source
[ FreeCourseWeb ] Lynda - PowerPoint Essential Training (Office 365 - Microsoft 365) Posted by freecoursewb in Other Posted in Other 0 1.2 GB 5 years ago freecoursewb	Size 1.2 GB	Files 1	Age 5 years ago	Seeds 0	Leechs 1	Source
[ DevCourseWeb ] Lynda - Note-Taking Tips for Microsoft Office 365 Posted by freecoursewb in Other Posted in Other 0 169.6 MB 5 years ago freecoursewb	Size 169.6 MB	Files 1	Age 5 years ago	Seeds 0	Leechs 0	Source

Lynda - Office 2016 Essential Training - Access 2016

Torrent Contents Size: 1.27 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce