Search results
Other videos in this course. This video is part of a training course called Design and build tables for a database (Access from the ground up, part 1). Training: How to create a new database file, and the types of databases you can create.
- 4 min
Create a blank form in Access. To create a form with no controls or preformatted elements: On the Create tab, click Blank Form. Access opens a blank form in Layout view, and displays the Field List pane. In the Field List pane, click the plus sign ( +) next to the table or tables that contain the fields that you want to see on the form.
It would help if you provided the entire SQL statement. You should be able to use "OR Is Null" in your WHERE CLAUSE. Generically this might look like: SELECT *. FROM tblYourTableName. WHERE Account_Number = Forms!YourForm!txtAcctNum. AND (Course_Date = Forms!YourForm!txtCourseDate OR Course_Date Is Null); Duane Hookom.
In this article, we will walk you through the process of creating a database in Microsoft Access. Step 1: Open Microsoft Access. To open Microsoft Access, click on the Windows Start button and search for Microsoft Access. Once you have located the program, click on it to open it. Step 2: Choose a Blank Database.
If there are forms click on the File tab in 2010 (or the Office button in 2007), and click on options>Current database. See what is in the box for the display (or startup) form. If nothing is in it look for a macro named AutoExec and open it in design view to see which form it is opening. That will be your main screen.
On the templates page, double-click Blank Database. Select File > Close. Select Database Tools > Compact and Repair Database. In the Database to Compact From dialog box, navigate to and double-click the database that you want to compact and repair. Access creates a copy of the compacted and repaired database in the same location.
The Get External Data - Access Database import and link wizard opens. In the File name text box, type the name of the source database or click Browse to display the File Open dialog box. Click Link to the data source by creating a linked table, and then click OK. The Link Tables dialog box opens.
