|
|
|
Access 2003: A Comprehensive Hands-On Introduction
Building a Foundation for Client/Server Database Applications
Course: 307
Type: Hands-On Training
Duration: 5 Days
You Will Learn How To
- Design robust relational database applications using Microsoft Access 2003
- Develop client/server database front-ends
- Build database applications quickly using Form, Table, Report and Query wizards
- Link to ODBC and OLE-DB data sources to leverage enterprise security
- Create and integrate macros into your applications
- Implement advanced Access reporting features
Course Benefits Microsoft Access is a powerful tool with which to design and develop Windows-based database applications. This course explains key database design concepts and functionality. You learn to build an Access database system in class and develop a front-end that queries a SQL Server database over a Windows network.
Who Should Attend Anyone who plans to prototype, build and integrate database applications using Microsoft Access 2003 or a prior version of Access. Familiarity with Windows is assumed; some knowledge of databases or macros is helpful.
Hands-On Training During the course, you perform extensive exercises that provide in-depth hands-on experience with Microsoft Access. Exercises include:
- Building a Microsoft Access database
- Linking data among Access tables and with other programs
- Using Form and Query wizards
- Linking to and querying a SQL Server database
- Programming with macros and VBA
- Handling Windows events
- Creating preformatted and custom reports
- Developing advanced Access reports
Course 307 Content
- Databases and their contents
- Flat file and relational databases
- Tables, records and fields
- Ordering schemes
- Indexes and keys
- The visual development environment
- When to use Access
- Eliciting user needs and wants
- Designing the data model
- Access tables, fields, indexes
- Table relationships
- Table wizards
- Working with the datasheet view
- Attaching or importing existing tables
- Designing a friendly user interface
- Forms design
- Form wizards
- Controls and control properties
- What is a Query?
- Query by Example (QBE)
- Query by Form (QBF)
- Select queries
- Crosstab queries
- Action queries
- Parameter queries
- Query wizards
- Expressions in queries
- The ODBC OLE-DB connectivity standards
- Multiuser and security concerns
- Using Query wizards with SQL
- Issuing commands to SQL databases using pass-through queries
- Quick printouts with AutoReports
- Tabular, groups/totals, mailing labels and other standard report types
- Visually enhancing your presentation with wizards
- Exploiting formulas and expressions in reports
- Designing queries for effective report grouping
- Elements of effective custom reports
- Adjusting report controls
- Point and click
- Debugging tips
- Macro style guidelines
- Running a macro from events
- Converting macros to VBA code
- Writing event-driven programs
- Associating macros with controls to respond to user-triggered events
- Programming conditional macros to respond to user input
- Correlating data types with Access table definitions
- Controlling form values with variables
- Validating user data with field masks, field-level validation and advanced logic control
- Populating list and combo boxes with queries
- Hiding columns in list and combo boxes
- Grouping macros for organization
- Creating keyboard shortcuts with AutoKeys
- Converting Access macros to VBA code
|
Related Courses
Access is a trademark of Microsoft Corporation.
|
|
|
|
Print Friendly
E-mail a Colleague
Course FAQ
Course PDF
Home
