|
Provided by: Last Minute Training Access Advanced - Level 3Access |
 |
Training
Provided by Last Minute Training
This course provides competency in designing applications, using advanced tools and controls, creating dialog boxes, using macros, controlling data entry, using dialog boxes to filter records in reports, creating custom switchboards, enhancing applications, using database utilities, and tailoring applications for multiple users.
|
|
||||||||||
Access Advanced - Level 3
Unit 1 : PivotTables and PivotCharts
Topic A: 0 Creating PivotTables
A-1: Examining PivotTable view
A-2: Adding fields to a PivotTable
Topic B: 0 Modifying PivotTables
B-1: Creating totals
B-2: Moving fields in a PivotTable
B-3: Showing and hiding detail in a PivotTable
B-4: Formatting fields
Topic C: 0 Working with PivotCharts
C-1: Creating a PivotChart
Unit 2 : Creating advanced forms
Topic A: 0 Building a form based on joined tables
A-1: Creating a form to display data from two tables
A-2: Modifying a query to display all fields on a form
Topic B: 0 Automating data entry
B-1: Using the Date function
B-2: Using the DateAdd function
Topic C: 0 Using grouped controls
C-1: Creating and using grouped controls
C-2: Adding an option group control to a form
C-3: Modifying the option group control
Topic D: 0 Improving the user interface
D-1: Adding a tab control to a form
D-2: Setting form properties to prevent all modifications
D-3: Creating a Startup form
D-4: Creating a Switchboard form
Topic E: 0 Creating Subforms
E-1: Examining and using a subform
E-2: Creating a subform
Unit 3 : Creating macros
Topic A: 0 Creating and running macros
A-1: Examining and running a macro
A-2: Creating and running a macro to open a table
A-3: Modifying a macro to add an action
Topic B: 0 Attaching macros to events of database objects
B-1: Attaching a macro to the open event of a form
B-2: Attaching a macro to a command button
B-3: Using a macro to resize and move a form s window
Unit 4 : Creating advanced macros
Topic A: 0 Creating macros to provide user interaction
A-1: Creating a data validation macro
A-2: Creating a data-entry macro
Topic B: 0 Creating macros that require user decision
B-1: Creating a user-decision macro
Topic C: 0 Using AutoKeys and AutoExec macros
C-1: Creating an AutoKeys macro
C-2: Creating an AutoExec macro
Unit 5 : Exploring Access SQL
Topic A: 0 Identify different clauses in an SQL statement
A-1: Discussing Structured Query Language
A-2: Examining an SQL statement in Access
Topic B: 0 Writing SQL statements
B-1: Writing an SQL SELECT statement
B-2: Using the WHERE clause
B-3: Creating a query to display matching data from related tables
B-4: Using an SQL statement to find unmatched records
Topic C: 0 Attaching an SQL statement to database objects
C-1: Assigning an SQL statement to a command button
Unit 6 : Internet integration
Topic A: 0 Working with hyperlink fields
A-1: Creating a hyperlink field
A-2: Using a hyperlink field to enter data
A-3: Modifying data in a hyperlink field
Topic B: 0 Working with data access pages
B-1: Creating and using a data access page
B-2: Creating a grouped data access page based on multiple tables
B-3: Saving database objects as data access pages
B-4: Creating a PivotTable and a PivotChart on a data access page
Unit 7 : Managing databases
Topic A: 0 Working with database utilities to optimize resources
A-1: Converting a database to a prior version
A-2: Analyzing performance
A-3: Splitting a database
A-4: Protecting a split database from modification
A-5: Compacting and repairing a database
Topic B: 0 Securing data by database replication
B-1: Replicating a database
B-2: Synchronizing replicated databases
Topic C: 0 Encrypting and decrypting databases
C-1: Encrypting a database
C-2: Decrypting a database
Unit 8 : Security fundamentals
Topic A: 0 Protecting databases
A-1: Assigning a password to a database
A-2: Removing a password
Topic B: 0 User-level security
B-1: Providing security by using Security Wizard
B-2: Creating a new user group
B-3: Specifying permissions on database objects
Appendix A : Discussing modules and MDE files
Topic A: 0 Understanding modules
A-1: Discussing modules and VBA
Topic B: 0 Understanding MDE files
B-1: Discussing MDE files
Appendix B : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
Topic A: 0 Creating PivotTables
A-1: Examining PivotTable view
A-2: Adding fields to a PivotTable
Topic B: 0 Modifying PivotTables
B-1: Creating totals
B-2: Moving fields in a PivotTable
B-3: Showing and hiding detail in a PivotTable
B-4: Formatting fields
Topic C: 0 Working with PivotCharts
C-1: Creating a PivotChart
Unit 2 : Creating advanced forms
Topic A: 0 Building a form based on joined tables
A-1: Creating a form to display data from two tables
A-2: Modifying a query to display all fields on a form
Topic B: 0 Automating data entry
B-1: Using the Date function
B-2: Using the DateAdd function
Topic C: 0 Using grouped controls
C-1: Creating and using grouped controls
C-2: Adding an option group control to a form
C-3: Modifying the option group control
Topic D: 0 Improving the user interface
D-1: Adding a tab control to a form
D-2: Setting form properties to prevent all modifications
D-3: Creating a Startup form
D-4: Creating a Switchboard form
Topic E: 0 Creating Subforms
E-1: Examining and using a subform
E-2: Creating a subform
Unit 3 : Creating macros
Topic A: 0 Creating and running macros
A-1: Examining and running a macro
A-2: Creating and running a macro to open a table
A-3: Modifying a macro to add an action
Topic B: 0 Attaching macros to events of database objects
B-1: Attaching a macro to the open event of a form
B-2: Attaching a macro to a command button
B-3: Using a macro to resize and move a form s window
Unit 4 : Creating advanced macros
Topic A: 0 Creating macros to provide user interaction
A-1: Creating a data validation macro
A-2: Creating a data-entry macro
Topic B: 0 Creating macros that require user decision
B-1: Creating a user-decision macro
Topic C: 0 Using AutoKeys and AutoExec macros
C-1: Creating an AutoKeys macro
C-2: Creating an AutoExec macro
Unit 5 : Exploring Access SQL
Topic A: 0 Identify different clauses in an SQL statement
A-1: Discussing Structured Query Language
A-2: Examining an SQL statement in Access
Topic B: 0 Writing SQL statements
B-1: Writing an SQL SELECT statement
B-2: Using the WHERE clause
B-3: Creating a query to display matching data from related tables
B-4: Using an SQL statement to find unmatched records
Topic C: 0 Attaching an SQL statement to database objects
C-1: Assigning an SQL statement to a command button
Unit 6 : Internet integration
Topic A: 0 Working with hyperlink fields
A-1: Creating a hyperlink field
A-2: Using a hyperlink field to enter data
A-3: Modifying data in a hyperlink field
Topic B: 0 Working with data access pages
B-1: Creating and using a data access page
B-2: Creating a grouped data access page based on multiple tables
B-3: Saving database objects as data access pages
B-4: Creating a PivotTable and a PivotChart on a data access page
Unit 7 : Managing databases
Topic A: 0 Working with database utilities to optimize resources
A-1: Converting a database to a prior version
A-2: Analyzing performance
A-3: Splitting a database
A-4: Protecting a split database from modification
A-5: Compacting and repairing a database
Topic B: 0 Securing data by database replication
B-1: Replicating a database
B-2: Synchronizing replicated databases
Topic C: 0 Encrypting and decrypting databases
C-1: Encrypting a database
C-2: Decrypting a database
Unit 8 : Security fundamentals
Topic A: 0 Protecting databases
A-1: Assigning a password to a database
A-2: Removing a password
Topic B: 0 User-level security
B-1: Providing security by using Security Wizard
B-2: Creating a new user group
B-3: Specifying permissions on database objects
Appendix A : Discussing modules and MDE files
Topic A: 0 Understanding modules
A-1: Discussing modules and VBA
Topic B: 0 Understanding MDE files
B-1: Discussing MDE files
Appendix B : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
