Access 2010 Introduction

Discover how to navigate Access 2010 with the backstage file tab, manage objects in the navigation pane, and use the status bar and view options to work efficiently.

Explore the Microsoft Access 2010 ribbon and the core objects (tables, queries, forms, and reports), along with backstage view, compact and repair, password encryption, and external data tools.

Open the Northwind 2007 database in Access to explore the navigation pane, work with the data table, add records, and use field quick filter for filtering.

Navigate Microsoft Access 2010's tabbed tables interface, switching between customers and employees, while editing saves automatically and you resize fields and rows with record selectors.

Use the field quick filter button in Access 2010 to sort by ascending or descending order, apply text filters (equals, begins with, contains), and filter dates with a calendar.

Create a brand new database and design a new table in design view, explore datasheet view, learn data types, add fields and predefined fields, and save records.

Explore the different data types in Access 2010, including text and memo fields, numbers, date time, currency, boolean, OLE object, hyperlink, attachment, calculated fields, and lookup.

Learn to create calculated fields in Access 2010 by using the expression builder, concatenate last and first names with a comma and space, and display results in a data sheet.

Learn how predefined fields in Access 2010 datasheet view automatically add multiple fields, such as an address field that inserts address, city, state/province, zip/postal, and country/region, with zip/postal as text.

Learn how to use find and replace in Access 2010 to search and replace across fields, with guidance on case sensitivity and wildcards.

Create a new query in Access 2010 Introduction by using the products table, selecting all fields with star, and applying a fourth-position s criterion.

Learn to select, move, and resize form controls in Access 2010, adjust properties, arrange and align controls, and create a consistent form design that minimizes scrolling.

Create and customize Access reports with the report wizard, choosing fields, sorting, and layout, previewing and refining the design to fit on a single page for printing or on-screen viewing.

Learn the two main report controls—labels and text boxes—and how page footers show the date and time in long date format, plus page x of y for pagination.