Question: Create the following tables and fields: a . tblMembers table [ [ Field Name,Data Type,Description ] , [ MemberID , Number,A unique ID for

Create the following tables and fields:
a. tblMembers
\table[[Field Name,Data Type,Description],[MemberID,Number,A unique ID for a member],[\table[[Field Size],[Required],[Indexed]],\table[[Long Integer],[Yes],[Yes (No Duplicates)]],],[MemberFirstName,Short Text,First name of the member],[\table[[Field Size],[Required],[Allow Zero Length],[Indexed]],\table[[25],[No],[Yes],[No]],],[MemberLastname,Short Text,Last name of the member],[\table[[Field Size],[Required],[Allow Zero Length],[Indexed]],\table[[25],[No],[Yes],[Yes (Duplicates OK)]],],[MemberStatus,Short Text (using Lookup Wizard create the following drop-down list - Admin, Active, Blocked, Unknown,What is the current status of the member?],[\table[[Field Size],[Required],[Allow Zero Length],[Indexed]],\table[[255],[No],[Yes],[No]],]]
Import and append data from ABL_Member.xisx in the tblMembers table.
Create the following tables and fields: a .

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!