Instructions

Create a new folder, titled, Access Exam Folder in your personal folder or on your desktop. Save the

files from the Practical Component page to your Access Exam Folder:

ABL Library

$\_$

Master

$\_$

Database.accdb

ABL

$\_$

Member.xlsx

ABL

$\_$

Return.txt

Complete the following steps using any technique you wish.

$1$

$.$

Open the database file, ABL Library

$\_$

Master

$\_$

Database.accdb. Change the title of the database to

ABL Library

Books for Everyone.

Note: The tblBooks and tblBorrowers tables are already populated with data.

$2$

$.$

Create the following tables and fields:

a

$.$

tblMembers

Field Name Data Type Description

MemberID Number A unique ID for a member

Field Size

Required

Indexed

Long Integer

Yes

Yes

$($

No Duplicates

$)$

MemberFirstName Short Text First name of the member

Field Size

Required

Allow Zero Length

Indexed

$2$

$5$

No

Yes

No

MemberLastname Short Text Last name of the member

Field Size

Required

Allow Zero Length

Indexed

$2$

$5$

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?

super answer and Iam so happy