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.
Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.