You created the basic table structure within a database. To keep data in these tables current, you need to know how to add, delete, and update data in a table. (Lesson Introduction)

Learn how to modify table data. (Autocorrect, Commit, Save and Undo)

The Record navigation bar Search text box provides a quick means to jump to a specific record. (Search box)

The Find and Replace dialog box enables you to quickly locate and change database information. (Find, Replace)

The term "ask questions" might be a little unfamiliar at first, but learn why database developers use that term frequently.

Learn how to use the Totals row to add summary values to a table. (Totals (count of records or the sum, average, maximum, minimum, standard deviation))

As you work with a database, it can be helpful to temporarily sort or filter a table to show only records that match certain criteria. (Sort, Filter)

Now it gets exciting, because queries allow you to work with data in a very flexible way. (Lesson Introduction)

The Simple Query Wizard prompts you through steps to create a query. (Query Wizard)

Learn how to use the Query Design feature to create a new query in Design view. This tool give you the maximum flexibility creating the queries you need. (Query Design, Naming Conventions)

Learn how to use query criteria to specify which records should be included in a query result. (Comparison Operators (=, <, >, etc.). Logical Operators (AND, OR, NOT))

You can use various wildcard characters in conjunction with query criteria. Wildcards enable you to match records based on patterns, rather than requiring a literal character-by-character match. (Wildcards (*, #, ?, etc))

(Date, Range, The Zoom Dialog Box)

In a large table, it may be difficult to work with records if they are not displayed in a useful order. (Sort, Multi-Level-Sort)

In many instances, you will need to perform calculations on the data stored in your database. Because the tables already store the data that will be used to perform the calculations; therefore, the calculations should be executed in queries, forms, and reports. (Arithmetic Operators (+, -, *, /, ^), Expression Builder)

If your Access desktop database is going to be used by multiple users, a well-designed form is essential for efficiency and data entry accuracy. (Lesson Introduction)

Working in a database will only takes you so far, Forms display and change data, accept new data, and interact with the user. (Form View, Form Wizard)

Navigate in Forms, Search for Records, Filter Records, Sort Records

Learn why properties are used extensivly in forms and reports.

Properties are named attributes of controls, fields, and database objects. Learn how to set properties to modify the characteristics of a control, field, or object. (Property Sheet, Hide Fields, Hide Ribbon Commands)

A lookup field is a field in one table that is bound to another value in a source data table or value list. The lookup field can a display a list of user friendly values to select from. (Lookup Fields, Relationships View, Foreign Key, Control Wizards, Combo Box, Referential Integrity)

As your database starts to accumulate useful information, you may want to produce reports that you can use for analysis and subsequent publishing to print or digital form.

Learn how to create a report that includes all the fields in a table or query. 

The Report Wizard guides you through steps to create a report based on one or more tables or queries, enabling you to select which fields you want to include in the report. (The Report Wizard)

The various tools used to generate a report are often able to create most or all of the controls and layout for you. However, there are times when you will need to add controls manually. (The Report Design view, Report Sections (Headers, Detail, Footers), Controls)

Access provides numerous options to enhance the appearance of a report. For example, you can apply color themes and font styles, and add graphics to any band in a report design. (Themes, Add Images)

When you print a report, you may find that the report contains too much information to fit within a page. It is often necessary to adjust page setup and layout options when you first set up a report for printing. (Page Size, Margins, Print Preview)

Reports that use grouping or display summary information are easier to understand. In this topic, you will organize information this way. You'll expand upon simple report designs to create attractive, informative printouts. (Group, Sort, and Total Pane, Group Headers and Footers)

You may want to enhance a report's appearance. In this topic, you will format reports as well as control pagination. This results in a professional-looking report that captures the reader's attention. (Report Control Properties, Report Pagination, Keep Together Property, Force New Page Property)

Congratulations! You have completed the Access 2016: Part 1 (Beginner) course.

In Part 2 of this course you will expand your knowledge of relational database design, write advanced queries, validate data and customize reports.

Click here to go directly to the next level of Access 2016: Part 2 (Intermediate):

https://www.udemy.com/microsoft-office-access-2016-part-2/