Microsoft Access course
Course Contents
Remember, you can complete this Microsoft Access course within 12 months of enrolling. So take your first step by contacting us today !
Detailed Content
- The Database Terminology of Access
- Relational Databases
- Access Database Objects
- A Five-Step Design Method
- The Access Welcome Screen
- How to Create a Blank Desktop Database
- The Access Interface
- Table Types
- Creating a New Table
- Creating tblCustomers
- Changing a Table Design
- Understanding tblCustomers Field Properties
- Setting the Primary Key
- Indexing Access Tables
- Printing a Table Design
- Saving the Completed Table
- Manipulating Tables
- Adding Records to a Database Table
- Understanding Attachment Fields
- Building Bulletproof Databases
- Data Normalization and Denormalization
- Table Relationships
- Integrity Rules
- Keys
- Understanding Datasheets
- Looking at the Datasheet Window
- Opening a Datasheet
- Entering New Data
- Navigating Records in a Datasheet
- Changing Values in a Datasheet
- Using the Undo Feature
- Copying and Pasting Values
- Replacing Values
- Adding New Records
- Deleting Records
- Displaying Records
- Sorting and Filtering Records in a Datasheet
- Aggregating Data
- Printing Records
- How Access Works with External Data
- Options for Importing and Exporting
- How to Import External Data
- How to Export to External Formats
- Linking External Data
- Working with Linked Tables
- Splitting a Database
- Introducing Queries
- Creating a Query
- Working with Query Fields
- Adding Criteria to Your Queries
- Printing a Query's Recordset
- Saving a Query
- Creating Multi-Table Queries
- Working with the Table Pane
- Creating and Working with Query Joins
- Introducing Operators
- Using Operators and Expressions in Queries
- Entering Single-Value Field Criteria
- Using Multiple Criteria in a Query
- Entering Criteria in Multiple Fields
- Aggregate Queries
- Action Queries
- Crosstab Queries
- Finding and Removing Duplicate Records
- Common Transformation Tasks
- Using Calculations in Your Analyses
- Using Dates in Your Analyses
- Using Parameter Queries
- Using Conditional Functions
- Understanding Basic SQL
- Getting Fancy with Advanced SQL Statements
- Using SQL Specific Queries
- Enhancing Your Analyses with Subqueries
- Domain Aggregate Functions
- Basic Descriptive Statistics
- Advanced Descriptive Statistics
- Formulating Forms
- Working with Controls
- Introducing Properties
- Using Form View
- Changing Values in a Form
- Printing a Form
- Working with Form Properties
- Adding a Form Header or Footer
- Working with Section Properties
- Changing the Layout
- Converting a Form to a Report
- Setting Control Properties
- Creating a Calculated Control
- Working with Subforms
- Form Design Tips
- Tackling Advanced Forms Techniques
- Using the Tab Control
- Using Dialog Boxes to Collect Information
- Designing a Form from Scratch
- Introducing Reports
- Creating a Report, from Beginning to End
- Banded Report Design Concepts
- Creating a Report from Scratch
- Improving the Report's Appearance
- Grouping and Sorting Data
- Formatting Data
- Adding Data
- Trying More Techniques
- An Introduction to Macros
- Understanding Macro Security
- Multi-Action Macros
- Submacros
- Conditions
- Temporary Variables
- Error Handling and Macro Debugging
- Embedded Macros
- Macros versus VBA Statements
- Introducing Visual Basic for Applications
- Understanding VBA Terminology
- Starting with VBA Code Basics
- Creating VBA Programs
- Understanding VBA Branching Constructs
- Working with Objects and Collections
- Exploring the Visual Basic Editor
- Using Variables
- Working with Data Types
- Understanding Subs and Functions
- Creating Functions
- Simplifying Code with Named Arguments
- Programming Events
- Identifying Common Events
- Paying Attention to Event Sequence
- Organizing VBA Code
- Testing Your Applications
- Traditional Debugging Techniques
- Using the Access Debugging Tools
- Trapping Errors in Your Code
- Working with Data
- Understanding ADO Objects
- Understanding DAO Objects
- Writing VBA Code to Update a Table
- Adding an Unbound Combo Box to a Form to Find Data
- Filtering a Form
- Introducing SQL Server Express
- Understanding Data Types in SQL Server
- Installing SQL Server Express
- Connecting to SQL Server
- Working with SQL Server Objects
- The Ribbon Hierarchy
- Editing the Default Ribbon
- Working with the Quick Access Toolbar
- Developing Custom Ribbons
- Creating a Custom Ribbon
- The Basic Ribbon XML
- Adding Ribbon Controls
- Attaching Ribbons to Forms and Reports
- Completely Removing the Ribbon
- Defining the Current Database Options
- Developing the Application
- Polishing Your Application
- Bulletproofing an Application
- Securing the Environment
- Introducing SharePoint
- Reviewing Various Types of SharePoint Sites
- Looking at a SharePoint Website
- The Concept Behind Access and SharePoint Integration
- Sharing Access Data with SharePoint
- Using SharePoint Templates
- Explaining Managed Applications
- Looking at Web Publishing in Access
- Understanding Access Services
- Examining Access Web Application Limits
- Publishing a Custom Access Application to SharePoint
- Introducing Data Macros
- Understanding Table Events
- Using the Macro Designer for Data Macros
- Understanding the Action Catalog
- Creating Your First Data Macro
- Managing Macro Objects
- Recognizing the Limitations of Data Macros
