Microsoft Access - Launch Computer Training & Consulting

Home
	Full Day Series:	q Introduction	q Intermediate	q Advanced
	3 Hour Series:	q Creating Related and Unrelated Tables, Fields & their Properties
		q Fundamentals of Querying Databases
		q Advanced Querying Techniques
		q Creating Forms and Reports
		q Advanced Techniques in Form Creation & Report Writing

Microsoft Access
Title	Introduction to Access
Length	Two Days

What Is a Database? Understanding the Database Window Moving around a Table Editing Data Adding Records Changing Column Widths Saving Design View and Datasheet View Field Names Data Types Field Descriptions Field Properties Closing a Database while Opening Another Querying Sorting Saving Queries Modifying a Saved Query Comparison Operators Keyword Operators Wildcards Top Values/Filtering Numeric Summaries Printing Datasets Expressions Creating a Database Filtering Importing Records from Excel AutoReports Report Sections Manipulating Controls Concatenation Report Wizards Blank Reports Printing a Report Definition Primary Keys Relational Tables RETURN TO TOP

Microsoft Access
Title	Intermediate Access
Length	One Day

Review of Data Types and Field Properties Modifying Tables Using Hyperlinks Using Comparison Operators Using Keyword Operators Using Wildcards Creating Calculated Controls Creating Expressions Creating Parameter Queries Creating Make-Table Queries Creating Append Queries Creating Delete Queries Creating Crosstab Queries Creating Update Queries Finding Duplicate Records Finding Unmatched Records Importing Data Setting a Password Creating Combo Boxes Creating List Boxes Creating Option Groups Setting the Tab Order Creating Forms that Contain Subforms Adding Form Headers and Footers Creating Mail Merges Using Microsoft Word Creating Relationships Report Functions RETURN TO TOP

Microsoft Access
Title	Advanced Access
Length	One Day

Working with Subforms Adding Check Boxes, Toggle Buttons and Option Buttons Saving a Form as a Report Working with ActiveX Controls Creating Single Field Indexes Creating Multiple Field Indexes Creating a Multiple Field Key Replicating Databases Using Access with the Internet Creating Macros Using Switchboards Creating Custom Toolbars Creating A Shortcut Menu RETURN TO TOP

Microsoft Access
Title	Creating Related and Unrelated Tables, Fields & their Properties
Length	3 Hours

Moving around in a table Editing data Adding records Changing column widths Saving design changes Design view and datasheet view Field names Setting data types Field descriptions Field properties Field size Format Input mask Caption Default value Validation rule Validation text Required Allow zero length Indexed Creating relationships between tables Enforcing referential integrity RETURN TO TOP

Microsoft Access
Title	Fundamentals of Querying Databases
Length	3 Hours

Querying Working with field lists Bringing fields into the grid Removing fields from the grid Sorting in a query Changing display order in a dataset Using the Show row Defining criteria Saving queries Modifying a saved query And queries Or queries Using comparison operators Using keyword operators Using wildcards Showing only top values Using numeric summaries Creating expressions Printing datasets RETURN TO TOP

Microsoft Access
Title	Advanced Querying Techniques
Length	3 Hours

Creating parameter queries Finding duplicate records Finding unmatched records Creating crosstab queries Using a form to provide criteria for a query Action queries Creating make table queries Creating delete queries Creating append queries Creating update queries Creating union queries RETURN TO TOP

Microsoft Access
Title	Creating Forms and Reports
Length	3 Hours

Creating AutoForms Creating Autoreports Using report sections Adding fields and controls to reports and forms Aligning fields and objects Resizing fields and objects Manipulating controls on a report or form Concatenating fields and text Using wizards to create reports and forms Creating blank reports Printing a report definition Sorting and grouping on a report Changing the order of objects Changing an object�s properties Changing tab order RETURN TO TOP

Microsoft Access
Title	Advanced Techniques in Form Creation & Report Writing
Length	3 Hours

Creating subforms to display information from related tables Creating expressions in subforms Creating a relationship between tables Methods for creating forms Displaying expressions from subforms on main forms Adding check boxes, toggle buttons and option buttons Creating combo boxes Creating list boxes Creating option groups Tab controls Creating switchboards Creating macros RETURN TO TOP