Courses / Access Intermediate
Access Intermediate
- Provider
- Corazon Training
- Summary
- 1 day course covering all aspects of database entry and operation.
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 is necessary
- 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
- Website
- www.corazonit.com
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
Venues/Contact
Main (View map)
146 Woodbridge Road
IPSWICH
Suffolk
IP4 2NS
UNITED KINGDOM
Telephone 01473 219593 m: 07702911223
Fax 01473 219593
Email info@corazonit.com
Website http://www.corazonIT.com
Venue Notes At Client's site:
Contact Elene Marsden
Courses
Syndicate
