Microsoft Access - 3 day
Sponsored links
Microsoft Access 2003
This training also looks at features that are new or improved in Microsoft Access forDatabase designers to develop an understanding of the latest version of Microsoft Access. This training begins with an introduction to database concepts and a design methodology that will help new designers organize the data being stored, and quickly advances to cover many of the features and tools needed to design exceptional database applications.
On completion of this course learner will be able to:
Create tables, manipulate datasheets, and work with multiple tables
Understand the seven database objects and design systems objects
Apply the seven-step design method to build databases tailored to your needs
Build forms with wizards, create bound and unbound forms, and add data validation
Use XML to create basic and advanced Data Access Pages
Automate query parameters, create functions and subroutines, and add programmed error routines
Exchange data with Word, Excel, PowerPoint, and other Office applications
| Delivery: |
|
| Category: |
Further Details
Topics covered
Importing data from external sources, query design and execution, and designing data entry forms and printed reports
User- and developer-level traits and capabilities of Microsoft Access 2003.
Emphasis falls on relational database design, data entry and validation techniques, form design, sorting and reporting, CrossTabs and PivotTables, and Transact-SQL. Differences between the Jet database engine and the Microsoft SQL Server database environment, and notes on developing applications for both.
This Training Course is offered "in house" at the following locations:
Hull
Leeds
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
