Profile

Login

Catalog

Search

Contact

Cart

	Microsoft Access 2000 (Beg, Int, and Adv.)
	MSACCESS
	English
Audience Details:
	16
	Familiarity with any of the Windows user environments
	Anyone wishing to become familiar with Microsoft Access 2000; students wishing to become MOUS certified at Microsoft Access 2000 at the Core level
	To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of planning and creating a database, creating tables and forms, and entering and querying data, creating and enhancing a report, working with queries, and integrating data, modifying and enhancing a table, a form, working with Access tools, and integrating Access with the Web
	After learning this courses you should be able to:
	Plan and create a database. Create and modify a table. Use Lookup and Input Mask Wizards. Create and modify forms and controls. Enter, change, and print records. Create and modify queries. Create and modify a report. Add and modify controls and sections. Use filters in a query. Use total and parameter queries. Modify and optimize queries. Integrate, chart, and link data. Define and validate data. Optimize data types. Create, modify, and customize a form. Use subforms and switchboards. Use Access tools. Create and use macros. Create data access pages. Create hyperlinks.
	Hands on pratice - Simulations
Course Structure:	Unit Titles and Topics Covered
	Planning and creating databases Introducing databases Planning databases Starting Access Creating databases Hands-on: Creating a database Working with tables Creating tables Hands-on: Creating a table Modifying a table Lookup and Input Mask Wizards Hands-on: Modifying Lookup fields Working with forms Creating forms and controls Hands-on: Adding controls Modifying controls and sections Hands-on: Formatting control properties Working with data Entering and changing records Working with records Hands-on: Entering and sorting records Creating and modifying queries Hands-on: Creating and specifying a query Printing records Reports Creating a report Hands-on: Adding controls to a report Modifying controls and sections Hands-on: Modifying format properties Hands-on: Using a calculated control Navigating and printing Enhancing reports Creating and modifying reports Hands-on: Using Design view Control and section properties Hands-on: Modifying properties Subreports Hands-on: Using the subreport control Queries Filters in a query Hands-on: Applying filters in a query Totals and parameter queries Modifying query properties Action queries and SQL statements Specifying join properties Optimizing queries Integrating and saving data Importing and exporting data Hands-on: Importing data Hands-on: Exporting to Excel Charts and linking data Hands-on: Using charts Database utilities Saving databases Modifying tables and relationships Defining relationships Hands-on: Establishing relationships Data validation Hands-on: Validating data Optimizing data types Advanced forms Creating and modifying a form Hands-on: Creating a form Customizing a form Hands-on: Customizing form sections Subforms Hands-on: Using the subform control Switchboards Access tools Startup options and passwords Hands-on: Setting and modifying a password Analysis Replication and encryption Macros Hands-on: Creating macros Access and the Web Data access pages Hands-on: Creating a data access page Hyperlinks Hands-on: Creating a hyperlink
Curriculum Info:
	IT Curriculum
	Personal Use License Price $179.00
	Contact your Eno Learning Consultant or call 888-742-3214 to order. For organizational purchases, please contact the sales office nearest you. Available Online, Interactive CDs, Network