VBA for Access

Technology Intellect
Cairns, QLD, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course assumes a reasonable level of database programming and/or VB or SQL programming principles design principles. To give delegates a firm grounding in the principles and procedures of Access database programming.

Course Contents

Events

Events and Event Properties
Running an event procedure for an event on a form, report or control
Finding out when events occur
Order of events for controls on forms
Order of events for records on forms
Order of events for forms and subforms
Order of events for keystrokes and mouse clicks
Order of events for reports and report sections
Events used for data validation
Order of validation for controls and fields
Setting the value of a control or property in response to an event

Reports

Creating mailing and other types of labels
Creating mailing and other types of labels for a dot-matrix printer
Sorting records in a report
Grouping records in a report
Changing sorting and grouping order in a report
Inserting an additional sorting or grouping field or expression in a report
Deleting a sorting or grouping field or expression in a report
Keeping the data in a group together on a page or in a column in a report
Starting each group in a report in a new row or column
Resetting page numbers for each group in a report
Repeating a group header on another page or column
Hiding duplicate data in a report
Calculating a total for one record in a report
Calculating a total or average for a group of or all records in a report
Calculating a running sum in a report
Calculating percentages in a report
Computing a total for a calculated control on a report
Numbering each detail record in a report
Counting the number of records in a report as a whole
Counting the number of records in each group in a report
Combining text values from multiple fields on a report
Combining text values from fields when some fields contain no data
Printing the first few characters of a value as a group header in a report

Reports - Part II

Subreports
Creating a subreport in an existing report
Adding an existing report to another existing report to create a subreport
How a main report and subreport are linked
Linking a main report and a subreport
Creating a multiple-column report
Creating a crosstab report with fixed-column headings

Controls

Tab Control
Creating a form with multiple pages or tabs
Properties you can use to customize a tab control
Toggle button
PivotTable Form
Editing a PivotTable Form
Updating the data in a PivotTable Form
Macros

Macros
Creating Macros
Opening a Macro
Adding an action to a Macro
Opening the Macro or Module windows from a form or report
Creating a Macro
Creating a Macro Group
Setting action arguments in a macro
Entering an expression in a macro action argument
Using conditions in a macro
Running a macro
Running a macro from another macro or from a Visual Basic procedure
Data Access Pages

Data Access Pages
Creating a data access page by using AutoPage
Creating a data access page by using a Wizard
Making an existing Web page into a data access page
Form vs report vs report snapshot vs data access page
Strategies for creating data access pages
Grouping records on a data access page
Connecting a data access page or other Web page to a database
Types of data sources for a data access page
Types of data sources for Microsoft Office Web components on a data access page
Opening a page in Design view or Page view
Switching between views of a data access page
Adding data to a data access page by using the field list
Refreshing a data access page’s field list to display new tables or queries
Defining a new relationship between record sources in a data access page
Selecting a data access page, section, control or other element
Setting document properties such as title, subject, and author for a data access page
Setting properties for a data access page, section or control
Calculating a total or other value for one record on a data access page used for data entry
Calculating a total or other value for one record on a grouped data access page
Calculating a total, average or other aggregate for a group of records in a data access page
Calculating a grand total or other aggregate for all records on a data access page
Themes
Choosing a default theme for new data access pages
Importing and Linking Data

Exporting data and database objects to another database or file format
Importing and linking data and importing database objects
Reasons to import data into a table
Reasons to link data from an external table
ODBC data sources
Differences between ODBC drivers and built-in drivers for external data
Import/export specifications and Schema.ini files
Exporting database objects to an existing MS Access database or MS Access Project
Exporting a datasheet to a delimited or fixed-width text file
Exporting a datasheet to a spreadsheet file
Exporting a table or query to a Microsoft Word mail merge data source file
Exporting a table or query to a Paradox or dBASE file
Exporting a table or query to an SQL database table or other ODBC data source
Loading the output of a datasheet, form or report into MS Excel
Loading the output of a datasheet, form or report into MS Word
Saving an object’s output as a MS Excel or Rich Text Format file
Merging data from a table or query by using the Microsoft Word Mail Merge Wizard
Exporting a report to static HTML format
Importing database objects from another MS Access database or MS Access Project
Importing or linking tables from another MS Access database or MS Access Project
Importing a Microsoft Works database
Importing or linking a delimited or fixed-width text file
Importing or linking data from a spreadsheet
Importing or linking data from Microsoft Outlook or Microsoft Exchange
Importing or linking dBase files
Setting up ODBC data sources
Sharing an MS Access database on a Network

Sharing an Access database on a network
Editing data in an Access database in a multiuser environment
Saving design changes to a shared MS Access database
Choosing a record-locking strategy in an Access database in a multiuser environment
Optimizing multiuser performance in an Access database
Sharing an Access database on a network server
Sharing an Access database when a network server does’nt exist
Splitting an existing Access database between its data and its objects
Specifying whether an Access database opens in shared or exclusive mode by default
Specifying whether an Access database opens in shared or exclusive Editing Access database objects in a multiuser environment
Specifying the default record-locking strategy used in a multiuser environment in an Access database
Specifying the locking level used in an Access database in a multiuser environment
Avoiding data-locking conflicts in an Access database in a multiuser environment
Specifying multiuser/ODBC update retry and refresh interval settings in an Access database
Displaying the most current data in an Access database in Datasheet or Form view
Changing how often data is updated automatically in an Access database in Datasheet or Form view
Data Access Objects (DAO)

DAO - Data Access Objects
Capabilities with ODBCDirect
Data Access Objects Overview
Using the Microsoft Jet Workspace
Using the ODBCDirect Object Model
Data Access Objects and Collections
ActiveX Data Objects

ADO Programming Model
Connection
Command
Parameter ...''

Phone:+61 7 4057 7891

School Address:

Suite 46 Campus Shopping Village, Smithfield, Cairns, Australia.

Jobs & Resumes: Cairns
Houses & Roommates: Cairns

Publisher Level 2
Publisher Level 1
Project Level 2
MYOB
MYOB payroll
SQL Server
SQL Database Programming
Photoshop
ASP.NET 2.0
Visual Basic.NET
VBA for Excel
VBA for Word

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.