Department Directory | Highline College
Access Homework Problem: “Create Personal Contact Database”Steps for Homework Problem:Create a new database with the name “Your Name Contact Database”.Create a Table with the name ContactsFor the Table “Contacts”, create the following Fields with the following Field Names, Data Types and Field Properties:Contact IDData Type = AutoNumberNote: Make this Field the Primary KeyFirst NameData Type = Short TextField Properties:Field Size = 25Last NameData Type = Short TextField Properties:Field Size = 30AddressData Type = Short TextField Properties:Field Size = 150CityData Type = Short TextField Properties:Field Size = 75StateData Type = Short TextField Properties:Field Size = 2Input Mask = >LLZip CodeData Type = Short TextField Properties:Field Size = 9Input Mask = 00000\-9999Cell PhoneData Type = Short TextField Properties:Field Size = 10Input Mask = \(000”) “000\-0000Highline StudentData Type = Yes/NoCreate a Form for the “Contacts” Table and name it “Contacts”.Add these five contact records:Note: When entering records, the AutoNumber (Contact ID Field) will automatically create the number for you. You do not need to enter any data for this field.Create a Query that shows Contact Records (All Fields except Contact ID) when the City Field is Seattle AND the Highline Student Field is Yes. Uncheck the “Show” option in the Query Grid for the Highline Student Field. Name the Query something smart like “Highline Students in Seattle”.Create a Report based on the “Highline Students in Seattle” Query. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- wyoming phone directory white pages
- u of i directory staff
- holiday inn directory usa
- alabama education directory website
- department of education college accredit
- minecraft directory folder
- department of education college transcripts
- doctor directory by name
- department of education college accreditation
- department of education college statistics
- ohio department of education college credit plus
- department of education college data