Access 2003 Video Tutorials from BSU

Here are Ball State’s Microsoft Access 2003 Video Tutorials. These Access Tutorials will help you use this database application to become more productive with organizing, accessing, and sharing information and data. One thing about Access is that end-users can use it without much training, while developers can use it to write complex applications. These tutorials cover and teach creating tables in Access, creating relationships, entering data into records, udpating data in a database, changing fields and tables, validation rules, working with queries, and printing with Access.

Getting Started

• Access 2003 Overview
  Create a database file and learn about some of the basic Access screen elements.
  
  
• Save Your Database
  Access automatically saves your database and all the associated elements when you close the database.

• Create a Table Using the Table Wizard
  The Table Wizard assists you in creating a table by providing a sample table templates that you can customize.
  
  
• Create a Table Using the Design View
  The Table Design View allows you to create a table without starting with a table template.
  
  
• Create a Table by Importing Data from an Excel Spreadsheet
  Automatically create a table based on data that has already been entered into an Excel spreadsheet.  As part of the process, the data in the spreadsheet is imported into Access to populate the table.

• Create a One-to-Many Relationship
  Relate two tables to each other using a one-to-many relationship.  Learn why Referential Integrity is important.
  
  
• Open a Relationships Window and Adding Tables
  The Relationships Window gives you a graphical representation of your database and allows you to build or modify the relationships between the tables in your database.  Includes an explanation of the three types of relationships.

• Insert Records Using the Datasheet View
  The Datasheet view provides an easy way to enter data into an existing Access Table.
  
  
• Add Records Using a Lookup List
  One of the ways that data can be added to your database is by using a Lookup List.

• Change Existing Data
  Changing data in an existing record.
  
  
• Updating Records
  Updating a record in a table is as easy as opening the table and then typing in the change.
  
  
• Update Multiple Records
  Update multiple records in an existing table using the “Replace” or “Replace All” commands.  This allows you to update information for records in a table that meet certain conditions.
  
  
• Delete a Record from a Table 
  It is easy to delete a record from a table in your database.

• Add a Row to an Existing Table
  Update a table by adding a new row of information to the table.
  
  
• Add a Field to an Existing Table
  Add a field to an existing table using the Design View.
  
  
• View and Update a Table Using an AutoForm
  AutoForms provide a way that you can view the data in an existing table or can adding additional rows to the table.
  
  
• Using the Lookup Wizard to Access and then Modify a the Table Properties
  If you need to modify the properties of an existing table in your database, the Lookup Wizard provides a great way to do that.
  
  
• Add an Input Mask to an Existing Table
  An input mask is the format for a particular field.  It consists of literal display characters such as hyphens, periods, and parentheses.  

• Setting Validation Rules
  Set a validation rule and establish the text properties for the rule.  Validation rules on a field ensure that only valid data gets entered into the field.
  
  
• Validation Rule Testing
  Setting validation rules for fields in your database ensures that only valid data can be entered into each field.  Validation rules can be tested by adding records to a table.

• Search a Table to Find a Specific Record
  Open a table and then run a search on any field in the table to find the record(s) that match what you are searching for.
  
  
• Using the Lookup Field Wizard
  The Lookup Wizard provides an easy way to lookup specific values in a field in a table.
  
  
• Navigating Among Table Records Using the Data Sheet View
  Use the record selector and tab keys to move around in a table in the datasheet view.

• Create a Select Query
  Use the Table Design View to create a query to select data from a single table. 
  
  
• View the Results of a Query
  Queries can be developed to display information from the database.  Learn how to run a query.
  
  
• Add Fields to a Query Design Grid
  Queries are used to view, change, or analyze data.  They can be used as the basis for reports.
  
  
• Create a Query Based Upon Multiple Tables
  Select data from several tables by creating a query in the Design View.

• Printing a Table
  There are a couple of ways to print existing tables – you can click on the Print button on the tool bar or access the printer via the File menu.   Learn how to use the “Print Preview” option.
  
  
• Printing the Results of a Query
  After a query is run, it is easy to print the results of the query.

Popularity: 15% [?]