Courses / Microsoft Access Introduction
Microsoft Access Introduction
- Provider
- Abal Computer Services
- Summary
- This is an intensive 2-day tutor led course with emphasis on hands-on practical exercises. You will need to have keyboard and mouse skills together with an understanding of Windows.
Some knowledge of Word and Excel would be useful but is not essential. You will gain confidence in the use of features, such as creating and modifying tables, setting up relationships, designing forms, making queries and printing reports.
About the Course
- Target
- Business users and Home users.
- Entry requirements
- Participants will need to have keyboard and mouse skills together with an understanding of Windows. Some knowledge of Word and Excel would be useful but is not essential
- Outcome
- Participants willl gain confidence in the use of features, such as creating and modifying tables, setting up relationships, designing forms, making queries and printing reports.
- Content
- THE FOLLOWING TOPICS WILL BE COVERED:
MODULE 1- Introduction to databases, what is a relational database?
- Designing tables
- The toolbar
- Creating table objects
- Primary keys and foreign keys
- Table definition components
- Setting field properties
- Set rules and validations
- Set default values
- Creating indexes
MODULE 2- Modifying table structures
- Entering data in datasheet view
- Importing data
- Creating relationships and setting up referential integrity
- Modifying the way data is displayed
- Copy move and delete data
- Hide and show data
MODULE 3- Searching tables
- The find command; limitations of find
- Find and replace
- Using filters, Selection and Form
- Using Wild Cards to set criteria
- Setting multiple levels of criteria
- Excluding a set of records
MODULE 4- Designing data entry forms
- Advantage of forms in Access
- Auto Form, and Form Wizard
- The Form design work surface
- The object property sheet
- The palette
- The field list
- The toolbar
- The toolbox
- Creating multi-table forms
MODULE 5- Designing Queries
- What is a dynaset
- Setting Criteria
- Parameter Queries
- Calculation in queries
- Summarising data
- Table joins in queries
- Action queries
- Updating queries
- Make data queries
- Delete queries
- Append queries
MODULE 6- Printing tables and forms
- Using Autoreport and report wizard
- Single column and tabulated reports
- Groups and totals reports
- Mailing labels
- Changing the design of an existing reports
- The report bands
- Integrating with Microsoft Word
Abal Computer Services train a maximum of 7 delegates at each training session and individual support is always available. Abal have now become a Learn Direct Centre, open 9.30am-5.00pm, Wed and Thurs 9am-9pm, for more information please contact Abal Computer Services on 01787 374138. - Introduction to databases, what is a relational database?
- Cost
- Contact course provider for details
- Enrolment
- Contact the provider for details.
Availability
- Starts
- .
- Duration
- Two day
- Timetable
- .
- Provider
- Abal Computer Services
Venue and Contact details
Main
Unit 4, South Suffolk Business Centre
Alexandra Road
SUDBURY
Suffolk
CO10 2ZX
UNITED KINGDOM
Telephone 01787 374138
Fax 01787 312089
Email training@abal-computers.com
Website http://www.abal-computers.com
Venue Notes Home study no attendance required
Contact Notes Tel: 01787 374138
Courses
Syndicate
