Courses / Access Intermediate

Access Intermediate

Provider: Corazon Training
Summary: 1 day course covering all aspects of database entry and operation.

Generic logo

About the Course

Target: Those who have a basic understanding of Microsoft's database application, Access.
Entry requirements: A good knowledge of working in the Windows environment would be useful.
Outcome: Participants will increase their knowledge of Access
Content: Tables � Primary and Foreign Keys � Relationships � Validation Rules and Validation Text � Using Field Properties for Protection. � Input Mask � Lookups; Using Lookups for Referential Integrity � Using indexes � Multi-table Datasheet View � Creating and Editing Relationships � Checking Referential Integrity � Required, Default Value field properties � Adding Hyperlinks to Datasheet Views. Forms � Form Sections � The toolbox; bound and unbound controls � Form Control layout � Control Wizards � Control Properties � Multiple Table Forms Queries � Multi-table Queries: � The Expression Builder. � Cross tab Queries � General Query Properties � Adding a Calculated Field to a Query � Calculated and Concatenated Fields � Parameter queries Reports � Report Sections � Report Controls � Report Control Layout � Calculating Summary Information � Sorting and Grouping Data Additional Database Features � Importing from Other Data Sources. � Importing Data Using Drag-and-Drop � Backing Up and Restoring a Database. � Compacting and Repairing a Database � Publishing Datasheet Views on the Internet � Adding Hyperlinks to HTML Pages � Creating a Switchboard Macros � Create simple macros � Running macros � Add macros to a toolbar � Use keyboard shortcuts to run macros � Adding a Calculated Field to a Query � Calculated and Concatenated Fields � Parameter queries Reports � Report Sections � Report Controls � Report Control Layout � Calculating Summary Information � Sorting and Grouping Data Additional Database Features � Importing from Other Data Sources. � Importing Data Using Drag-and-Drop � Backing Up and Restoring a Database. � Compacting and Repairing a Database � Publishing Datasheet Views on the Internet � Adding Hyperlinks to HTML Pages � Creating a Switchboard Macros � Create simple macros � Running macros � Add macros to a toolbar � Use keyboard shortcuts to run macros Course outlines are for guidance only as training is provided on a consultancy basis to ensure relevant work related topics are covered.
Cost: Training rates are available on request
Enrolment: .

Availability

Starts: All training is delivered on clients site and can be either one to one or in groups.
Duration: 1 day course
Timetable: By mutual agreement
Provider: Corazon Training