Tips While Designing a Form

While designing a form in Microsoft Access may seem easy, there are several factors that must be considered. Form design is a critical component of user interface design since it is the way people interact with the computer. User interface design is a science that encompasses design ergonomic factors, ease of use and understandability all into one package.

By Admin

Creating an Import Specification in Access 2003

When you want to import text files in Access it can be saved as a specification and imported using VBA code. Below is the step-by-step process for creating an Import Specification.

By Admin

Creating a New Form in Design View

In the Database window, select Forms from the options located on the left toolbar. Next, click on the New button which is located at the top of the screen.

By Admin

How to Design a Query

Under the Microsoft Access View menu, point to Database Objects, and then select Queries. See the example below.

By Admin

How to Add Criteria to Your Query

You may want to add selection criteria to your query. Select the qryBookAuthor query that was created in the previous section, and then click Design to open the query in Design view.

By Admin