How to Create a database in Microsoft Access

In this six-part video tutorial, learn how to create an access database. The following six parts go over the following:

Part 1: Explains the value of a multi-table database by looking at tables of data in a spreadsheet prior to getting into Access.

Part 2: Create tables in Access, setting data types, and establishing the one-to-many relationships.

Part 3: Use the lookup datatype for a field and create a form for faster data entry.

Part 4: Add a third table to a database to prevent a many-to-many relationship between two tables.

Part 5: Create queries in an Access database.

Part 6: Create a report with calculated controls (subtotals and grand total) based off of a query.

(1) Part 1 of 6 - How to Create a database in Microsoft Access, (2) Part 2 of 6 - How to Create a database in Microsoft Access, (3) Part 3 of 6 - How to Create a database in Microsoft Access, (4) Part 4 of 6 - How to Create a database in Microsoft Access, (5) Part 5 of 6 - How to Create a database in Microsoft Access, (6) Part 6 of 6 - How to Create a database in Microsoft Access

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest