|
Access
2000
Excel
2000
Power
Point
Oracle Tutorial
Microsoft
MCSE
2000
Training
Microsoft
Office
MOUS
Cisco
CCNA
CompTIA
Courses
SQL Server
IIS 4
TCP/IP
QuickBooks
RPG IV
Crystal Reports 8
XML
SAP R/3
GroupWise 5.5
GUI Programming
Visual Basic
Visual InterDev
Lotus Notes
Novell 560 CNE
Novell 570 CNE
SAS Tutorial
SAS 8
LAN Training
UNIX
Sybase
|
|
These microsoft access training courses are for people who will work with Microsoft Access products or preparing for Microsoft MOUS Access 2000 certification.
This is self-paced, internet-based training course -- there are no books to purchase and no scheduled classes to attend.
- Creating Access Databases - shows users how to plan and create access database.
- Building Tables - shows users how to create and populate database tables.
- Modifying Tables - shows users how to edit table data, table structure, and field properties table format.
- Sorting and Filtering - shows users how to find, filter, and sort records.
- Relationships & Queries - shows users how to establish table relationships perform join operations and define and execute queries.
- Building Forms - shows users how to create forms to change the appearance of reports and to add bound and unbound controls to reports.
- Producing Reports - shows users how to create reports with the Report wizard arrange and organize reports and add bound and unbound controls to the report.
- Advanced Tasks - shows users how to import data into access databases create Web hypertext pages based on objects incorporate hyperlinks into objects and perform administrative tasks such as backing up the access database.
After completing our microsoft access courses, the user should be able to:
- Identify appropriate input and output for a database
- Plan a database
- Create a database with and without the wizard
- Select and print database objects
- Explain the structure of a table, the data types used in the table, and the function of primary keys
- Create a table using the wizard
- Enter records into the table through a form or datasheet
- Insert and delete records and fields
- Modify the appearance and structure of the table in Design View
- Change the size, format, and default value of fields
- Use the Lookup and Input Mask wizards
- Sort records
- Create advanced sorts
- Search for records
- Apply and remove filters
- Define table relationships
- Display related records
- Specify query criteria
- Create calculated fields
- Create and modify multi-table queries
- Create a form
- Edit the form in design view
- Add and modify controls
- Create and use calculated controls
- Describe the components of reports
- Create a report using the Report wizard.
- Edit the report in design view
- Add and modify controls in a report
- Create and use calculated controls in a report
- Import data into a table
- Save an object as a Web page
- Add hyperlinks to an object
- Back up restore and compact a database
This course is distributed with:
- Simulations that allow users to practice course skills
- An glossary
All courses are design so that new knowledge and skills will be remembered and retrieved for future use. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth and stimulate job satisfaction.
|