Learn Microsoft Access 2007 Overview - How to Use Microsoft Access

"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 $9.95 USD for shipping & processing.

MEMBER LOGIN »

Search Tips

Back

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

Your CDs will include all 3 versions!

Lesson One	Lesson Two	Lesson Three
Section 1 - Introduction Section 2 - Creating a Database Using Windows® XP Getting Started screen New Access interface Access Welcome screen Title bar Sizing icon Database defined Create a database Save a database Objects defined Open blank database Name the database Save as type box File formats Create new folder View icon List view Details view Section 3 - Creating a Database Using Windows Vista® Getting Started screen New Access interface Access Welcome screen Title bar Sizing icon Database defined Create a database Save a database Objects defined Open blank database Name the database Save as type box Browse folders box File formats Create new folder View icon slider bar List view Small Icons view Details view Section 4 - The Access Environment Ribbon defined Contextual tabs defined Galleries defined Home tab View commands Clipboard group Create tab External data tab SharePoint lists Database tools Navigation pane Status bar Office Button Open database Quick Access toolbar Save icon Undo icon Redo icon Customize Quick Access toolbar Add icon to toolbar Add more commands to Quick Access toolbar Show Quick Access toolbar below Ribbon Help icon Security warning Section 5 - Creating and Using Tables Database defined Tables defined Create a new table Design view Save a table Name a table Table Design button Status bar Data table defined Record defined Field defined Unique field number Set data types Field Properties dialog box Automatic numbering fields Default numbering fields Data type defined Data type list AutoNumber defined Caption field Indexed field Description field Text DataType field Date DataType field Date format Set a Default Value field Insert field row Currency Data Type field Primary key defined Define a primary key Conditions for primary keys Primary key icon Save a table Section 6 - Entering Data into a Table Changing table view AutoNumber field Enter Data New record indicator Copy records Change a table design Switch to Design view Lookup Wizard Values defined Label the lookup table Allow multiple values for a field Expand the table design Resize columns Column Width Option dialog box Best Fit button Section 7 - Create and Using Forms Forms defined Create a form Form icon Format tab Form view New AutoForm icon to create form Navigation buttons Enter data in a form Add a field to the table Save a form Logic field defined Add a Logic field Section 8 - Adding a Field to a Form Form design fields Design Form toolbar Rulers defined Gridlines defined Rulers icon Gridlines icon Open rulers Show gridlines Open gridlines Field List pane Turn on the grids and rulers in a form design Anchor the toolbar Enlarge the form design Anchor defined Insert label control onto the form Move the field control boxes Layout view Format dialog box Tab Order icon Arrange tab Control Padding defined Control Padding feature Change form on the form title Add titles to a form Change title font Add logo to form Move all fields and labels at once Use the rules to line up field controls Resort records in a table	Section 1 - Introduction Section 2 - Understanding Tables Table defined Records defined Fields defined Table template Create table from template Use sample tables Select sample tables Save a table Field Template task pane Anchor task pane Select fields from task pane for a table Rename column Set a primary key Delete a column Primary key Design view Change primary key field Input Mask defined Placeholder characters defined Use symbols in an Input Mask AutoCorrect button Required fields Index field defined Allow duplicates in fields Default value defined Expression builder Expression defined Add a field Section 3 - Using the Form Wizard Form Wizard defined Build a table using the Table Wizard Connect form with a table Select fields for forms Background for form Style for form Name a form Modify form designed Delete field from form Edit footer on a form Format field boxes Format field labels Move entire form Add title to form Rulers in form designs Set properties of field boxes Use the To Fit command Enter records in the form Create a multi-line field in a form Section 4 - The Datasheet View Use the Datasheet view Link data between two tables Common field defined Foreign key defined Primary vs. foreign key Change primary key Insert row AutoNumber Short Data type Set properties for field box Copy Input Masks Set field definitions Create an index for fields Section 5 - Table Relationship Necessity of common fields Relationship icon Database tools Show Table dialog box Create relationships Link fields between tables Edit relationships One-to-Many relationships Referential Integrity defined Enforcing Referential Integrity Cascade Update Related field defined Cascade Delete option defined Save relationship layouts Section 6 - Creating Queries Queries defined Query Design icon Select table for query Create query in Design view Query Design window Add fields to Query Design view Run the query Save the query Calculated fields defined Expression defined Creating expressions Concatenation of fields Section 7 - Using Queries in Forms Create forms using several different tables and queries Select fields from several tables Format forms Move fields Delete Labels Properties dialog box Lock query fields Enter records Automatic Calendar icon Calendar icon Find records Match case in Find and Replace dialog box Section 8 - Building and Modifying Reports Reports defined Select tables to include in the report Add grouping levels in reports Sorting data in reports Select layout for reports Preview report Edit report design Report Design window Zooming in and out Save reports Section 9 - Queries and Reports with Multiple Tables Create query in Design view Add fields to the Query view Concatenate fields in queries Expression zoom box Concatenate multiple fields Brackets in expressions Label fields Creating expressions in a query Null values Report Wizard Name report Select criteria lines Spell-check Print a report Print preview	Section 1 - Introduction Practice Lesson Files Section 2 - Importing Data Into an Access Database Name database Create new database Save database Browse folders Linking databases defined Primary key in linked database Referential Integrity defined Import data vs. link data Link data vs. import data Import data SharePoint designer defined Get External Data dialog box Import source data into a new table Import Spreadsheet Wizard Import worksheet only Import a range of cells Column headings in imported worksheet Change data type during import Assign primary key Formats available for importing Isolate worksheet within a workbook for importing Create new table from Import menu Indexed with duplicates Save without primary key Save import steps Section 3 - Using the Find Duplicates Query Wizard Close navigation pane Delete column in tables Identify number of records Query Wizard icon Find Duplicates Query Wizard Select field with duplicates Name query View results from query Dynaset defined Delete records in a query table and throughout all tables Open navigation pane Edit labels in table Design view Edit Input Mask Match field labels Move fields in a table Set primary key in edited tables Input Mask build button Datasheet view Add new record to field Change data type Save edited field Show/hide table Move tables in Relationship field Defining table relationships Link tables Resize Relationship windows One-to-Many relationships Referential Integrity Section 4 - Select vs. Action Queries Select queries defined Action queries defined Append action query defined Delete action query defined Make table action query defined Update action query defined Create relationship between tables Add all fields to a table Entering criteria in query Sort table Use the sort field box Show command in query Make Table icon in query Name new table in Make Table query Run button Security alert box Enable this content option Save the query Design view Datasheet view Save query Using Count function Delete tables Compare data between tables Set primary key Section 5 - Linking Tables Import tables Linking tables defined Link tables Get External Data File dialog box Link to data source by creating linked table option Define relationship Show Table icon Show multiple tables on workspace Order of tables on workspace Show table window Join tables One-to-one relationship defined Join properties boxes Left join defined Right join defined Query design Design view Delete records Create a delete action query Find records Section 6 - Using a Union Query Union query defined Create a mailing list with two databases Structured Query Language (SQL) defined Sequel defined View SQL statements Security warning Navigation pane All Access Objects option on navigation pane Design view Link tables Link Databases Build a union query Union icon Sub-data set defined Open a sub-data set View sub-data set Query design Show Table window Adding totals to query Sorting data Group by line in Query grid Criteria string


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.