Categories:
Administration (10)
Adware Spyware (7)
Apache (10)
Bluetooth (125)
DOS Commands (1)
Edge (28)
General (2)
Internet Explorer (217)
Media Center (12)
Media Player (11)
Mozilla Firefox (18)
PHP (15)
Programming (8)
Security (4)
Silverlight (15)
Tips (17)
Tools (218)
Tutorials (5)
Windows 10 (166)
Windows 7 (636)
Windows 8 (1091)
Windows Phone (33)
Windows Server 2008 (165)
Windows Server 2012 (84)
Windows Server 2016 (23)
Windows Vista (52)
Collections:
Other Resources:
Creating a Standard Columnar Form
I have created a table in MS Access. How do I create a form to help enter data into the table?
✍: FYIcenter.com
Assuming you have a table in MS Access called Account with these columns:
id - AutoNumber: The primary key giving of each account. client_id - Number: A foreign key pointing to the Client table. bank_id - Number: A foreign key pointing to the Bank table. name - Text: The name of this account. ref_number - Text: A reference number for this account. status - Text: The status of this account. remark - Text: Any notes for this account.
This tutorial shows you how to create a standard columnar form with the form wizard in MS Access 2000.
1. Click "Forms" in the Objects list. Then "Create form by using wizard". The "Form Wizard" dialog box shows up.
2. Select "Table: Account" in the Tables/Queries list. Then click ">>" icon to select all Available fields. Click Next. The layout selection shows up.
3. Select Columnar and click Next. The style selection shows up.
4. Select Standard and click Next. The title question shows up.
5. Enter "Account Form" as the title and click Finish. The simple standard form is created for the Account table.
6. Click ">*" icon at the bottom of the form to enter
a new record in form as show in the picture below:
2017-10-02, 30766👍, 1💬
Popular Posts:
Whenever I try to open the mail app I get a white screen with a grey banner that says Mail Can't Ope...
How much memory can I free up by disabling unnecessary Windows services? If you are buying a new com...
How to dump the list of all processes that are running on my Windows 7 system? I want save names of ...
Can I disable Windows service "OracleServiceXE" to speedup my computer? Third party application serv...
What is the startup program "QuickSet MFC Application - quickset.exe" on my Windows 8 computer? Can ...