Learning Access 2002 Overview - Microsoft Access Lesson Plan

"Try My Product^® today for FREE*!"

If you are not happy with the lessons, just call to return one CD within 10 days and keep the other two CDs FREE* to avoid a purchase charge.

*Pay up to $6.95 (or $8.51 USD in Canada) for shipping & processing.

MEMBER LOGIN »

Search Tips

Back

With this Learn Access^™ 2002 tutorial you will learn:

Your CDs will include all 3 versions!

Lesson One	Lesson Two	Lesson Three
Section 1 - Introduction and Environment Opening the application Task panes Opening new and existing projects Visit Web for templates Closing the task pane Title bar Minimize/Maximize/Restore/Close buttons Menu bar View menu Toolbars Customize toolbars Section 2 - Creating a Database Database defined Create a database Saving a database Objects defined Section 3 - Creating and Using Tables Tables defined Create a new table New Table dialog box Design view option in tables Data table defined Field and record defined Unique field number Setting data types Field Properties dialog box Automatic numbering fields Caption field Indexed field Description field Text Data Type field Date Data Type field Date formatting Setting a default value field Insert field row Currency data type field Saving a table Defining a Primary key Condition of Primary keys Primary key icon Section 4 - Entering Data into a Table Changing Table view AutoNumber field Entering data Copying records Changing a Table design Switching Table view Using the Lookup Wizard Expanding the table design Resizing columns Column Width Option dialog box Using Best Fit button Section 5 - Creating and Modifying Forms Forms defined New AutoForm icon to create form Navigation buttons Add a field to the table Logic field defined Adding a logic field Saving forms Section 6 - Adding a Field to a Form Form Design fields Design Form toolbox Turning on the grids and rulers in a form design Anchoring the toolbar Enlarge the form design Inserting label control onto the form Move the field control boxes Editing label controls Add titles to a form Moving all field and labels at once Using the rules to line up field controls Label Tool icon in the toolbox Error Indicator button Formatting title labels Special Effects button Change the background to a form Formatting elements and controls of a form Resorting records in a table	Section 1 - Using the Table Wizard Building a table using the Table Wizard Using sample tables Selecting sample tables Setting a Primary key Modify table design Input mask defined Install the Input Mask feature Coding in the input mask Placeholder characters defined Using symbols in the input mask AutoCorrect button Required fields defined Creating an index in a table Entering a default value Expression building defined Building expressions in a table Section 2 - Using the Form Wizard Building a table using the Table Wizard Connecting form with a table Selecting fields for forms Previewing form styles Rulers in form designs Setting properties of field boxes Using the To Fit command Entering records in the form Creating a multi-line field in a form AutoSaving records in the form Section 3 - Creating in Datasheet View Using the Datasheet views Linking data between two tables Common field defined Primary vs. foreign key Setting Properties for Field dialog box Database Windows icon Copying input masks Setting field definitions Creating index for fields Section 4 - Table Relationships Need of common fields Using the Relationship option Linking fields between tables Editing relationships One to many Referential integrity defined Enforcing referential integrity Cascade update related field defined Cascade Delete option defined Saving relationship layouts Section 5 - Creating Queries Queries defined Create query in Design View Adding fields to query design view Running the query Saving the query Calculated fields defined Expression defined Creating expressions Concatenation of fields Section 6 - Using Queries in Forms Create forms using several different tables and queries Selecting fields from several tables Formatting forms Moving fields Deleting labels Locking Query fields Entering records Finding records Section 7 - Creating and Modifying Reports Reports defined Selecting tables to include in the report Adding grouping levels in reports Sorting data in reports Selecting layout for reports Preview report Editing report design Report Design window Zooming in and out Save reports Section 8 - Queries with Multiple Tables Create query in Design view Adding fields to the Query view Concatenate fields in queries Open Express Zoom box Concatenate multiple fields Labeling fields Creating expressions in a query Null values Selecting criteria lines Spelling checking Section 9 - Creating a Custom Report Creating report in letter form Adjusting ruler to specific dimensions Opening the Fields List box Removing field labels Insert checkbox tools Label tools in a report Adding header to a report Reformat headers Special effects in reports Adding colors to text boxes To Fit option Editing Custom Report view Print custom reports Change print set up Print Preview Print multiple copies Print selected pages	Section 1 - Introduction Section 2 - Importing Data to Access Converting data from Excel to Access Open Task Pane Create a new Database Linking databases defined Referential integrity defined Import data vs. converting data Importing data Formats available for importing Isolating worksheet within a workbook for importing Creating new table from import menu Indexed with duplicates Saving without Primary key Section 3 - Find Duplicates Query Wizard Delete column in tables Identifying number of records Using the Find Duplicates Wizard View results from query Delete records in a query table and throughout all tables Edit input masks Matching field labels Defining table relationships Resize Relationship windows Section 4 - Select Queries/Action Queries Select vs. Action queries defined Append Delete Make table Update Sorting table Using the Sort Field dialog box Show command Make Table icon in query Run button Adding selected entries to new table Creating multiple query tables Using Count function Delete tables Comparing data between tables Section 5 - Linking Tables Linking tables defined Linking tables Show multiple tables on workspace Order of tables on workspace Joining tables One to One relationship defined Join properties box Left join vs. Right join Use Query Wizard Creating a delete action query Finding records Section 6 - Using a Union Query Creating a mailing list with two databases Structured Query Language (SQL) defined Viewing SQL statements Linking databases Building a union query Union icon Sub-data set defined Viewing sub-data set Adding totals to query Sorting data


Your CDs will include all 3 versions!

Back

Video Professor, its logos, slogans and product feature names are trademarks and/or registered trademarks of Video Professor, Inc. in the U.S. and other countries. All other trademarks are the property of their respective owners, and the aforementioned entities neither endorse nor sponsor Video Professor or its products.