Part time Access Intermediate
A Level
In Doncaster
Description
-
Type
A Level
-
Location
Doncaster
-
Duration
1 Day
Fundamentals- Menus- Toolbars- The Task Pane- The Taskbar- HelpDatabases- Database Principles- Create a New Database- Open an Existing Database- Database Views- Save and Close a DatabaseTables
Facilities
Location
Start date
Start date
About this course
Delegates should be familiar with the basics of Access 2003, either from attending our Introductory Course or knowledge gained from their own experience.
Reviews
Course programme
Microsoft Access 2003 - Intermediate Type of learning:
Instructor lead at DBIC
Duration:
1 day intensive
Times/dates:
Cost:
£185 (includes course materials, lunch and refreshments)
Corporate rates available please contact us for further information
Target Audience
This course is aimed at anyone who has some experience of Access 2003 and wishes to examine some of the more advanced features.
Pre-Course Requirements
Delegates should be familiar with the basics of Access 2003, either from attending our Introductory Course or knowledge gained from their own experience.
Benefits to the Employer
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.
Course Aims
This course allows the delegate to experience the power of Access 2003. By the end of the course, the user will be competent with the following skills:
Course Outline
Advanced Queries
- Sum, Count, and Group By
- Average, Maximum and Minimum
- Calculated Fields in a Query
- Parameter Query
Relationships
- Apply a Primary Key
- Table Relationships
- Referential Integrity
- View Subdatasheet
Table Field Properties
- Lookup Field
- Format Field Properties
- Default Values
- Validation Rules and Text
- Input Masks
- AutoNumber
Advanced Forms
- Subforms
- Linked Forms
- Multiple Table Forms
Form Controls
- Calculated Fields
- Command Buttons
- Combo Boxes
- List Boxes
- Option Groups
- Tab Control
Form Properties
- Titles
- Allow Data Amendments
- Setting Form Views
- Set Cycle Properties
- Shortcut Menu Properties
Advanced Reports
- Grouped Report
- Labels
- Charts
- Calculated Fields
Tools
- Import Data
- Export Data
- Copy, Rename and Delete Objects
This course outline is a guide. All our courses can be tailored to customer requirements.
Part time Access Intermediate