A Quick Overview Of Access 2013

Microsoft Access 2013 Plain & Simple is divided into sections, and each section has a specific focus with related tasks. To help you understand how to move around and use the book, I’ll now provide a quick overview of the book’s structure.

Section 2, “Creating a custom Web App,” introduces the idea of creating a Web App and navigating around the key components in the interface. Here you will see how the productivity of the desktop is transferred into creating a browser-based interface for your application.

In Section 3, “Modifying a Web App,” we delve a bit deeper under the hood and see how you can add to a custom Web App to create your own views of data, create queries, and use other techniques.

to create a desktop database, and we cover creating tables and relationships, which are key to understanding best practices when building a database.

In Section 5, “Working with data in datasheets” (datasheets are an often overlooked feature in Access), I provide a wide range of techniques for getting the most out of your datasheets.

In Section 6, “Selecting data using queries,” you’ll discover how queries lie at the heart of relational databases. They allow you to bring data together from tables and exploit calculations, parameterization, and many other features.

In Section 7, “Modifying data using queries,” I demonstrate both simple and more complicated updates to your data. Action queries offer you features that allow you to perform bulk updates on data.

In Section 8, “Improving presentations with forms,” we will explore a landscape of many more advanced presentation features. Forms also allow you to integrate and extend basic datasheet presentation features.

In Section 9, “Using controls effectively,” you will enhance your forms and get an understanding of the wealth of controls available in Access.

In Section 10, “Preparing data to print using reports,” you will discover a fantastically rich reporting tool, which will allow you to create everything from a simple data list to a complex invoice and then print the results.

Section 11, “Exchanging data,” shows how Access allows you to both import and export data. For many applications, the ability to link dynamically to data in other systems makes Access a number-one choice for bringing together data from different systems and reporting on it.

In Section 12, “Introducing the power of macros,” you will discover a unique approach to automating operations and providing more sophistication to your application. In this section, I get you started with several key examples.

In Section 13, “Administrating a database,” we look at maintaining your database in good health and securing your data, together with a quick look at tools for improving the design of your database.