*Bundle and Save
This courseware title is also available in a Bundle
Our courseware is primarily purchased by five types of trainer; HR managers, corporate trainers, private training firms, educational institutions, or private consultants. The target audience varies on the instructor and the type of training required by a particular organization.
The students for this course are usually training staff or managers involved in training.
No previous experience or training in Access is required, though students should possess basic numeracy and literacy and ideally have a basic understanding of using computers and software applications, such as Microsoft Word.
The Courseware Company (established in the early 1990s and part of gtslearning) is the only European authorised reseller of Velsoft courseware materials and print licences. Velsoft offers fully customisable training materials, delivered online and fully supported with instructor resources and student study tools.
To get started, just open this 'Access 2007' training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered 'off-the-peg' and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.
Getting Started To begin, participants will learn the basics of Access: how to open and close it, how to use the Getting Started Window, how to set Trust Center options, and how to get help.
The New Interface Next, participants will closely examine the new interface, including the Quick Access Toolbar and each of the default tabs.
Creating a Database First, we will discuss some things to consider when planning your database. Then, we will begin to create a database (using blank databases and templates) by adding tables and records.
Doing More with your Database Next, participants will look at the basics of forms, queries, and reports, including how to sort and filter data, ways to view data, and how to print database objects.
Advanced File Tasks Participants will learn various file management tasks in this section, including how to use My Computer within Access and various ways to save and export their database. Participants will also learn how to link files, compact and repair a database, and back up a database.
Working with Tables This section will focus on Access' tables, including how to customize and format them and how to control and manage data entry.
Working with Forms Next, we will examine forms, including adding all types of controls, formatting the form and its controls, and formatting records.
Working with Reports This section will discuss reports, including ways to organize report data, formatting tools, and common tasks (such as adding a logo and page numbers).
Working with Queries This section will focus on creating and managing queries. Types of queries covered include basic, multiple table, make table, summary, parameter, crosstab, append, delete, and update.
Advanced Data Management Participants will learn how to establish referential integrity, how to manage table relationships, how to create and use switchboards, and how to create modal dialog boxes.
Advanced Form Tasks This section will examine subforms, limiting user access, customizing error messages, creating event procedures, and exporting the form. Participants will also learn how to create an RSS feed for Outlook, how to import Outlook contacts, and how to use SharePoint Server and other servers with Access.
Pivoting Data Participants will learn all about PivotTables and PivotCharts in this section.
Access and Windows Participants will learn how to use Office diagnostics and the Access Viewer. Participants will also receive an introduction to SQL.
Add-ons to Access This section will examine COM Add-Ins, Digital Signatures, Smart Tags, and Access options. Participants will also learn how to analyze performance, view object dependencies, replicate a database, and split a database.
Using Scripts in Access Participants will learn how to create and use macros and macro groups in this section.
Using Access to Collaborate This section will cover using SharePoint Server and Access.
SQL and Microsoft Access To complete the course, participants will learn about SQL, including basic SQL conventions and how to use the SELECT statement, subqueries, and SQL joins.
Want to deliver the best Business Skills or Computer Training courses to your students? The Courseware Company is the UK’s leading supplier of fully Customisable business skills courseware licences.
Content is available for many business disciplines as well as Microsoft Office, Adobe and many other training products. Essentially, we’ve packaged the classroom prep time into an affordable, effective product.
This course can be purchased individually or as part of the Microsoft Office 2007 Bundle. Also included in this bundle are: