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
tableField Name,Data Type,DescriptionMemberIDNumber,A unique ID for a membertableField SizeRequiredIndexedtableLong IntegerYesYes No DuplicatesMemberFirstNameShort Text,First name of the membertableField SizeRequiredAllow Zero LengthIndexedtableNoYesNoMemberLastnameShort Text,Last name of the membertableField SizeRequiredAllow Zero LengthIndexedtableNoYesYes Duplicates OKMemberStatusShort Text using Lookup Wizard create the following dropdown list Admin, Active, Blocked, Unknown,What is the current status of the member?tableField SizeRequiredAllow Zero LengthIndexedtableNoYesNo
Import and append data from ABLMember.xisx in the tblMembers table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
