Access tutorials Access Office 365 Essential Training 36904 | CCC102D34BADEA61D6C28317212E3D3B245B6306

Access tutorials Access Office 365 Essential Training 36904

Name	Access-tutorials_Access-Office-365-Essential-Training_36904	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	96
Hash	CCC102D34BADEA61D6C28317212E3D3B245B6306

/
001 Welcome.mp4	7.6 MB
002 Using the exercise files.mp4	1.5 MB
003 Challenges explained.mp4	948.9 KB
004 Key database concepts.mp4	10.8 MB
005 Launching Access and the backstage screen.mp4	1.7 MB
006 Creating the database file.mp4	8.0 MB
007 Understanding the Trust Center.mp4	8.5 MB
008 Digging into Ribbon tabs.mp4	11.5 MB
009 Using the Navigation pane.mp4	11.7 MB
010 Using the Tell Me feature.mp4	4.5 MB
011 Using the Quick Access Toolbar.mp4	8.4 MB
012 Signing in to a Microsoft account.mp4	4.1 MB
013 Making backups.mp4	5.4 MB
014 Accessing Access help.mp4	6.8 MB
015 Understanding table structure and relationships.mp4	10.2 MB
016 Creating a table and setting data types.mp4	12.7 MB
017 Entering data.mp4	11.2 MB
018 Understanding primary and foreign keys.mp4	13.3 MB
019 Importing tables.mp4	15.5 MB
020 Establishing relationships and maintaining referential integrity.mp4	15.9 MB
021 Editing table structure in Design view.mp4	11.7 MB
022 Controlling input with masks.mp4	17.0 MB
023 Setting the default value.mp4	7.0 MB
024 Establishing validation rules.mp4	10.4 MB
025 Creating lookup fields.mp4	10.4 MB
026 Setting additional field properties.mp4	12.8 MB
027 Challenge - Creating tables.mp4	1.9 MB
028 Solution - Creating tables.mp4	12.8 MB
029 Formatting columns.mp4	12.8 MB
030 Sorting table data.mp4	12.9 MB
031 Filtering table data.mp4	11.0 MB
032 Searching and replacing values.mp4	17.4 MB
033 Searching and replacing values.mp4	7.9 MB
034 Creating queries with the Simple Query Wizard.mp4	10.4 MB
035 Building queries in Design view.mp4	24.3 MB
036 Establishing constraints with criteria.mp4	15.3 MB
037 Specifying criteria with wildcards.mp4	11.4 MB
038 Leveraging multiple criteria with AND and OR statements.mp4	17.2 MB
039 Filtering with mathematical comparisons.mp4	10.1 MB
040 Creating flexible queries with parameter requests.mp4	13.3 MB
041 Building expressions.mp4	20.4 MB
042 Obtaining summary statistics.mp4	18.8 MB
043 Challenge - Creating queries.mp4	1.7 MB
044 Solution - Creating queries.mp4	10.4 MB
045 Using update queries.mp4	19.5 MB
046 Using make table queries.mp4	9.6 MB
047 Finding unmatched records.mp4	11.1 MB
048 Using delete queries.mp4	10.8 MB
049 Using append queries.mp4	9.9 MB
050 Creating a union query in SQL view.mp4	13.8 MB
051 Getting a different look with crosstab queries.mp4	8.5 MB
052 Understanding the role of forms.mp4	5.3 MB
053 Generating forms from tables.mp4	12.6 MB
054 Adjusting form elements in Layout view.mp4	13.1 MB
055 Using the Form Wizard.mp4	11.2 MB
056 Creating forms in Design view.mp4	15.1 MB
057 Exploring the form property sheet.mp4	18.3 MB
058 Setting data sources.mp4	19.1 MB
059 Adding components with form controls.mp4	38.7 MB
060 Understanding input boxes.mp4	16.5 MB
061 Record navigation.mp4	13.0 MB
062 Adding buttons.mp4	14.4 MB
063 Assigning a tab order.mp4	15.0 MB
064 Checking out the More Forms options.mp4	15.6 MB
065 Creating a navigation form.mp4	12.7 MB
066 Challenge - Creating forms.mp4	1.7 MB
067 Solution - Creating forms.mp4	15.6 MB
068 Introducing reports.mp4	11.8 MB
069 Using the Report Wizard.mp4	11.8 MB
070 Creating a report in Design view.mp4	13.8 MB
071 Editing a report in Layout view.mp4	18.8 MB
072 Grouping and sorting records.mp4	21.0 MB
073 Creating calculated totals.mp4	11.1 MB
074 Applying conditional formatting rules.mp4	20.2 MB
075 Creating labels.mp4	13.9 MB
076 Adjusting print settings.mp4	9.8 MB
077 Challenge - Creating reports.mp4	1.5 MB
078 Solution - Creating reports.mp4	15.3 MB
079 Creating macros.mp4	16.2 MB
080 Embedding macros into buttons.mp4	13.4 MB
081 Attaching data macros to tables.mp4	17.8 MB
082 Launching macros at startup.mp4	6.8 MB
083 Exporting tables to Excel.mp4	9.5 MB
084 Emailing with macros.mp4	11.7 MB
085 Linking to data in an Outlook database.mp4	6.2 MB
086 Setting up labels and mail merge documents in Word.mp4	12.3 MB
087 Organizing the navigation pane with custom groups.mp4	8.9 MB
088 Compacting and repairing the database.mp4	3.0 MB
089 Examining database object dependencies.mp4	7.0 MB
090 Documenting your work.mp4	12.1 MB
091 Printing the blueprint of your database with the Database Documenter.mp4	7.4 MB
092 Splitting a database into front and back ends.mp4	10.2 MB
093 Protecting the database with a password.mp4	8.9 MB
094 Creating custom Ribbon tabs.mp4	8.9 MB
095 Setting startup options and custom icons.mp4	10.9 MB
096 Next steps.mp4	2.8 MB
Total files 96