|
|
01 - Building Access databases.mp4
|
MP4
|
9.5 MB
|
|
|
01 - Building Access databases.srt
|
SRT
|
9.4 KB
|
|
|
01 - Building databases with Access.mp4
|
MP4
|
3.1 MB
|
|
|
01 - Building databases with Access.srt
|
SRT
|
1.3 KB
|
|
|
01 - Create your first macro.mp4
|
MP4
|
13.6 MB
|
|
|
01 - Create your first macro.srt
|
SRT
|
9.9 KB
|
|
|
01 - Customize groups in the Navigation Pane.mp4
|
MP4
|
8.2 MB
|
|
|
01 - Customize groups in the Navigation Pane.srt
|
SRT
|
7.4 KB
|
|
|
01 - Database concepts.mp4
|
MP4
|
9.1 MB
|
|
|
01 - Database concepts.srt
|
SRT
|
8.9 KB
|
|
|
01 - Final thoughts Applying your Access skills.mp4
|
MP4
|
2.4 MB
|
|
|
01 - Final thoughts Applying your Access skills.srt
|
SRT
|
2.6 KB
|
|
|
01 - Introducing reports.mp4
|
MP4
|
17 MB
|
|
|
01 - Introducing reports.srt
|
SRT
|
10.5 KB
|
|
|
01 - Relationships and referential integrity.mp4
|
MP4
|
13.9 MB
|
|
|
01 - Relationships and referential integrity.srt
|
SRT
|
14.8 KB
|
|
|
01 - Sorting table data.mp4
|
MP4
|
15.3 MB
|
|
|
01 - Sorting table data.srt
|
SRT
|
7 KB
|
|
|
01 - Understand the role of forms.mp4
|
MP4
|
4.8 MB
|
|
|
01 - Understand the role of forms.srt
|
SRT
|
5.2 KB
|
|
|
01 - What are queries.mp4
|
MP4
|
7.9 MB
|
|
|
01 - What are queries.srt
|
SRT
|
8.3 KB
|
|
|
02 - Create the database file.mp4
|
MP4
|
8.5 MB
|
|
|
02 - Create the database file.srt
|
SRT
|
9.7 KB
|
|
|
02 - Customize the Quick Access Toolbar.mp4
|
MP4
|
5 MB
|
|
|
02 - Customize the Quick Access Toolbar.srt
|
SRT
|
4.5 KB
|
|
|
02 - Editing table structure in Design view.mp4
|
MP4
|
15.9 MB
|
|
|
02 - Editing table structure in Design view.srt
|
SRT
|
11.1 KB
|
|
|
02 - Filtering table rows.mp4
|
MP4
|
12.7 MB
|
|
|
02 - Filtering table rows.srt
|
SRT
|
6.4 KB
|
|
|
02 - Generate forms from tables.mp4
|
MP4
|
17 MB
|
|
|
02 - Generate forms from tables.srt
|
SRT
|
12.9 KB
|
|
|
02 - Table structures and data types.mp4
|
MP4
|
11.2 MB
|
|
|
02 - Table structures and data types.srt
|
SRT
|
12 KB
|
|
|
02 - The Report Wizard.mp4
|
MP4
|
9.9 MB
|
|
|
02 - The Report Wizard.srt
|
SRT
|
8.1 KB
|
|
|
02 - The Simple Query Wizard.mp4
|
MP4
|
15.3 MB
|
|
|
02 - The Simple Query Wizard.srt
|
SRT
|
12.8 KB
|
|
|
02 - What you should know about Access 2024.mp4
|
MP4
|
2.9 MB
|
|
|
02 - What you should know about Access 2024.srt
|
SRT
|
3.3 KB
|
|
|
02 - Work with embedded macros.mp4
|
MP4
|
10.6 MB
|
|
|
02 - Work with embedded macros.srt
|
SRT
|
8.1 KB
|
|
|
03 - Adjusting form elements in Layout view.mp4
|
MP4
|
16.5 MB
|
|
|
03 - Adjusting form elements in Layout view.srt
|
SRT
|
13.5 KB
|
|
|
03 - Build queries in Design view.mp4
|
MP4
|
17.9 MB
|
|
|
03 - Build queries in Design view.srt
|
SRT
|
14.2 KB
|
|
|
03 - Compact and repair the database.mp4
|
MP4
|
3.5 MB
|
|
|
03 - Compact and repair the database.srt
|
SRT
|
3.4 KB
|
|
|
03 - Control input with masks.mp4
|
MP4
|
10.2 MB
|
|
|
03 - Control input with masks.srt
|
SRT
|
8.7 KB
|
|
|
03 - Create a table and set data types.mp4
|
MP4
|
13.8 MB
|
|
|
03 - Create a table and set data types.srt
|
SRT
|
13.8 KB
|
|
|
03 - Deleting records.mp4
|
MP4
|
9.1 MB
|
|
|
03 - Deleting records.srt
|
SRT
|
7.6 KB
|
|
|
03 - Edit a report in Design view.mp4
|
MP4
|
25.9 MB
|
|
|
03 - Edit a report in Design view.srt
|
SRT
|
16.8 KB
|
|
|
03 - Take a quick peek at the Visual Basic language.mp4
|
MP4
|
15.3 MB
|
|
|
03 - Take a quick peek at the Visual Basic language.srt
|
SRT
|
9.5 KB
|
|
|
03 - Understand the Access Trust Center.mp4
|
MP4
|
6.6 MB
|
|
|
03 - Understand the Access Trust Center.srt
|
SRT
|
6.7 KB
|
|
|
04 - Create a database backup.mp4
|
MP4
|
2.2 MB
|
|
|
04 - Create a database backup.srt
|
SRT
|
2.2 KB
|
|
|
04 - Digging into ribbon tabs.mp4
|
MP4
|
10.1 MB
|
|
|
04 - Digging into ribbon tabs.srt
|
SRT
|
12.3 KB
|
|
|
04 - Edit a report in Layout view.mp4
|
MP4
|
17.1 MB
|
|
|
04 - Edit a report in Layout view.srt
|
SRT
|
12.3 KB
|
|
|
04 - Enter data.mp4
|
MP4
|
10.9 MB
|
|
|
04 - Enter data.srt
|
SRT
|
10.6 KB
|
|
|
04 - Establishing constraints with criteria.mp4
|
MP4
|
15 MB
|
|
|
04 - Establishing constraints with criteria.srt
|
SRT
|
11.3 KB
|
|
|
04 - Set a default value.mp4
|
MP4
|
13.7 MB
|
|
|
04 - Set a default value.srt
|
SRT
|
7.6 KB
|
|
|
04 - Using the Form Wizard.mp4
|
MP4
|
9.1 MB
|
|
|
04 - Using the Form Wizard.srt
|
SRT
|
8.2 KB
|
|
|
05 - Data validation rules.mp4
|
MP4
|
9.2 MB
|
|
|
05 - Data validation rules.srt
|
SRT
|
7.7 KB
|
|
|
05 - Examine database object relationships.mp4
|
MP4
|
6.3 MB
|
|
|
05 - Examine database object relationships.srt
|
SRT
|
5.7 KB
|
|
|
05 - Form Design view.mp4
|
MP4
|
23.2 MB
|
|
|
05 - Form Design view.srt
|
SRT
|
17 KB
|
|
|
05 - Group and sort records.mp4
|
MP4
|
21 MB
|
|
|
05 - Group and sort records.srt
|
SRT
|
13 KB
|
|
|
05 - Specifying criteria with wildcards.mp4
|
MP4
|
9.8 MB
|
|
|
05 - Specifying criteria with wildcards.srt
|
SRT
|
8.4 KB
|
|
|
05 - The database Navigation Pane.mp4
|
MP4
|
7.5 MB
|
|
|
05 - The database Navigation Pane.srt
|
SRT
|
7.3 KB
|
|
|
05 - The role of primary and foreign keys.mp4
|
MP4
|
8 MB
|
|
|
05 - The role of primary and foreign keys.srt
|
SRT
|
7.6 KB
|
|
|
06 - Creating calculated totals.mp4
|
MP4
|
9.6 MB
|
|
|
06 - Creating calculated totals.srt
|
SRT
|
6.5 KB
|
|
|
06 - Data lookup fields.mp4
|
MP4
|
8.2 MB
|
|
|
06 - Data lookup fields.srt
|
SRT
|
7.5 KB
|
|
|
06 - Document your thought process.mp4
|
MP4
|
9.7 MB
|
|
|
06 - Document your thought process.srt
|
SRT
|
7.5 KB
|
|
|
06 - Find records.mp4
|
MP4
|
15 MB
|
|
|
06 - Find records.srt
|
SRT
|
10.7 KB
|
|
|
06 - Incorporating AND and OR statements.mp4
|
MP4
|
16.4 MB
|
|
|
06 - Incorporating AND and OR statements.srt
|
SRT
|
11.6 KB
|
|
|
06 - Relating tables together with key fields.mp4
|
MP4
|
14.5 MB
|
|
|
06 - Relating tables together with key fields.srt
|
SRT
|
12.9 KB
|
|
|
07 - Additional field properties.mp4
|
MP4
|
14 MB
|
|
|
07 - Additional field properties.srt
|
SRT
|
11.8 KB
|
|
|
07 - Apply conditional formatting rules.mp4
|
MP4
|
19.8 MB
|
|
|
07 - Apply conditional formatting rules.srt
|
SRT
|
13.7 KB
|
|
|
07 - Filtering with mathematical comparisons.mp4
|
MP4
|
6.1 MB
|
|
|
07 - Filtering with mathematical comparisons.srt
|
SRT
|
4.9 KB
|
|
|
07 - Importing tables.mp4
|
MP4
|
15.7 MB
|
|
|
07 - Importing tables.srt
|
SRT
|
13.4 KB
|
|
|
07 - Print the blueprint of your database.mp4
|
MP4
|
6.6 MB
|
|
|
07 - Print the blueprint of your database.srt
|
SRT
|
5.1 KB
|
|
|
08 - Adjust print settings.mp4
|
MP4
|
9.1 MB
|
|
|
08 - Adjust print settings.srt
|
SRT
|
8 KB
|
|
|
08 - Create flexible queries with parameters.mp4
|
MP4
|
14.1 MB
|
|
|
08 - Create flexible queries with parameters.srt
|
SRT
|
9.6 KB
|
|
|
08 - Split a database into front and back ends.mp4
|
MP4
|
11 MB
|
|
|
08 - Split a database into front and back ends.srt
|
SRT
|
9 KB
|
|
|
09 - Build expressions.mp4
|
MP4
|
15 MB
|
|
|
09 - Build expressions.srt
|
SRT
|
11.7 KB
|
|
|
09 - Protect the database with a password.mp4
|
MP4
|
7.7 MB
|
|
|
09 - Protect the database with a password.srt
|
SRT
|
6.2 KB
|
|
|
10 - Obtain summary statistics.mp4
|
MP4
|
18.6 MB
|
|
|
10 - Obtain summary statistics.srt
|
SRT
|
14.4 KB
|
|
|
10 - Set startup options.mp4
|
MP4
|
10.4 MB
|
|
|
10 - Set startup options.srt
|
SRT
|
8.5 KB
|
|
|
11 - Introducing the SQL query language.mp4
|
MP4
|
9.7 MB
|
|
|
11 - Introducing the SQL query language.srt
|
SRT
|
7.9 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
CustomerPhoneNumbers.xlsx
|
XLSX
|
81.3 KB
|
|
|
Customers.xlsx
|
XLSX
|
144 KB
|
|
|
Employees.xlsx
|
XLSX
|
14.4 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Orders.xlsx
|
XLSX
|
109.3 KB
|
|
|
ProductCategory.xlsx
|
XLSX
|
8.7 KB
|
|
|
Products.xlsx
|
XLSX
|
12.3 KB
|
|
|
States.xlsx
|
XLSX
|
9.5 KB
|
|
|
Two Trees Olive Oil Logo.jpg
|
JPG
|
63.4 KB
|
|
|
Two Trees Wordmark.jpg
|
JPG
|
66.9 KB
|
|
|
TwoTrees-Backup.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Blueprint.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Calculations.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Chapter2-Complete.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Chapter3-Complete.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Chapter4-Complete.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Chapter5-Complete.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-Chapter6-Complete.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Chapter7-Complete.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Chapter8-Complete.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Chapter9-Complete.accdb
|
ACCDB
|
2 MB
|
|
|
TwoTrees-Compact.accdb
|
ACCDB
|
2.4 MB
|
|
|
TwoTrees-Comparison.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-Conditional.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Criteria.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-DefaultValue.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Deleting.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Dependencies.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Documentation.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Embedded.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-EnterData.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Expressions.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-FieldProperties.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Filtering.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-FindRecords.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-FormDesign.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-FormWizard.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-GenerateForms.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-GroupSort.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Groups.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Import.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Keys.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-LayoutView.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-Lookup.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Macros.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Masks.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-MultipleCriteria.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-Navigation.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Parameters.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-Password.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Printing.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-QueryDesign.accdb
|
ACCDB
|
1.5 MB
|
|
|
TwoTrees-QueryWizard.accdb
|
ACCDB
|
1.4 MB
|
|
|
TwoTrees-Relationships.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-ReportDesign.accdb
|
ACCDB
|
2.2 MB
|
|
|
TwoTrees-ReportLayout.accdb
|
ACCDB
|
2.2 MB
|
|
|
TwoTrees-ReportWizard.accdb
|
ACCDB
|
2.2 MB
|
|
|
TwoTrees-Reports.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Ribbon.accdb
|
ACCDB
|
340 KB
|
|
|
TwoTrees-SQL.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-Sorting.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Split.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Startup.accdb
|
ACCDB
|
1.9 MB
|
|
|
TwoTrees-Statistics.accdb
|
ACCDB
|
1.8 MB
|
|
|
TwoTrees-TableDesign.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Tables.accdb
|
ACCDB
|
340 KB
|
|
|
TwoTrees-Toolbar.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-TrustCenter.accdb
|
ACCDB
|
368 KB
|
|
|
TwoTrees-VBA.accdb
|
ACCDB
|
2.3 MB
|
|
|
TwoTrees-Validation.accdb
|
ACCDB
|
972 KB
|
|
|
TwoTrees-Wildcards.accdb
|
ACCDB
|
1.8 MB
|
|
|
vba_script.txt
|
TXT
|
409.6 B
|
