Kurs 71593 - Microsoft Visual Basic 5.0: Working with Databases - Part 1
Ziele- Create an application that verifies data at the field level and the form level. - Access a database using Data Control, SQL and Advanced Data-bound Controls.
AnforderungenThe course is intended for application developers who will use Visual Basic 5.0 to create sophisticated business applications. This series assumes that the learner has experience with Microsoft Windows operating system 3.1 or later, and a knowledge of word processing and spreadsheet applications. Participants should also have the knowledge of Basic or another procedural language, including experience using variables, control structures like if-then-else statements and also looping structures like for and while loops. Participants should have taken Microsoft Visual Basic 5.0: Programming Fundamentals (Courses 71591 and 71592).
TitelKurs 71593 - Microsoft Visual Basic 5.0: Working with Databases - Part 1
InhaltCourse Description
This is the third course in a seven part series for application developers who intend to design, build and implement business solutions by using Microsoft Visual Basic 5.0. The series aims to enable the professionals to pass Microsoft exam 70-165, Developing Applications with Microsoft Visual Basic 5.0.
Deployment Options
Self-Study
Objectives
Unit 1: Input Validation 2 - 3 hours
- Enter the code to validate field level date using the InputBox function.
- Enter the code to validate keystrokes.
- Enter the code to trap the function keystrokes.
- Set the masked edit control.
- Enter the code to validate data entered for a field.
- Enter the code to validate data in a field.
- Enter the code to validate a keypress at the form level using the KeyPreview property.
- Complete the code to enable an OK button on the form after the data has been entered.
- Complete the code to validate that a field is not left blank.
- Enter the code to activate forms using Activate events.
- Enter the code to restrict user input using the Load events.
Unit 2: Data Access Using Data Controls 2 - 3 hours
- Identify the components of a database.
- Identify the categories of databases accessed by the Jet database engine in Visual Basic.
- Identify the functions of a data control.
- Match the properties of a data control with their functions.
- Identify the definition of a Recordset.
- Update records using data control methods.
- Add a record using the AddNew method.
- Delete a record.
- Verify data before writing it to the database.
- Perform an action before moving to the next record.
- Set Error Event response message in the event of data access error.
- Specify selection criteria for retrieving information using the SQL SELECT syntax.
- Combine records from multiple tables using SELECT with the inner join operation.
Unit 3: Using Data Bound Controls 2 hours
- Enter the code to add an item to a ListBox.
- Identify the definition of a DBList control.
- Add data to a table using the DBList control.
- Identify the functions of a DBGrid control.
- Add a DBGrid control to your project.
- Set properties for individual columns in a data-bound grid.
- Enter the code to activate DBGrid events.
- Display information from a database using DBGrid control.
- Add data to a table using DBCombo control.
- Identify the functions of the MSFlexGrid control.
- Display information from a database using the MSFlexGrid control.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
Ähnliche angebote die in bezug zu ihrer anfrage "visual basic (visualbasic)" stehen