Control how an Access file looks and behaves when it opens
You can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file. You can also use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

---

AutoExec Macro in Microsoft Access
In Microsoft Access you can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file. You can also use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

---

Create a macro that runs when you open a database
If you want to perform a particular set of actions every time that a database starts, you can create an AutoExec macro. For example, you might want to maximize the database window, lock the Navigation Pane, and then open a particular report. An AutoExec macro is just a macro that is named AutoExec. When a database starts, Access runs the AutoExec macro before it runs any other macros or VBA code. (Applies to: Microsoft Office Access 2007)

---

Startup options
You can use startup options to control how a Microsoft Access file looks and behaves when it opens. The startup options apply only to the current Access file. The startup properties don't override the property settings for a specific toolbar, menu bar, shortcut menu, form, or report. For example, the Menu Bar and Shortcut Menu Bar options in the Startup dialog box don't override the property settings for specific forms or reports that have a custom menu bar or shortcut menu. Thus, when you open a form or report, Microsoft Access displays the custom menu bar attached to the form or report instead of the global menu bar specified in the Startup dialog box. You can also create an AutoExec macro to carry out an action whenever an Access file opens. You can use the Startup dialog box instead of or in addition to an AutoExec macro. An AutoExec macro runs after the startup options have taken effect; therefore, you should avoid any actions in an AutoExec macro that change the effect of the startup option settings. For example, if you specify a form in the Display Form/Page box in the Startup dialog box, and you also use the OpenForm action in an AutoExec macro, Microsoft Access first displays the form specified in the Startup dialog box, then immediately displays the form specified in the OpenForm action.

---

Splash Screens in Microsoft Access
When Microsoft Access opens, the first object that opens up by default is the database window. Most of the time you would not like to give your users access the this window, so you can hide this and display your own form or switchboard. To enable you to show your own Microsoft Access form when the database opens you should create an unbound form and use the Access Start Up options to set this form to open up whenever the database is started.

---

Microsoft Access Tutorial
This tutorial consists of the following lessons: About Microsoft Access; Create a Database; Create a Table; Adding Data; Create a Form; Modify a Form; Create a Query; Modify a Query; Create a Macro; Convert Access Database to Excel; Microsoft Access versus SQL Server.

---

Microsoft Access Macro Conditions
In this article, we're going to create a conditional macro - that is, a macro that only launches when certain criteria are met. There's no VBA involved, it's all strictly through the Access interface.

---

Queries on Steroids - 2
Learn how to write a query in Access that points to and opens data in a remote Microsoft Access database without linking to it first.

---

Introduction to Queries
A query is the result of getting or isolating a list of values from a table or another query. Querying is the technique of examining data to create a dependent list. You can perform querying on a table, a form, or a query. Microsoft Access provides various means of performing such an operation visually. As an alternative, Microsoft Access supports SQL that allows you to query a database using code. There are various ways you create a query in Microsoft Access.

---

How to Determine Which Query to Use in Microsoft Access
You can select from five query types in Microsoft Access: select query, SQL query, crosstab query, parameter query or action query. These instructions apply to Access 97.

---

Microsoft Access Macros vs. VBA - Why Use Macros?
Macros have been used as development tool since the early days of the Microsoft Office product line. Microsoft Access macros incorporate generalized database functions using existing Microsoft Access capabilities. Errors in a macro can be easily resolved by using the Microsoft supplied Help function. The ease with which you can generate Macros makes Macro development seem easier to accomplish...

---

OpenQuery Macro Action
You can use the OpenQuery action to open a select or crosstab query in Datasheet view, Design view, or Print Preview. This action runs an action query. You can also select a data entry mode for the query.

---

Create a Macro
Microsoft Access provides the ability for you to create macros. A "macro" refers to a set of actions that can be run automatically, and on demand. You could make a macro run when a user presses a certain key, or you could make a macro run everytime your database is opened.

---

Microsoft Access FAQs
What is a Table? What is a Query? What is a Form? What is a Report? What is a Macro?

---

Types of Macros in Microsoft Access
A macro is an object like other objects available in Microsoft Access (tables, queries, reports etc.), except that you create the macro to automate a particular task or series of tasks. Typically, macros on Microsoft Access forms can be grouped into categories depending on the function that they perform; the macros in each category contain unique instructions that enable them to perform the indicated tasks.

---

Using Macros to Automate Data Entry
As you will have seen in the previous topic, we can use Macros to Require Data Entry and to inform users of any errors made in the data entry routine. We can also use Microsoft Access Macros to speed up the process of data entry. We can use a macro to remove the need for a user to enter the same data over and over for each record, we can use a macro to automate this process. A Microsoft Access macro is a database object that allows us to automate repetative tasks without having to write complex programming routines. In Access, these tasks that the macro performs are know as macro actions.

---

