web analytics

Category Archives: Access

UNDERSTANDING THE DATABASE DESIGN IN MICROSOFT ACCESS 2010 – PART 2

Microsoft Access 2010

This is PART 2 of the lesson of explaining the database design in Microsoft Access 2010.

First look at the reports people are doing now and ask:

  • Which ones they want to keep?
  • Which they don’t need?
  • and what they would like to have?

Next, lay out the reports as people would like to see that you can change the report layout later, but it’s important to see what data you will need. After you have developed your reports make a list of the types of data in the reports. For example, some reports might have customer information including first name, last name and address. In your lists note which reports contain each type of data.

The customer’s first name might be used in the customer list report, the invoices report and a holiday form letter. After you have listed all of the data in your reports, group the data into categories, such as:

  • customer data
  • sales data
  • and product data

UNDERSTANDING THE DATABASE DESIGN IN MICROSOFT ACCESS 2010 – PART 1

Microsoft Access 2010

This lesson will teach you about the importance of planning in database design and the five steps that you can use to design a database, at the same time learning what kind of data to include in a database.

1

ELEMENTS OF THE MICROSOFT ACCESS 2010 WORKING SCREEN – PART 1

Microsoft Access 2010

This article will show you the basic elements of Microsoft Access 2010 and explain the function of these elements. Also this article will cover how some elements vary depending on which objects are open.

At the top of the working area Access has a title bar and a windows control button. On the left end of the title bar is the quick access to a bar which contains frequently used commands such as redo and undo.

1

You can customize the quick access bar to add any buttons you want. For example if you use the print command frequently you could have the quick print button to your quick access tool bar.

ELEMENTS OF THE MICROSOFT ACCESS 2010 WORKING SCREEN – PART 2

Microsoft Access 2010

This article is the second part of the topic: Elements of the Microsoft Access 2010 Working Screen.

6. Now the customers table is in front and the customers tab is highlighted to indicate that it is the active table. Whether you open multiple tables, queries, forms, reports, macros or any combination of these you’ll be able to move among them by clicking the tab you want and once the database object is open you can close it without closing other objects, by simply clicking the close button in the upper right corner of the object window. Now close the customers table.

1

EXPLORING THE NAVIGATION PANE IN MICROSOFT ACCESS 2010

Microsoft Access 2010

This article explores the Navigation Pane in Microsoft Access 2010. It will teach you how to use the Navigation Pane to view and organise database objects and also how to search for database objects by name.

The Navigation Pane is on the left side of the Microsoft Access window. This pane contains links to all of the objects in the database. By default objects are grouped by their type, such as Tables, Forms, Queries, Reports and Macros. However Access allows you to group the objects in many ways and to search the objects based on their names.

1