Access 2016 Introduction

Learn how a database is a container for storing and analyzing data, like a file cabinet or toy chest with compartments.

Explore core database terminology, from database application and relational database to tables, records, fields, and values, and learn how relationships link data across tables.

Explore the Microsoft Access interface from the backstage view, and identify database objects like tables, queries, forms, reports, macros, and VBA modules.

Compare flat file databases to relational databases, using Excel or Access as common examples, and discuss pros like quick analysis and cons like data repetition and manual entry, highlighting normalization.

Explore how relational databases organize data into related tables, using primary key and foreign key fields, and understand one-to-many, one-to-one, and many-to-many relationships, with referential integrity and normalization.

Learn to relate tables in Access 2016 by creating one-to-many relationships between orders, order details, and products, enforcing referential integrity, and using subdata sheets to view and enter related records.

Explore the create tab to build tables, queries, forms, and reports, and use the external data tab to import or link data from Excel, SQL Server, or text files.

Sort and filter data in tables using default and custom options, including ascending/descending sorts, remove sort, right-click and dropdown access, and text, date, and number filters to refine results.

Master data navigation in Access 2016 by using the datasheet view, record selectors, and keyboard shortcuts like Ctrl+Home and Ctrl+End to move to the beginning or end of the table.

Edit and manage data in an access 2016 table using data sheet view; changes save automatically, with warnings on deletions and separate design changes.

discover how to add a new record in Access 2016 using the New button or navigation area; learn tab and date shortcuts, auto-number keys, and automatic saving of records.

Explore subdatasheets in Access 2016, showing related child data within the parent table and enabling quick viewing and entry across related tables through relationship view, home tab options, and expansions.

Adopt a top-down approach to database design, from defining the database purpose and storage location to creating tables, normalizing fields, and establishing primary and foreign keys for clear relationships.

Open a table to view the data sheet view, the default in tables and queries, showing field names, records, and a record selector for navigation.

Explore design view to see how data types shape storage and entry, including text, numbers, date and time, currency, auto number, yes/no, and lookup wizard options.

Explore the table design view in Access 2016, review fields, data types, and field properties, and learn how design settings flow to forms, primary keys, lookups, and relationships.

Create calculated fields in Access 2016 to compute values across entire fields. Use the expression builder in a table or query to calculate potential income from unit price and stock.

Calculate potential income by multiplying units in stock by unit price in an Access 2016 calculated field. Learn PEMDAS, expression builder syntax, and currency formatting in data sheet view.

Create a calculated field called ship by date in the orders table using order date plus four days, and confirm in the datasheet that the ship by date updates automatically.

Learn to create a calculated string field that joins last name and first name into a file as field using ampersands and quotes for punctuation in Access 2016.

Explore how the lookup wizard creates drop-down lookups between tables or from typed values. Learn to pull from the employees table, store the employee ID, and enforce referential integrity.

Learn to create and customize lookups in Access 2016 without the Lookup Wizard, using a combo box bound to a table or query, and edit lookups for related fields.

Explore how indexes speed searches in a table. Create primary key indexes with no duplicates and add indexed fields like hire date and postal code in design view.

Discover how Access 2016 queries pull data from multiple tables, differentiate select queries from action queries, and create queries using the wizard or design view.

Create a simple query with the wizard and design view to pull fields from related tables. Then run and save the query, noting normalization and detail versus summary.

Explore how a select query pulls data from multiple tables, view table relationships in design view, and how edits in query results can update the underlying tables, unlike calculated fields.

Learn to refine access queries with criteria, using less than, between, and exact-match conditions in design view, and save each criteria set as separate queries across multiple fields.

Learn how and and or criteria join conditions in Access queries, using and to require all conditions and or to allow any condition to match, with category and date examples.

Learn how wild cards work in access 2016, using the asterisk to replace character strings and dynamic queries such as names starting with M or dates like 1998.

Explore how to use keywords and reserved words in Access 2016 queries to filter results, including is null for blank fields and like and not like for pattern matching.

Sort a query by quantity in descending order and hide fields in Access 2016 introduction, noting hidden fields still affect results through sort and criteria.

Create multi-table queries by adding categories, products, and orders, using established relationships to expand results and learn about joins, junction tables, and pass through relationships.

Learn practical tips for troubleshooting common query design mistakes in Access 2016, including removing duplicate tables, navigating the design view, rearranging fields, and avoiding accidental action queries.

Explore how reports from Access 2016 transform table or query data into print-friendly, polished outputs. Learn to create, format, and export reports as print-ready PDFs or Word documents.

Explore five report creation options in Access 2016, including report, report design, blank report, report wizard, and labels, and learn how to connect to tables or queries, groupings, and sorting.

design the report layout on paper or in your head, design the underlying query, then preview and tweak the report in layout view to produce a print-ready, effective result.

Learn to use the AutoReport tool in Access 2016 to create and customize a report from a query, and perform design view edits to adjust layout and remove outlines.

Use the report wizard in Access 2016 to create reports from queries or multiple tables with grouping by category and product, and customize layout.

Create a report in design view based on qryCustomerSales, set the record source, and add fields, then group by company name and sort by order date newest to oldest.

Create labels from a contacts table with the report wizard, arrange salutation, first name, last name and address fields, sort by last name, name the report, and print.

Forms enable data entry and retrieval from table-based data, presenting one record at a time in a user-friendly interface, with options to display non-table data and secure the data.

Create forms in Access 2016 using form, form design, blank form, and form wizard with tables or queries, plus navigation forms and datasheet view, split form, and dialog box forms.

Create forms from a table using the auto-form tool, then refine with design, form, and layout views, control fields, sub-forms, and proper naming.

Navigate forms in access 2016 using tab, shift+tab, arrow keys, page up/down, and control+end; customize navigation options, including subform controls, to fit your form design.

Edit or enter data in a form linked to a table; adding and editing records auto-saves to the table. Changes reflect back and forth between form and table.

Learn to use the Access 2016 form wizard to build single- and multi-table forms by selecting fields, choosing layouts (columnar, tabular, datasheet, justified), and creating subforms for categories and products.

Explore the form design view in Access 2016, covering headers, detail sections, and footers, then configure labels and controls, adjust properties, tab order, arrangement, and formatting.

Explore bound and unbound controls in Access 2016, learn how bound controls connect to fields, use unbound text boxes for formulas, and move, resize, delete, undo in design view.

Use the layout view to resize and reposition form controls while viewing data. Adjust sizes, move items, and see changes reflect in design view for forms and reports.

Learn practical tips for redesigning access forms, removing premade table layouts from the AutoForm tool, resize controls, and align and space fields using size and space options.

Explore the Access 2016 introduction by reviewing the Access environment, database terminologies and objects, creating databases, and core forms, queries, reports, and data handling.