Create a macro
You can create a macro (macro: An action or set of actions that you can use to automate tasks.) to perform a specific series of actions (action: The basic building block of a macro; a self-contained instruction that can be combined with other actions to automate tasks. This is sometimes called a command in other macro languages.), and you can create a macro group (macro group: A collection of related macros that are stored together under a single macro name. The collection is often referred to simply as a macro.) to perform related series of actions. In Microsoft Office Access 2007, macros can be contained in macro objects (sometimes called standalone macros), or they can be embedded into the event properties of forms, reports, or controls. Embedded macros become part of the object or control in which they are embedded. Macro objects are visible in the Navigation Pane, under Macros; embedded macros are not. What do you want to do?: Learn about the Macro Builder, Create a standalone macro, Create a macro group, Create an embedded macro, Edit a macro, Use conditions to control macro actions, Learn more about macro actions.

---

Introduction to macros
This article explains what macros are and how they can save you time by automating tasks that you perform often. It explores the fundamentals behind creating and using macros and also touches on improvements to macros in Microsoft Office Access 2007. In this article: What is a macro? Understand macros; New macro features in Office Access 2007; Create a macro; Run a macro.

---

Introduction to macros
This article explains what macros are and how they can save you time by automating tasks that you perform often. It explores the fundamentals behind creating and using macros and also touches on improvements to macros in Microsoft Office Access 2007. In this article you'll learn: What is a macro? Understand macros, New macro features in Office Access 2007, Create a macro, Run a macro.

---

Run an Access macro by using a keyboard shortcut
You can assign an action (action: The basic building block of a macro; a self-contained instruction that can be combined with other actions to automate tasks. This is sometimes called a command in other macro languages.) or set of actions to a specific key or keyboard shortcut by creating an AutoKeys macro group (macro group: A collection of related macros that are stored together under a single macro name. The collection is often referred to simply as a macro.). When you press the key or keyboard shortcut, Microsoft Office Access performs the action.

---

Creating Union Queries
Microsoft Access allows you to create various query types using the QBE (Query By Example) pane. There are also various other queries that you can create in Microsoft Access, however you will need to create these by typing in the appropriate SQL (Structured Query Language) directly into the SQL view window when in query design.

---

Create a Delete Action Query in Microsoft Access
By creating a Delete action query in Microsoft Access, you can automatically delete a group of records from one or several tables. For example, in your CD database, you could use a delete query to delete all records pertaining to a CD that you have thrown out. A Delete action query is one of the four types of action queries that Microsoft Access allows (Delete, Update, Append, and Make-Table). These instructions are for Access 97.

---

Get answers with queries
Find out how Microsoft Access queries enable you to answer questions and perform tasks with your data. Learn how to create a select query, the most common type of query. After completing this course you will be able to: 1) Create a select query. 2) Refine a query in Design view. 3) Retrieve data that matches the criteria you specify. (Microsoft Office Access 2003)

---

Showing a Please Wait/Progress Macro
There maybe occasions where you will need to display a message to inform your user's that they must wait for an action or process to be completed. You may want to display the text "Database Loading" whilst Access initializes a large database, or display the text "Please Wait" whilst Access runs a long query.

---

Create parameter queries that prompt users for input
A Microsoft Access parameter query is useful when you perform the same type of query often, but the values that you search for change. If you're familiar with the basic select query, learn how to turn it into a parameter query. After completing this course you will be able to: 1) Understand when and how to use parameter queries. 2) Set up and run a parameter query that prompts you for the data you want to find. 3) Set up a parameter query that retrieves all the data between two values. (Microsoft Office Access 2003)

---

Queries On Steroids (Part II)
No, I'm not pulling your leg. Today we'll see how you can write a query in Access that points to and opens data in a remote Microsoft Access database without linking to it first. I've created a demo database that pulls data, simply and dynamically, from a PubsData database and you can play with it yourself in this download.

---

Macros
A Macro is a set of actions you ask Microsoft Access to perform in order to automate some behavior in your application. A macro can be used to open a table, a form, a report, or a Data Access Page in any view of your choice.

---

RunSQL Macro Action
You can use the RunSQL action to run a Microsoft Office Access 2007 action query by using the corresponding SQL statement. You can also run a data-definition query.

---

Require Data Entry with a Microsoft Access Macro
If you are using a Microsoft Access database application for data entry you will want to ensure the quality of the data that is being entered. Validating data in Microsoft Access allows you to check data whilst it is being entered into the database, and there are various ways of performing these actions. You don't want to be trying to ship an order to a company that does not have address details associated with it. If you don't have a contact name associated either, you can't even call to find the data. Creating a Microsoft Access macro to require data entry into certain fields will prompt the database user to complete this vital information. This will in turn deem your data to be more accurate and useful to all database users.

---

Set the default form that appears when you open a database
In many database applications, it is helpful to have the same form open automatically every time that you open the database. The simplest way to set the default startup form is to specify the form in Access Options. You can also create an AutoExec macro to perform actions when a database starts. For more information, see the article Create a macro that runs when you open a database.

