Microsoft Access: Access Level 1 & 2 (GUI, Macros, VBA)

Explore how to open and navigate a completed Access table, add and delete records, and switch between datasheet view and design view.

Learn to edit records by selecting a row, deleting or editing fields, undoing mistakes, and navigating with tab, home, end, and arrow keys; add new records.

Open the customer table in design view to move, add, or delete fields with mouse actions. Use shift-click to select multiple fields, insert above a field, and drag to reorder.

Explore unbound controls in Access, especially labels that display without a data link, and learn why simple labels in a report header appear without linking to a table.

Add a grand total to an Access report using SUM on unit price and quantity, placed in the report footer, formatted as currency, with a clear grand total label.

Explore creating and designing access queries, select the customers table with all fields using the asterisk, view in data sheet view, and edit field order or deletion in design view.

Design a query from the December 2019 orders table to use expressions and calculations on order date, unit price, and quantity, with criteria to filter results.

Learn to create top records queries in Microsoft Access, selecting customer id and quantity, sorted by descending quantity, and using top values or percentages on the December 2019 orders.

Learn how append queries differ from update and make table queries, and how predefined fields and validation rules improve data integrity, performance, and normalization when adding records.

Leverage the graphical interface in access to avoid coding everything, easing maintenance and future changes. Relying on code increases clutter and manual edits, burdening new developers.

Demonstrate moving the customer field, dependent on order number, from orders table into its own table, with order number as the foreign key, illustrating the 2nd rule for normalized tables.

Identify when duplication is necessary over normalization, considering if a field changes over time and whether such changes matter to the business, such as price history or customer addresses.

Learn to transform non normalized spreadsheet style data into normalized tables in Access, using a year field and related data type fields to store records efficiently.

Maintain field type consistency across tables by using the same auto number data type for primary and foreign keys, as shown in design view, to reduce errors.

Identify a one-to-many relationship by examining how country id in countries is a primary key, becomes a foreign key in regions, and links regions to cities.