Professional Training

Prerequisites

This course assumes a reasonable level of database programming and/or VB or SQL programming principles and database design principles.

COURSE OBJECTIVES

To give delegates a firm grounding in the principles and procedures of Access database programming.

1. Events

− Commonly used 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 and 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
− Setting values of controls and properties
− Display a message box
− Show or hide warning messages

2. Lab – Event Driven Programming

− Practice your skills

3. Reports

− Creating mailing and other types of labels
− Creating mailing and other types of labels for a dot-matrix printer
− Sorting and grouping records
− Changing sorting and grouping order
− Inserting an additional sorting or grouping field or expression
− Deleting a sorting or grouping field or expression
− Keeping the data in a group together on a page or in a column
− Starting each group in a report in a new row or column
− Resetting page numbers for each group
− Repeating a group header on another page or column
− Hiding duplicate data
− Calculating a total for one record
− Calculating a total or average for a group of or all records
− Calculating a running sum and percentages Computing a total for a calculated control
− Numbering each detail record
− Counting the number of records in a report as a whole and each group
− Combining text values from multiple fields
− 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

4. 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

5. Controls

− Tab Control
− Creating a form with multiple pages or tabs
− Properties you can use to customize a tab control
− Toggle button
− Pivot Charts & Pivot Tables
− Using the Chart Wizard

6. Macros

− Use Macros or Visual Basic
− Opening a Macro
− Adding an action to a Macro
− Opening the Macro or module windows from a form or report
− Creating a Macro and a Submacro
− Creating a Group
− Moving and deleting macros and their components
− Setting action arguments in a Macro
− Entering an expression in a Macro action argument
− Using conditions in a Macro
− The Action Catalog
− Running a Macro and a Submacro
− Creating a command button without using a wizard
− Customizing the Quick Action Toolbar
− Customizing the Ribbon
− Assign an action or set of actions to a key
− Carry out an action when the database first opens
− Running a Macro from another Macro or from a Visual Basic procedure
− Correcting a Macro by stepping through it

7. Integration with Windows SharePoint Services

− Windows SharePoint Services
− Access 2013 and Windows SharePoint Services
− Publishing a database and moving tables to a SharePoint site
− Creating a table using SharePoint
− Importing and linking to SharePoint data
− Working offline with SharePoint data
− Exporting data to SharePoint
− Moving data to a SharePoint site
− Publishing a database to a Document Management Server

8. 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 Access database or 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 an SQL database table or other ODBC data source
− Saving an object’s output as a Microsoft Excel or Rich Text Format file
− Merging data table or query data by using the Microsoft Word Mail Merge Wizard
− Exporting a report to static HTML format
− Importing database objects from another Access database or Access Project
− Linking tables from another Access database or 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
− Setting up ODBC data sources

9. Sharing an MS Access database on a Network

− Editing data in an Access database in a multiuser environment
− Saving design changes to a shared 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 doesn’t 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
− 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

10. Data Access Objects (DAO)

− Overview of Data Access Objects
− Using the Microsoft Jet Workspace
− Data Access Objects and Collections

11. Lab – Data Access Objects (DAO)

− Practice your skills

12. ActiveX Data Objects (ADO)

− ADO Programming Model
− Connection
− Command
− Parameter
− RecordSet
− Field
− Error
− Property
 Collection
 Events
 ADO Programming Model with Objects
 ADO Object Model Summary
 Solutions for Remote Data Access
 Basic RDS Programming Model
 RDS Programming Model
 RDS Programming Model with Objects
 RDS Object Model Summary
 ADO Features

13. Lab – ActiveX Data Objects (ADO)

− Practice your skills

14. Working on the Internet and Web with Microsoft Access 2013

− How Access 2013 works with the Web
− Hyperlinks
− Creating a Hyperlink field in a database table
− Inserting Hyperlink controls in forms and reports
− Insert a Hyperlink to a file or Web page
− Insert a Hyperlink to an object in the current database
− Insert a Hyperlink to an object in another database
− Insert a Hyperlink with an e-mail address
− Navigating Hyperlinks
− Using a Web Browser Control
− Exporting database objects to HTML file
− Importing or linking to an HTML file
− Viewing a Data Access Page

15. Lab – Access Modules

− Practice your skills