---

Microsoft Access Query Types
Queries are very useful tools when it comes to databases and they are often called by the user through a form. They can be used to search for and grab data from one or more of your tables, perform certain actions on the database and even carryout a variety of calculations depending on your needs. Luckily for us, Microsoft Access allows for many types of queries, some of the main ones being select, action, parameter and aggregate queries. They can be thought of as just another part of your database essentially an object like a table or a macro.

---

Jump Start VBA Skills with MS Access Macros
Macros help to speed up the performance of certain repetitive tasks when using an application. They are used extensively in all office-related software. As a programmer, you can leverage the built-in macro object in MS Access to get a head start in understanding VBA. This article explains how. TOC: Jump Start VBA Skills with MS Access Macros; Creating and running a macro in MS Access: opening the macro designer; Creating the first macro; Converting this macro to VBA code; Creating the second macro.

---

Creating a Delete Query in Microsoft Access
A Microsoft Access delete query deletes records from a single database table or database tables. Of all of the different action queries available in Microsoft Access (Append Queries, Update Queries, Make-Table Queries and Delete Queries) the delete query is one of the most dangerous. Unlike the others mentioned, the Microsoft Access delete query will remove records from your tables permanently and forever. As with the other types of action queries, the delete query will work with a group of records that meet a specified criteria that you apply. You can use the delete query to remove all records or only records that meet the defined criteria.

---

Export Query from Switchboard
I would like to export a query to an Excel document through my Switchboard. There are options on the Switchboard to "Run Macro" or to "Run Code". When these are selected it provides a field for a "Macro" or "Function Name" to be entered. I would like to click the button on the Switchboard, have the desired Query ran and exported to a designated file location as an excel spreadsheet. I would appreciate help with the creation of the function to do such a task. I'm open to using Macros or Code; whichever would be more appropriate for the application. I'm running MS Access 2000. Currently, there are no Macros in my database. I do have some Code in parts. I appreciate the help. Thanks!

---

Delete Action Query
By creating a Delete Action Query in Microsoft Access 2003, you can automatically delete a group of records from one or several tables. For example, in your CD database, you could delete all records pertaining to a CD that you have thrown out. A Delete Action Query is one of the four types of action queries that Microsoft Access allows (Delete, Update, Append and Make-Table). Here's how to create a Delete Action Query in Access 2003.

---

Test a macro by using Single Step mode
By single stepping (single stepping: A debugging technique that enables you to run a macro one action at a time or run Visual Basic code one line at a time.) through a macro (macro: An action or set of actions that you can use to automate tasks.), you can observe the flow of the macro and the results of each action (action: The basic building block of a macro; a self-contained instruction that can be combined with other actions to automate tasks. This is sometimes called a command in other macro languages.), and isolate any action that causes an error or produces unwanted results. (Applies to Microsoft Office Access 2007)

---

How to Create a Microsoft Access Macro to Import Information from a Text (.txt) File
Macros are operations used in Microsoft Access in order to automate functions in databases. They can be used to open reports, run queries, update the databases and import from various file formats such as Excel (.xls), database, (.dbf), and text (.txt). This article will explain, in a step-by-step format, how to import information from a text file, format the information for Access, and create the macro so each step will not need to be created every day. This will save you time and put some of the database operations into the hands of the end-users and freeing you to do other things. Prior to creating the macro, the creation and saving of the import specification will be explained.

---

Open Forms with Hyperlinks in Listbox
We have seen in the previous example that all our Forms can be organized in one place with the use of a ListBox and can Open the Form by Double_Clicking an item in the list. As a result, based on the value in the Type field of the control table, a Form opens directly or runs a macro to perform a sequence of operations to prepare the output before opening a Form with the processed data linked to the Form. The objective of this method that we are going to try out here is same, but we will do it differently. It is better to know more than one method, which we can use in our various Projects, rather than using the same thing everywhere. For this example we need to design a small form (not a listbox) and make it look like a listbox.

---

CancelEvent Macro Action
You can use the CancelEvent action to cancel the event that caused Microsoft Office Access 2007 to run the macro containing this action. The macro name is the setting of an event property such as BeforeUpdate, OnOpen, OnUnload, or OnPrint.

---

Microsoft Office Access 2007: 13 Pages
Contents: Tables and Relationships, Using Related Tables, Types of relationships, Viewing the Relationship window, Adding a Table in the Relationships Window, Setting Referential Integrity, Queries, Using Queries and RecordSets, Using the Simple Query Wizard, Creating a Query in Design View, Opening a Query, Adding a Table to a Query, Running a Query, Sorting a Query, Adding Criteria to a Query, Using Comparison Operators, Using an OR Condition, Creating a Parameter Query, Creating a Calculated Field, Creating Aggregate/Function Query, Creating an Action Query, Using Multiple Tables in a Query. (PDF file, install Acrobat Reader to read this Microsoft Office Access 2007 tutorial)

---