| | | 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_01-Key database concepts.mp4 | 10.3 MB |
| | | 02_02-Launching Access and the Backstage screen.mp4 | 1.59 MB |
| | | 02_03-Creating the database file.mp4 | 7.59 MB |
| | | 02_04-Understanding the Trust Center.mp4 | 8.08 MB |
| | | 02_05-Digging into Ribbon tabs.mp4 | 10.93 MB |
| | | 02_06-Using the Navigation pane.mp4 | 11.12 MB |
| | | 02_07-Using the Tell Me feature.mp4 | 4.33 MB |
| | | 02_08-Using the Quick Access Toolbar.mp4 | 8.02 MB |
| | | 02_09-Signing in to a Microsoft account.mp4 | 3.91 MB |
| | | 02_10-Making backups.mp4 | 5.19 MB |
| | | 02_11-Accessing Access help.mp4 | 6.44 MB |
| | | 03_01-Understanding table structure and relationships.mp4 | 9.69 MB |
| | | 03_02-Creating a table and setting data types.mp4 | 12.08 MB |
| | | 03_03-Entering data.mp4 | 10.69 MB |
| | | 03_04-Understanding primary and foreign keys.mp4 | 12.72 MB |
| | | 03_05-Importing tables.mp4 | 14.74 MB |
| | | 04_01-Establishing relationships and maintaining referential integrity.mp4 | 15.14 MB |
| | | 04_02-Editing table structure in Design view.mp4 | 11.19 MB |
| | | 04_03-Controlling input with masks.mp4 | 16.2 MB |
| | | 04_04-Setting the default value.mp4 | 6.71 MB |
| | | 04_05-Establishing validation rules.mp4 | 9.87 MB |
| | | 04_06-Creating lookup fields.mp4 | 9.88 MB |
| | | 04_07-Setting additional field properties.mp4 | 12.23 MB |
| | | 04_08-Challenge Creating tables.mp4 | 1.8 MB |
| | | 04_09-Solution Creating tables.mp4 | 12.17 MB |
| | | 05_01-Formatting columns.mp4 | 12.21 MB |
| | | 05_02-Sorting table data.mp4 | 12.3 MB |
| | | 05_03-Filtering table data.mp4 | 10.47 MB |
| | | 05_04-Searching and replacing values.mp4 | 16.64 MB |
| | | 06_01-Understanding queries.mp4 | 7.57 MB |
| | | 06_02-Creating queries with the Simple Query Wizard.mp4 | 9.92 MB |
| | | 06_03-Building queries in Design view.mp4 | 23.19 MB |
| | | 06_04-Establishing constraints with criteria.mp4 | 14.62 MB |
| | | 06_05-Specifying criteria with wildcards.mp4 | 10.9 MB |
| | | 06_06-Leveraging multiple criteria with AND and OR statements.mp4 | 16.38 MB |
| | | 06_07-Filtering with mathematical comparisons.mp4 | 9.64 MB |
| | | 06_08-Creating flexible queries with parameter requests.mp4 | 12.67 MB |
| | | 06_09-Building expressions.mp4 | 19.42 MB |
| | | 06_10-Obtaining summary statistics.mp4 | 17.91 MB |
| | | 07_01-Using update queries.mp4 | 18.62 MB |
| | | 07_02-Using make table queries.mp4 | 9.14 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_06-Creating a union query in SQL view.mp4 | 13.13 MB |
| | | 07_07-Getting a different look with crosstab queries.mp4 | 8.13 MB |
| | | 08_01-Understanding the role of forms.mp4 | 5.08 MB |
| | | 08_02-Generating forms from tables.mp4 | 11.99 MB |
| | | 08_03-Adjusting form elements in Layout view.mp4 | 12.49 MB |
| | | 08_04-Using the Form Wizard.mp4 | 10.71 MB |
| | | 09_01-Creating forms in Design view.mp4 | 14.43 MB |
| | | 09_02-Exploring the form property sheet.mp4 | 17.46 MB |
| | | 09_03-Setting data sources.mp4 | 18.24 MB |
| | | 09_04-Adding components with form controls.mp4 | 36.93 MB |
| | | 09_05-Understanding input boxes.mp4 | 15.72 MB |
| | | 09_06-Record navigation.mp4 | 12.38 MB |
| | | 09_07-Adding buttons.mp4 | 13.73 MB |
| | | 09_08-Assigning a tab order.mp4 | 14.27 MB |
| | | 09_09-Checking out the More Forms options.mp4 | 14.88 MB |
| | | 09_10-Creating a navigation form.mp4 | 12.12 MB |
| | | 10_01-Introducing reports.mp4 | 11.24 MB |
| | | 10_02-Using the Report Wizard.mp4 | 11.24 MB |
| | | 10_03-Creating a report in Design view.mp4 | 13.12 MB |
| | | 10_04-Editing a report in Layout view.mp4 | 17.96 MB |
| | | 10_05-Grouping and sorting records.mp4 | 20.05 MB |
| | | 10_06-Creating calculated totals.mp4 | 10.56 MB |
| | | 10_07-Applying conditional formatting rules.mp4 | 19.22 MB |
| | | 10_08-Creating labels.mp4 | 13.22 MB |
| | | 10_09-Adjusting print settings.mp4 | 9.38 MB |
| | | 10_10-Challenge Creating reports.mp4 | 1.42 MB |
| | | 10_11-Solution Creating reports.mp4 | 14.6 MB |
| | | 11_01-Creating macros.mp4 | 15.47 MB |
| | | 11_02-Embedding macros into buttons.mp4 | 12.78 MB |
| | | 11_03-Attaching data macros to tables.mp4 | 16.95 MB |
| | | 11_04-Launching macros at startup.mp4 | 6.53 MB |
| | | 12_01-Exporting tables to Excel.mp4 | 9.03 MB |
| | | 12_02-Emailing with macros.mp4 | 11.12 MB |
| | | 12_03-Linking to data in an Outlook database.mp4 | 5.9 MB |
| | | 12_04-Setting up labels and mail merge documents in Word.mp4 | 11.72 MB |
| | | 13_01-Organizing the Navigation pane with custom groups.mp4 | 8.52 MB |
| | | 13_02-Compacting and repairing the database.mp4 | 2.87 MB |
| | | 13_03-Examining database object dependencies.mp4 | 6.71 MB |
| | | 13_04-Documenting your work.mp4 | 11.53 MB |
| | | 13_05-Printing the blueprint of your database with the Database Documenter.mp4 | 7.03 MB |
| | | 13_06-Splitting a database into front and back ends.mp4 | 9.74 MB |
| | | 13_07-Protecting the database with a password.mp4 | 8.51 MB |
| | | 13_08-Creating custom Ribbon tabs.mp4 | 8.45 MB |
| | | 13_09-Setting startup options and custom icons.mp4 | 10.43 MB |
| | | 14_01-Next steps.mp4 | 2.71 MB |
All Comments