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 backstage view, open existing databases, and start from ready-made templates for desktop or web databases, including assets and Northwind 2007, to accelerate your Access projects.

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.

Explore how the Access 2010 navigation pane can act as a switchboard, enabling filtering by object type and showing related objects to work with tables and queries.

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.

Access adds new records only at the bottom of a table; typing creates an edit-mode record that saves when you move off, while sorting and reporting reveal information from data.

Use the search text box in Access 2010 to quickly locate records by typing initials; it moves through the table to the first matching record and updates as you type.

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.

Reorder columns in an Access 2010 table by dragging a header to change order, while changes affect only appearance, trigger a save prompt, and you can use filters and sorting.

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.

In access 2010, add text fields for first and last names, set field sizes, use caption to display spaces, and format the date of birth as date time with formats.

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.

Explore how Access validates date input, enforces date time data types, and distinguishes numeric, currency, and text fields, guiding proper conversion and using unique identifiers to organize tables.

Learn how to modify a table in Access 2010 using datasheet view, add fields on the fly with quick add and predefined field options, and choose data types and formats.

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.

Learn to create a calculated total field in Access 2010 by multiplying quantity by unit price, format as currency, and use totals to compute grand totals and order counts.

Explore subdatasheets to view related orders for a customer by linking master and child fields (ID and customer ID) in a relational database.

Learn to use the query wizard in Access to create simple select queries, explore crosstab (pivot) queries, find duplicates and unmatched records, and use design view to enter criteria.

Master the access query design view to build select and action queries, using the grid to choose fields, sort, and control visibility with show options.

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.

Create a single record user interface by using the form wizard to build a customer form, configure a columnar layout, and understand navigation controls, record selectors, and the search feature.

Use layout view in Access 2010 to modify a form while viewing data, resize for real devices, and apply themes that update headers and fonts across forms and reports.

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 a form in Access 2010 with the form button, note the underlying invisible table keeps controls aligned, then switch to design view to convert to individually resizable controls.

Learn how labels accompany bound text boxes in Access forms, linking to the Customers table’s id and name fields, and how to add, delete, resize, and align them.

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 how to design in Access 2010 by selecting, moving, and resizing controls, using grid and tabular layouts for forms and reports, and mastering page setup and margins.

Explore how Access reports use bands—report header, page header, detail, and group header—to organize data by state, print elements on every page, and control layout.

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.

Set up Access 2010 reports with page layout mastery: adjust margins, paper size, orientation, and columns; select printers and print options while using grids and queries to optimize data presentation.

Explore the essentials of Microsoft Access 2010, from navigating the backstage view to creating tables, queries, forms, and reports, and discover the power of select queries and interfaces.