Download link
File List
-
001 Welcome.mp4 6.98 MB
002 Using the exercise files.mp4 1.41 MB
003 Challenges explained.mp4 926.69 KB
004 Key database concepts.mp4 10.3 MB
005 Launching Access and the backstage screen.mp4 1.59 MB
006 Creating the database file.mp4 7.59 MB
007 Understanding the Trust Center.mp4 8.08 MB
008 Digging into Ribbon tabs.mp4 10.93 MB
009 Using the Navigation pane.mp4 11.12 MB
010 Using the Tell Me feature.mp4 4.33 MB
011 Using the Quick Access Toolbar.mp4 8.02 MB
012 Signing in to a Microsoft account.mp4 3.91 MB
013 Making backups.mp4 5.19 MB
014 Accessing Access help.mp4 6.44 MB
015 Understanding table structure and relationships.mp4 9.69 MB
016 Creating a table and setting data types.mp4 12.08 MB
017 Entering data.mp4 10.69 MB
018 Understanding primary and foreign keys.mp4 12.72 MB
019 Importing tables.mp4 14.74 MB
020 Establishing relationships and maintaining referential integrity.mp4 15.14 MB
021 Editing table structure in Design view.mp4 11.19 MB
022 Controlling input with masks.mp4 16.2 MB
023 Setting the default value.mp4 6.71 MB
024 Establishing validation rules.mp4 9.87 MB
025 Creating lookup fields.mp4 9.88 MB
026 Setting additional field properties.mp4 12.23 MB
027 Challenge - Creating tables.mp4 1.8 MB
028 Solution - Creating tables.mp4 12.17 MB
029 Formatting columns.mp4 12.21 MB
030 Sorting table data.mp4 12.3 MB
031 Filtering table data.mp4 10.47 MB
032 Searching and replacing values.mp4 16.64 MB
033 Understanding queries.mp4 7.57 MB
034 Creating queries with the Simple Query Wizard.mp4 9.92 MB
035 Building queries in Design view.mp4 23.19 MB
036 Establishing constraints with criteria.mp4 14.62 MB
037 Specifying criteria with wildcards.mp4 10.9 MB
038 Leveraging multiple criteria with AND and OR statements.mp4 16.38 MB
039 Filtering with mathematical comparisons.mp4 9.64 MB
040 Creating flexible queries with parameter requests.mp4 12.67 MB
041 Building expressions.mp4 19.42 MB
042 Obtaining summary statistics.mp4 17.91 MB
043 Challenge - Creating queries.mp4 1.66 MB
044 Solution - Creating queries.mp4 9.92 MB
045 Using update queries.mp4 18.62 MB
046 Using make table queries.mp4 9.14 MB
047 Finding unmatched records.mp4 10.57 MB
048 Using delete queries.mp4 10.27 MB
049 Using append queries.mp4 9.42 MB
050 Creating a union query in SQL view.mp4 13.13 MB
051 Getting a different look with crosstab queries.mp4 8.13 MB
052 Understanding the role of forms.mp4 5.08 MB
053 Generating forms from tables.mp4 11.99 MB
054 Adjusting form elements in Layout view.mp4 12.49 MB
055 Using the Form Wizard.mp4 10.71 MB
056 Creating forms in Design view.mp4 14.43 MB
057 Exploring the form property sheet.mp4 17.46 MB
058 Setting data sources.mp4 18.24 MB
059 Adding components with form controls.mp4 36.93 MB
060 Understanding input boxes.mp4 15.72 MB
061 Record navigation.mp4 12.38 MB
062 Adding buttons.mp4 13.73 MB
063 Assigning a tab order.mp4 14.27 MB
064 Checking out the More Forms options.mp4 14.88 MB
065 Creating a navigation form.mp4 12.12 MB
066 Challenge - Creating forms.mp4 1.66 MB
067 Solution - Creating forms.mp4 14.91 MB
068 Introducing reports.mp4 11.24 MB
069 Using the Report Wizard.mp4 11.24 MB
070 Creating a report in Design view.mp4 13.12 MB
071 Editing a report in Layout view.mp4 17.96 MB
072 Grouping and sorting records.mp4 20.05 MB
073 Creating calculated totals.mp4 10.56 MB
074 Applying conditional formatting rules.mp4 19.22 MB
075 Creating labels.mp4 13.22 MB
076 Adjusting print settings.mp4 9.38 MB
077 Challenge - Creating reports.mp4 1.42 MB
078 Solution - Creating reports.mp4 14.6 MB
079 Creating macros.mp4 15.47 MB
080 Embedding macros into buttons.mp4 12.78 MB
081 Attaching data macros to tables.mp4 16.95 MB
082 Launching macros at startup.mp4 6.53 MB
083 Exporting tables to Excel.mp4 9.03 MB
084 Emailing with macros.mp4 11.12 MB
085 Linking to data in an Outlook database.mp4 5.9 MB
086 Setting up labels and mail merge documents in Word.mp4 11.72 MB
087 Organizing the Navigation pane with custom groups.mp4 8.52 MB
088 Compacting and repairing the database.mp4 2.87 MB
089 Examining database object dependencies.mp4 6.71 MB
090 Documenting your work.mp4 11.53 MB
091 Printing the blueprint of your database with the Database Documenter.mp4 7.03 MB
092 Splitting a database into front and back ends.mp4 9.74 MB
093 Protecting the database with a password.mp4 8.51 MB
094 Creating custom Ribbon tabs.mp4 8.45 MB
095 Setting startup options and custom icons.mp4 10.43 MB
096 Next steps.mp4 2.71 MB
Download Info
-
Tips
“Access-tutorials_Access-2016-Essential-Training_36706” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.