I have a project to complete by 10 Jul 15 (non negotiable).
strudw
charlene_senior_project_draft.docxAnnex B Stroud Page | 82
CAMPBELL UNIVERSITY INFORMATION TECHNOLOGY AND SECURITY STUDIES SENIOR PROJECT/ITS 465 INFORMATION SYSTEMS SECURITY NATIONAL SECURITY ARCHIVE INSTITUE:CONTROL ACCESS MANAGEMENT PROJECT SUBMITTED TO PROFESSOR UMESH VARMA A SECURITY ACCESS BADGE PROJECT PRESENTED TO CAMPBELL UNIVERSITY IN PARTIAL FULFILLMENT OF THE REQUIREMENTS FOR THE INFORMATION SYSTEMS SECURITY PROGRAM BY: CHARLENE STROUD Dec, 2014
ACKNOWLEDGMENT
First I would like to take this time and thank God the Father and Jesus Christ who I believe ordered my steps to go the distance while instilling me to uphold my Christian morals in everything I have accomplished.
Next, I would like to take this opportunity to thank my Information Systems Security instructor Mr. Varma for supporting me while obtaining my BA degree in Information Systems Security. I would also like to express my gratitude to him for showing me what skills I must acquire to become a successful Information Systems Security Manager responsible for developing, implementing and maintaining a Controlled Access Management Project. I would also like to show my gratitude to my classmates who were always willing to share their knowledge with me for the groundwork of my IT projects and for being truthful on a number of relative issues.
Finally, I want to thank Germaine and Kathy, my two daughters, for guidance and encouragement despite their heavy load they were always willing to lend me a hand when I needed to gather more information and resources to complete my project.
Charlene Stroud TABLE OF CONTENTS
Table of Contents ACKNOWLEDGMENT 2 List of Figures 4 Abstract 5 Problem Statement 7 Section 1: Introduction 9 Section 2: Feasibility Analysis 10 Operational Feasibility 10 Economic Feasibility 11 Strategic Feasibility 12 Scope Feasibility 13 Section 3: Software Requirements 14 Section 4: Server Specifications 15 Section 5 Database Management 16 Section 6: Database Relationships 17 Section 7: Physical Design 18 Section 8 User Interface Design 19 Section 9: Project Schedule 20 Section 10: System Support 21 Annex A 22 Appendix B 24
List of Figures
Figure 1: Organization Chart 6
Figure 5: Min Computer Requirements 14
Figure 6: Server Specifications: 15
Figure 7: Personnel Management Development Table 16
Figure 8: Database Relationships: 17
Figure 10: Form Wizard Employee Information 19
Figure 11: Form Wizard Visitor Information 19
Figure 12: Controlled Access Management Information 20
Figure 14: Request For Services 23
Figure 16: Database Document 25
Figure 19: Functional Decomposition Diagram 84
Abstract
The purpose of this Feasibility Study is to determine if creating an access control management system and a client database will improve performance and is economically adequate. If this proposal is acceptable it will implement a barcode badge system that will monitor all employees and visitors that access the building. The suggested proposal is an electronic security system that will alert a monitor team when an authorized person(s) enters the facility and restricted areas. The new structure and process will be subject to a set of criteria’s that will grant access and conditions to restrict unauthorized access. In turn, the National Security Archive Institute’s (NSAI) capability to issue, terminate and reissue security badges to employees and visitors while securing the integrity of the system and sponsoring a user friendly process that will decrease control access incidents by 80%. Data entry will be simpler, eliminating duplicate entries and improving accuracy without disclosing critical clearance and access data. The organization’s capability to retrieve badging information and activity reports will become instantaneous. Overall, the controlled access policy and procedures will provide a safe and secure environment for the NSAI’s employees and business assets.
Executive Summary Stroud Page | 6
Problem Statement
Currently, all visitor and employee access badges are a simple piece of plastic with a person’s name, picture and a number on it, enclosed in a plastic sleeve and lanyard so it can be worn around a person’s neck. The People Management Distribution Office purchases the control access badges from Kenberma’s Products, Incorporated and use paper records to log activities and create reports. There are two basic disadvantages to purchasing the laminate badges from vendors; one is their unique security features are used for massive clients which makes them easily duplicated allowing intruder’s unauthorized access to the facility and sensitive information. The costs associated with the current control access badge system is effective, however the program is not. The program does not identify or restrict current employee’s access privileges nor does it alert management on unlawful entry attempts. That means clearance information; restricted areas and access to information systems may require an encrypted security card making the program redundant. Consuming and inconvenient visitor request can become a nuisance and takes time away from other office priorities. Additionally, handwritten activity logs and reports are vulnerable to theft and are often illegible, rendering them useless. The current environment could become unstable for visitors and the establishment could face a future loss of employees and a blow to its reputation – leading to a loss of revenue for the organization. Best practice solutions are found in Figure 3.
Problem Statement Stroud Page | 8
Section 1: Introduction
Observation of the office indicates a large quantity of paper being used and discarded. It would be more practical and beneficial to move towards a paperless system. This would not only save money but will increase confidentiality. Currently when a handwritten visitor request form is submitted to the People Management Development Office the information is manually recorded in sequential order by date, these logs are used for visitor tours of 20 or more people. Then the form is couriered over to the Security Office where a local background check is performed. Upon passing the Security Office verifies the individual is suitable to participate in a tour of the National Security Archive Institute. The same request form and procedure is used for new employees, however they are stored in two different locations. It can take up to 48 hours to receive the background verification. A Microsoft Access Database would capture and store employee and visitor information such seen in Figure 16.
Introduction Stroud Page | 10
Therefore, only one database becomes necessary to process both an employee and visitors access badge using simple queries extracting specific data that applies to each activity badge. This will allow the Security Office to pull information for the background check directly from the database instead of waiting for a courier, ultimately decreasing the turnaround time and saving paper and courier man-hours.
Section 2: Feasibility Analysis
Operational Feasibility
The Microsoft Access database will provide better communication between the Personnel Management Development Office and the Security Office allowing them to process visitor and employee access badges; provide an automation record keeping and files system; and minimize the probability of an intruder entering the building without authorization while restricting authorize personnel to information and data on need to know basis (see Figure 18). As with any new controlled access management system there are advantages and disadvantages, for instance:
· Users are already used to computer navigation therefore training will only include learning how to use Microsoft Access software.
· Better efficiency and effectiveness in the maintenance of personal information details in the badge system reduce human errors and the cost of paper.
· Data retrieval and the data presenting will be done by the system so the report generation will be done automatically.
· In the future additional cost may be incurred in order to provide an online system for visitors to request tours using the internet.
· An increase in visitors and employee request for badge may require additional staff thus generating labor cost. However one should note that couriers and clerks using the current system will be reassigned.
The database will allow the Personnel Management Development Office to input personal data into the system and allow the Security Office to review new request to verify background and clearance information (See Figure 19):
· Last Name
· First Name
· Address
· City
· State
· Zip
As the organization grows this Access Database can be expanded to allow other users to access the employee database and create products that would improve the overall NSAI operations.
Economic Feasibility
The estimated cost for implementing and maintaining the system is shown below and include provisions for entering the historical data for this product in order to insure that the reporting methods are using all available data. Database connectivity has been assumed for 5 users on a Windows Server platform on one standalone copy of Microsoft Access 2013. The amount of users and additional hardware cost can be increased as needed:
Strategic Feasibility
Developing a strategic modernization plan to generate an automated security badging program will initiate and provide future capabilities in expanding advance technology to other internal office business practices using LAN connected PC (bar-coded badges) to mainframe. The current system has a virtual server that is being used by Deputy Director and their Assistant Managers in Government. Once the current virtualization server is set up to allow communication between the Security office and the People Management and Development office additional emphasis will be placed on security, authentication and specific permissions to login to the system. The new server is HYPER-V capable and has the capacity to store and manage the entire database. Once the new server is installed it will be capable of deploying disaster recovery integration on to the current server serving as a back-up system in the event the new server becomes inoperable.
Scope Feasibility
The benefits from constructing this database will create a balance solution towards cost, capability, and quality and response time. Response time for output and the ability to leverage relationships across the business units allows us to create security badges at the fastest possible speed. In turn, the controlled access management program will establish tools and processes that facilitate a single point of accountability to mitigate risk associated with managing the organization's facilities access points.
Feasibility Analysis Stroud Page | 13
Section 3: Software Requirements
The National Security Archive Institution is in the process to migrate Windows XP to Windows 7 supporting over 20 computers. With recent costs migrating to the new system it would also be a good time to consider reducing the cost to maintain all of the systems. Windows Virtual PC is the latest Microsoft virtualization technology. It can be used to run more than one operating system at the same time on one computer, and to run many productivity applications on a virtual Windows environment, with a single click, directly from a computer running Windows 7 and once the glitches are repaired, improvements can begin by upgrading to a Windows 8.1 Hyper-V and virtualize the entire company (see Figure 9).
The advantage of virtualization is that it can be ran many servers from one physical server however one must first determine the risk in data recovery and downtime. The server is fully expected to support the Security Office virtual platform and with appropriate security measures. The worst case scenario is that an additional server may be a necessary purchase as the proposed system expands to sufficiently back-up the system to minimize loss and data recovery. The minimum requirements to run the database software are noted in Figure 5:
Figure 5: Min Computer Requirements
Assumptions & Limitations Stroud Page | 15
Section 4: Server Specifications
Figure 6: Server Specifications:
Detail Study and Analysis of the System Stroud Page | 16
Section 5 Database Management
Both the Personnel Management Development and the Security Office will use the database.
Figure 7: Personnel Management Development Table
Fact Finding and Data Gathering Stroud Page | 18
Section 6: Database Relationships
Figure 8: Database Relationships:
Physical Model Stroud Page | 19
Section 7: Physical Design
System Modeling Stroud Page | 20
Section 8 User Interface Design
Figure 10: Form Wizard Employee Information
Figure 11: Form Wizard Visitor Information
Physical Design Stroud Page | 21
Section 9: Project Schedule
Figure 12: Controlled Access Management Information
User Interface Stroud Page | 22
Section 10: System Support
It is highly possible that the database expand to enhance the overall company's operations. Therefore, the best practice is to use online training for all employees in the event the database served to support other company business. The recommended Microsoft Office Access training is located at https://support.office.com/en-us/article/Training-courses-for-Access-2013-a4bd10ea-d5f4-40c5-8b37-d254561f8bce?ui=en-US&rs=en-US&ad=US. Employees will receive a code number to attend the training online. The following subjects will be covered during the training:
• Webinar: Intro to Access 2013
• Design and build tables for a database (Access basics, part 1)
• Create table relationships (Access basics, part 2)
• Create your first Access 2013 database
• Introduction to queries (Access basics, part 3)
• Make the switch to Access 2013
• Stop a query from asking for input
• Use criteria in your Access 2013 queries
• Use parameter queries to filter query results
• Use Update queries to change data in Access 2013
• Using date criteria in queries
Implementation Stroud Page | 23
Annex A
Figure 14: Request For Services
|
|
Phone: 1-800-NSA-4455 Fax: 1-800-NSA-4545
|
|
|
DATE OF REQUEST |
SERVICE REQUESTED FOR DEPARTMENT(S) |
|
|
11/10/2014 |
Personnel Management and Development |
|
|
SUBMITTED BY Charlene Stroud |
EXECUTIVE SPONSOR (NIST IR 7657) |
|
|
Name Diane Cox |
Name James Ellis |
|
|
Title Assistant Director
|
Title Deputy Director |
|
|
Office Personnel Management and Development |
Office NSAI |
|
|
Phone 1-800-NSA-4455 ext 123 |
Phone 1-800-NSA-4455 ext 100 |
TYPE OF SERVICE REQUESTED:
|X| Information Strategy Planning |_| Existing Application Enhancement
|_| Business Process Analysis and Redesign |_| Existing Application Maintenance
|X| New Application Development |_| Not Sure
|
BRIEF STATEMENT OF PROBLEM, OPPORTUNITY, OR DIRECTIVE (attach additional documentation as necessary) The facility requires information systems security that addresses the design, implementation and maintenance of countermeasures that protect the physical resource of the organization. That includes people, hardware and supporting system elements and resources that control of information in all its states (transmission, storage, and processing). The facility is subject to trespassing, vandalism and theft. An controlled assess management information systems security program will serve as a form of barcoding access badges using an Microsoft Access database will identify, authenticate and monitor a person’s access while they are in the facility. |
|
BRIEF STATEMENT OF EXPECTED SOLUTION We envision a controlled access integrated database to hold all current employee and visitor badge and access information. Having this database will allow security personnel to identify and authorized personnel to specified access within the facility. The Personnel Management and Development office will manage the MS Access database to process and report controlled access information. To include submitting monthly reports to the Deputy Director on all badging information. The system will also track and record historical reports on all database transactions. |
|
ACTION (ISS Office Use Only) |X| Feasibility assessment approved Assigned to Ravindra Patel |_| Feasibility assessment waived Approved Budget $ 30,049.00 Start Date _ASAP_____ Deadline 7 weeks__ |_| Request delayed Backlogged until date: ______________ |_| Request rejected Reason:
Authorized Signatures: _________//ORIGINAL SIGNED//________ ___________James Ellis___________________ Project Executive Sponsor |
Annex A Stroud Page | 23
Annex B
Thursday, November 13, 2014
Management Database.accdb
Table: CLEARANCE Page: 1
Properties
AlternateBackShade: 95 AlternateBackThemeColorInd 1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn 0
DatasheetGridlinesThemeCol 3 DateCreated: 10/26/2014 4:25:00 PM
DefaultView: 2 DisplayViewsOnSharePointSit 1
FilterOnLoad: False GUID: {guid {8DA3A592-C49E-44BC-
A239-7B3B310C6609}}
HideNewField: False LastUpdated: 11/13/2014 12:40:33 PM
NameMap: Long binary data OrderByOn: False
OrderByOnLoad: True Orientation: Left-to-Right
PublishToWeb: 1 ReadOnlyWhenDisconnected: False
RecordCount: 5 ThemeFontIndex: 1
TotalsRow: False Updatable: True
Columns
Name Type Size
BadgeID Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 1
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {A65E9EBB-39F3-4F36-94B0-DF601AA89C1C}}
OrdinalPosition: 0
Required: False
ResultType: 0
SourceField: BadgeID
SourceTable: CLEARANCE
TextAlign: General
Clearance Type Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 2
ColumnWidth: 1995
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {554AB2EB-8B46-412E-951E-27C448077112}}
IMEMode: 0
IMESentenceMode: 3
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: CLEARANCE Page: 2
OrdinalPosition: 1
Required: False
ResultType: 0
SourceField: Clearance Type
SourceTable: CLEARANCE
TextAlign: General
UnicodeCompression: True
Access Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 3
ColumnWidth: 1545
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {C2150EB0-FBD9-4F31-9D3A-28D2C5D031DA}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: Access
SourceTable: CLEARANCE
TextAlign: General
UnicodeCompression: True
Relationships
EMPLOYEESCLEARANCE
EMPLOYEES CLEARANCE
BadgeID 1 BadgeID
Attributes: Enforced, Right Join
RelationshipType: One-To-Many
Table Indexes
Name Number of Fields
CLEARANCEAccess 1
Clustered: False
DistinctCount: 4
Foreign: False
IgnoreNulls: False
Name: CLEARANCEAccess
Primary: False
Required: False
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: CLEARANCE Page: 3
Unique: False
Fields:
Access Ascending
CLEARANCEBadgeID 1
Clustered: False
DistinctCount: 5
Foreign: False
IgnoreNulls: False
Name: CLEARANCEBadgeID
Primary: False
Required: False
Unique: False
Fields:
BadgeID Ascending
EMPLOYEESCLEARANCE 1
Clustered: False
DistinctCount: 5
Foreign: True
IgnoreNulls: False
Name: EMPLOYEESCLEARANCE
Primary: False
Required: False
Unique: False
Fields:
BadgeID Ascending
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 4
Properties
AlternateBackShade: 100 AlternateBackThemeColorInd -1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn -1
DatasheetGridlinesThemeCol -1 DateCreated: 3/30/2014 7:27:12 PM
DefaultView: 2 DisplayViewsOnSharePointSit 1
FilterOnLoad: False GUID: {guid {ED30E71E-82CD-42D4-
B1F8-5DF53ACB8E2F}}
HideNewField: False LastUpdated: 11/13/2014 1:37:23 PM
NameMap: Long binary data OrderByOn: False
OrderByOnLoad: True Orientation: Left-to-Right
PublishToWeb: 1 ReadOnlyWhenDisconnected: False
RecordCount: 10 ThemeFontIndex: -1
TotalsRow: False Updatable: True
Columns
Name Type Size
BadgeID Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 1
ColumnWidth: 1185
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {71768CE0-4A5D-4D93-BE48-8786C597AFF6}}
OrdinalPosition: 0
Required: False
ResultType: 0
SourceField: BadgeID
SourceTable: EMPLOYEES
TextAlign: General
Date Date/Time 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 4
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {5969F4D4-0B73-488A-A023-50ADBBEBA34A}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 5
Required: False
ResultType: 0
ShowDatePicker: For dates
SourceField: Date
SourceTable: EMPLOYEES
TextAlign: General
TITLE Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 5
ColumnWidth: 3120
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {9925FAD0-224A-436D-B6C4-CFA34464EC30}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: TITLE
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
Department Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 6
ColumnWidth: 2700
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {87486F0C-765C-4A6C-92BA-773E7A4DBE5F}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 3
Required: False
ResultType: 0
SourceField: Department
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
LastName Text 255
AggregateType: -1
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 6
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 7
ColumnWidth: 1770
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {078C325F-F798-4E6B-96C3-EC0F8D7BE0E1}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 4
Required: False
ResultType: 0
SourceField: LastName
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: False
FirstName Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 8
ColumnWidth: 1605
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {4E2317C4-A8DE-4EA7-AE0A-ED42439DB307}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 5
Required: False
ResultType: 0
SourceField: FirstName
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
Address Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 9
ColumnWidth: 2520
CurrencyLCID: 0
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 7
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {643C0880-247A-4B75-BBBF-AA4CE9D44E86}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 6
Required: False
ResultType: 0
SourceField: Address
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: False
City Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 16
ColumnWidth: 1605
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {40A2D68B-A6C5-47C8-B0AE-8787CB2D21F6}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 7
Required: False
ResultType: 0
SourceField: City
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: False
State Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 10
ColumnWidth: 750
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {D4337CFB-3B4B-43FA-9460-76B2FED624E2}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 8
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 8
Required: False
ResultType: 0
SourceField: State
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: False
ZipCode Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 17
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: 00000
GUID: {guid {4F43B0F2-02EA-4E33-971C-BCD89066B28D}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 9
Required: False
ResultType: 0
SourceField: ZipCode
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: False
Phone Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 11
ColumnWidth: 1560
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {3A016180-EEDB-4C31-AA25-A955B33D98A0}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 10
Required: False
ResultType: 0
SourceField: Phone
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: False
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 9
Gender Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 12
ColumnWidth: 1110
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {F83B98B0-808C-4B36-BC6D-81B207935817}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 11
Required: False
ResultType: 0
SourceField: Gender
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
Eye Color Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 13
ColumnWidth: 1290
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {5D671582-1AD8-44AF-9B71-522C5DABB226}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 12
Required: False
ResultType: 0
SourceField: Eye Color
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
Hair Color Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 14
ColumnWidth: 1335
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 10
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {2C618C77-5903-494E-B880-D49FC4452CFA}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 13
Required: False
ResultType: 0
SourceField: Hair Color
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
Pin Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 15
ColumnWidth: 720
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {A44CDCDC-7569-4B35-B4A9-C11DFBCFF4DD}}
OrdinalPosition: 14
Required: False
ResultType: 0
SourceField: Pin
SourceTable: EMPLOYEES
TextAlign: General
Photo OLE Object -
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 975
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {0285A4FE-2D31-46A1-A3A2-67568E65D982}}
OrdinalPosition: 15
Required: False
ResultType: 0
SourceField: Photo
SourceTable: EMPLOYEES
TextAlign: General
Access Text 255
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 11
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1335
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {02E70961-1837-40DC-89A7-DA5DBDCA2414}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 16
Required: False
ResultType: 0
SourceField: Access
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
Limitations Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 18
ColumnWidth: 2910
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {0FC9B4D2-338E-4212-A721-FF0D308DDEE6}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 17
Required: False
ResultType: 0
SourceField: Limitations
SourceTable: EMPLOYEES
TextAlign: General
UnicodeCompression: True
Relationships
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 12
EMPLOYEESCLEARANCE
EMPLOYEES CLEARANCE
BadgeID 1 BadgeID
Attributes: Enforced, Right Join
RelationshipType: One-To-Many
EMPLOYEESFACILITY ACCESS POINTS
EMPLOYEES FACILITY ACCESS POINTS
BadgeID 1 Date
Attributes: Enforced
RelationshipType: One-To-Many
EMPLOYEESINVESTIGATION
EMPLOYEES INVESTIGATION
BadgeID 1 1 Badge ID
Attributes: Unique, Enforced, Left Join
RelationshipType: One-To-One
Table Indexes
Name Number of Fields
EMPLOYEESAccess 1
Clustered: False
DistinctCount: 5
Foreign: False
IgnoreNulls: False
Name: EMPLOYEESAccess
Primary: False
Required: False
Unique: False
Fields:
Access Ascending
EMPLOYEESDate 1
Clustered: False
DistinctCount: 10
Foreign: False
IgnoreNulls: False
Name: EMPLOYEESDate
Primary: False
Required: False
Unique: False
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: EMPLOYEES Page: 13
Fields:
Date Ascending
PrimaryKey 1
Clustered: False
DistinctCount: 10
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
BadgeID Ascending
ZipCode 1
Clustered: False
DistinctCount: 10
Foreign: False
IgnoreNulls: False
Name: ZipCode
Primary: False
Required: False
Unique: False
Fields:
ZipCode Ascending
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: FACILITY ACCESS POINTS Page: 14
Properties
AlternateBackShade: 95 AlternateBackThemeColorInd 1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn 0
DatasheetGridlinesThemeCol 3 DateCreated: 3/30/2014 7:27:12 PM
DefaultView: 2 DisplayViewsOnSharePointSit 1
FCMinDesignVer: 14.0.0000.0000 FCMinReadVer: 14.0.0000.0000
FCMinWriteVer: 14.0.0000.0000 FilterOnLoad: False
GUID: {guid {CFBBF0F1-B933-44E6- HideNewField: False
8760-C34A35BF359E}}
LastUpdated: 11/13/2014 12:40:33 PM NameMap: Long binary data
OrderByOn: False OrderByOnLoad: True
Orientation: Left-to-Right PublishToWeb: 1
ReadOnlyWhenDisconnected: False RecordCount: 10
ThemeFontIndex: 1 TotalsRow: False
Updatable: True
Columns
Name Type Size
BadgeID Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 1920
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {B196728E-E467-49FD-A08B-8A138CAD7011}}
OrdinalPosition: 0
Required: False
ResultType: 0
SourceField: BadgeID
SourceTable: FACILITY ACCESS POINTS
TextAlign: General
Access Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 3555
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {0343E869-46F7-407D-92F0-49C165FEC224}}
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: FACILITY ACCESS POINTS Page: 15
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
ResultType: 0
SourceField: Access
SourceTable: FACILITY ACCESS POINTS
TextAlign: General
UnicodeCompression: True
Date Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {2DACA80B-AE35-4BCD-BFFA-BD0B6D8E5FD9}}
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: Date
SourceTable: FACILITY ACCESS POINTS
TextAlign: General
Relationships
EMPLOYEESFACILITY ACCESS POINTS
EMPLOYEES FACILITY ACCESS POINTS
BadgeID 1 Date
Attributes: Enforced
RelationshipType: One-To-Many
FACILITY ACCESS POINTSVISITORS
FACILITY ACCESS POINTS VISITORS
BadgeID 1 1 ID
Attributes: Unique, Enforced
RelationshipType: One-To-One
Table Indexes
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: FACILITY ACCESS POINTS Page: 16
Name Number of Fields
ACCESSAccess 1
Clustered: False
DistinctCount: 10
Foreign: False
IgnoreNulls: False
Name: ACCESSAccess
Primary: False
Required: False
Unique: False
Fields:
Access Ascending
EMPLOYEESFACILITY ACCESS POINTS 1
Clustered: False
DistinctCount: 1
Foreign: True
IgnoreNulls: False
Name: EMPLOYEESFACILITY ACCESS POINTS
Primary: False
Required: False
Unique: False
Fields:
Date Ascending
PrimaryKey 1
Clustered: False
DistinctCount: 10
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
BadgeID Ascending
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: INVESTIGATION Page: 17
Properties
AlternateBackShade: 95 AlternateBackThemeColorInd 1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn 0
DatasheetGridlinesThemeCol 3 DateCreated: 11/11/2014 2:10:18 PM
DefaultView: 2 DisplayViewsOnSharePointSit 1
FilterOnLoad: False GUID: {guid {67E81BB6-AC92-49F7-
AE3E-AE1E53EF276A}}
HideNewField: False LastUpdated: 11/13/2014 12:40:33 PM
NameMap: Long binary data OrderByOn: False
OrderByOnLoad: True Orientation: Left-to-Right
PublishToWeb: 1 ReadOnlyWhenDisconnected: False
RecordCount: 0 ThemeFontIndex: 1
TotalsRow: False Updatable: True
Columns
Name Type Size
Badge ID Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 1
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {96C9C367-666E-4DD6-B276-3BDFB88CC055}}
OrdinalPosition: 0
Required: False
ResultType: 0
SourceField: Badge ID
SourceTable: INVESTIGATION
TextAlign: General
Public Trust Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {C9E21EBB-6C4F-4955-B6CE-95DAACB1D1F7}}
IMEMode: 0
IMESentenceMode: 3
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: INVESTIGATION Page: 18
OrdinalPosition: 1
Required: False
ResultType: 0
SourceField: Public Trust
SourceTable: INVESTIGATION
TextAlign: General
UnicodeCompression: True
NAC Yes/No 1
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: 106
Format: Yes/No
GUID: {guid {98CA56CB-9380-4520-909B-028974ED59F4}}
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: NAC
SourceTable: INVESTIGATION
TextAlign: General
Approved Yes/No 1
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: 106
Format: Yes/No
GUID: {guid {CB514021-CBDF-46BB-881C-282D5A0B14B5}}
OrdinalPosition: 3
Required: False
ResultType: 0
SourceField: Approved
SourceTable: INVESTIGATION
TextAlign: General
Background Yes/No 1
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: INVESTIGATION Page: 19
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: 106
Format: Yes/No
GUID: {guid {756B561B-475A-420A-81CB-2AA148921601}}
OrdinalPosition: 4
Required: False
ResultType: 0
SourceField: Background
SourceTable: INVESTIGATION
TextAlign: General
Special Background Yes/No 1
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: 106
Format: Yes/No
GUID: {guid {A8B78B1F-542A-47D6-99F2-F43DFBE9F7F1}}
OrdinalPosition: 5
Required: False
ResultType: 0
SourceField: Special Background
SourceTable: INVESTIGATION
TextAlign: General
SCI Access Yes/No 1
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: 106
Format: Yes/No
GUID: {guid {B6C9D223-1062-4C89-9467-B2C4266D2691}}
OrdinalPosition: 6
Required: False
ResultType: 0
SourceField: SCI Access
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: INVESTIGATION Page: 20
SourceTable: INVESTIGATION
TextAlign: General
Local Background Check Yes/No 1
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: 106
Format: Yes/No
GUID: {guid {7363652B-4A54-4E53-8551-28BE0CDB4882}}
OrdinalPosition: 7
Required: False
ResultType: 0
SourceField: Local Background Check
SourceTable: INVESTIGATION
TextAlign: General
Relationships
EMPLOYEESINVESTIGATION
EMPLOYEES INVESTIGATION
BadgeID 1 1 Badge ID
Attributes: Unique, Enforced, Left Join
RelationshipType: One-To-One
VISITORSINVESTIGATION
VISITORS INVESTIGATION
ID 1 1 Badge ID
Attributes: Unique, Enforced, Left Join
RelationshipType: One-To-One
Table Indexes
Name Number of Fields
EMPLOYEESINVESTIGATION 1
Clustered: False
DistinctCount: 0
Foreign: True
IgnoreNulls: False
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: INVESTIGATION Page: 21
Name: EMPLOYEESINVESTIGATION
Primary: False
Required: False
Unique: True
Fields:
Badge ID Ascending
PrimaryKey 1
Clustered: False
DistinctCount: 0
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
Badge ID Ascending
VISITORSINVESTIGATION 1
Clustered: False
DistinctCount: 0
Foreign: True
IgnoreNulls: False
Name: VISITORSINVESTIGATION
Primary: False
Required: False
Unique: True
Fields:
Badge ID Ascending
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: VISITORS Page: 22
Properties
AlternateBackShade: 95 AlternateBackThemeColorInd 1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn 0
DatasheetGridlinesThemeCol 3 DateCreated: 11/7/2014 6:59:01 PM
DefaultView: 2 DisplayViewsOnSharePointSit 1
FilterOnLoad: False GUID: {guid {7561A3A2-FA2B-4B84-
9FE2-147CEFBD6FBF}}
HideNewField: False LastUpdated: 11/13/2014 12:42:55 PM
NameMap: Long binary data OrderByOn: False
OrderByOnLoad: True Orientation: Left-to-Right
PublishToWeb: 1 ReadOnlyWhenDisconnected: False
RecordCount: 5 ThemeFontIndex: 1
TotalsRow: False Updatable: True
Columns
Name Type Size
ID Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 1
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {9E51E326-A112-4731-9328-AEB530D57677}}
OrdinalPosition: 0
Required: False
ResultType: 0
SourceField: ID
SourceTable: VISITORS
TextAlign: General
Date of Request Date/Time 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 2
ColumnWidth: 1905
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {C275F604-9711-4174-A0E5-595F6DF257C3}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: VISITORS Page: 23
Required: False
ResultType: 0
ShowDatePicker: For dates
SourceField: Date of Request
SourceTable: VISITORS
TextAlign: General
First Name Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 3
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {750C7C13-FF3A-4200-A7F7-8C2BA04458F5}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: First Name
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
Last Name Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 4
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {1EAA134E-9A9F-48BE-941D-6D837362B61C}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 3
Required: False
ResultType: 0
SourceField: Last Name
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
MI Text 255
AggregateType: -1
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: VISITORS Page: 24
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 5
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {DD6924BC-4632-4595-B1A8-952598F3C67C}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 4
Required: False
ResultType: 0
SourceField: MI
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
Address Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 6
ColumnWidth: 1695
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {A4BB257E-A3E3-488C-90B2-06163AEA38A4}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 5
Required: False
ResultType: 0
SourceField: Address
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
City Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 7
ColumnWidth: 1290
CurrencyLCID: 0
DataUpdatable: False
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: VISITORS Page: 25
DisplayControl: Text Box
GUID: {guid {6CF77A49-576E-461B-9EBC-C16532B00F9B}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 6
Required: False
ResultType: 0
SourceField: City
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
State Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 8
ColumnWidth: 900
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {3151AB96-98BA-4FD9-A0EE-6CE1CF04B290}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 7
Required: False
ResultType: 0
SourceField: State
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
Zip Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 9
ColumnWidth: 810
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {C9C98ACE-60E7-475E-B75B-4F133C732B33}}
OrdinalPosition: 8
Required: False
ResultType: 0
SourceField: Zip
SourceTable: VISITORS
TextAlign: General
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: VISITORS Page: 26
Phone Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 10
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {DC651712-97BB-436D-A7D6-D99540F32966}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 9
Required: False
ResultType: 0
SourceField: Phone
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
Access Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 11
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {3BD27CE3-18C3-4E7A-88E5-E074FF64F087}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 10
Required: False
ResultType: 0
SourceField: Access
SourceTable: VISITORS
TextAlign: General
UnicodeCompression: True
Relationships
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: VISITORS Page: 27
FACILITY ACCESS POINTSVISITORS
FACILITY ACCESS POINTS VISITORS
BadgeID 1 1 ID
Attributes: Unique, Enforced
RelationshipType: One-To-One
VISITORSINVESTIGATION
VISITORS INVESTIGATION
ID 1 1 Badge ID
Attributes: Unique, Enforced, Left Join
RelationshipType: One-To-One
Table Indexes
Name Number of Fields
FACILITY ACCESS POINTSVISITORS 1
Clustered: False
DistinctCount: 5
Foreign: True
IgnoreNulls: False
Name: FACILITY ACCESS POINTSVISITORS
Primary: False
Required: False
Unique: True
Fields:
ID Ascending
PrimaryKey 1
Clustered: False
DistinctCount: 5
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
ID Ascending
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Table: VISITORS Page: 28
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Write Definition, Read Data, Insert Data, Update Data, Delete Data
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 29
Properties
AllowAdditions: True AllowDatasheetView: False
AllowDeletions: True AllowDesignChanges: True
AllowEditing: True AllowEdits: True
AllowFilters: True AllowFormView: True
AllowLayoutView: True AllowPivotChartView: True
AllowPivotTableView: True AllowUpdating: No
AlternateBackShade: 95 AlternateBackThemeColorInd 1
AlternateBackTint: 100 AutoCenter: False
AutoResize: True BackShade: 100
BackThemeColorIndex: 1 BackTint: 100
BorderShade: 100 BorderStyle: Sizable
BorderThemeColorIndex: 3 BorderTint: 100
CloseButton: True Container: Forms
ControlBox: True Count: 35
CurrentView: 0 Cycle: All Records
DataEntry: False DatasheetAlternateBackColor 15921906
DatasheetBackColor: 16777215 DatasheetBackShade: 100
DatasheetBackThemeColorIn 1 DatasheetBackTint: 100
DatasheetBorderLineStyle: 1 DatasheetCellsEffect: Flat
DatasheetColumnHeaderUnde 1 DatasheetFontHeight: 11
DatasheetFontItalic: False DatasheetFontName: Calibri
DatasheetFontUnderline: False DatasheetFontWeight: Normal
DatasheetForeColor: 0 DatasheetForeShade: 100
DatasheetForeThemeColorIn 0 DatasheetForeTint: 100
DatasheetGridlinesBehavior: Both DatasheetGridlinesColor: 15132391
DatasheetGridlinesShade: 100 DatasheetGridlinesThemeCol 3
DatasheetGridlinesTint: 100 DateCreated: 11/8/2014 6:43:55 PM
DefaultEditing: 2 DefaultView: Single Form
DisplayOnSharePointSite: Follow Table Setting DividingLines: False
FastLaserPrinting: True FetchDefaults: True
FilterOn: False FilterOnLoad: False
FitToScreen: True ForeShade: 100
ForeThemeColorIndex: 0 ForeTint: 100
FrozenColumns: 1 GridX: 24
GridY: 24 GUID: {guid {DF44E97A-571B-4FF2-
8906-72DBD469D78D}}
HasModule: False HelpContextId: 0
HorizontalDatasheetGridlineS 1 Hwnd: 1050718
InsideHeight: 11655 InsideWidth: 14280
KeyPreview: False LastUpdated: 11/13/2014 1:38:54 PM
LayoutForPrint: False LogicalPageWidth: 11520
MaxButton: True MinButton: True
MinMaxButtons: Both Enabled Modal: False
Moveable: False NameMap: Long binary data
NavigationButtons: True OrderByOn: False
OrderByOnLoad: True Orientation: Left-to-Right
Owner: admin Painting: True
PaletteSource: (Default) Picture: (none)
PictureAlignment: Top Right PictureSizeMode: Clip
PictureTiling: False PictureType: 0
PopUp: False PrtDevMode: Long binary data
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 30
PrtDevModeW: Long binary data PrtDevNames: Long binary data
PrtDevNamesW: Long binary data PrtMip: Long binary data
PublishToWeb: 1 RecordLocks: No Locks
RecordSelectors: True RecordsetType: Dynaset
RecordSource: EMPLOYEES RowHeight: Default
SaveSplitterBarPosition: True ScrollBars: Both
ShortcutMenu: True ShowGrid: True
SplitFormDatasheet: Allow Edits SplitFormOrientation: Datasheet on Top
SplitFormPrinting: Form Only SplitFormSize: 0
SplitFormSplitterBar: True SubdatasheetExpanded: False
SubdatasheetHeight: 0 ThemeFontIndex: 1
ThemeResourceName: [Use DB Theme] TimerInterval: 0
UseDefaultPaperSize: False UserName: admin
VerticalDatasheetGridlineStyl 1 ViewsAllowed: Both
Visible: False WaitForPostProcessing: False
Width: 13388 WindowHeight: 11910
WindowLeft: 0 WindowTop: 0
WindowWidth: 14535
Objects
Section: Detail
AlternateBackColor: 15921906 AlternateBackShade 95
:
AlternateBackThem 1 AlternateBackTint: 100
eColorIndex:
AutoHeight: True BackColor: 16777215
BackShade: 100 BackThemeColorInd 1
ex:
BackTint: 100 CanGrow: False
CanShrink: False DisplayWhen: Always
EventProcPrefix: Detail ForceNewPage: None
HasContinued: False Height: 14850
InSelection: False KeepTogether: False
Name: Detail NewRowOrCol: None
SpecialEffect: Flat Visible: True
WillContinue: False
Section: FormFooter
AlternateBackShade 95 AlternateBackThem 1
: eColorIndex:
AlternateBackTint: 100 AutoHeight: True
BackColor: 16777215 BackShade: 100
BackThemeColorInd 1 BackTint: 100
ex:
CanGrow: False CanShrink: False
DisplayWhen: Always EventProcPrefix: FormFooter
ForceNewPage: None HasContinued: False
Height: 0 InSelection: False
KeepTogether: False Name: FormFooter
NewRowOrCol: None SpecialEffect: Flat
Visible: True WillContinue: False
Section: FormHeader
AlternateBackShade 95
:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 31
AlternateBackThem 1
eColorIndex:
AlternateBackTint: 100 AutoHeight: True
BackColor: 15064278 BackShade: 100
BackThemeColorInd 2 BackTint: 20
ex:
CanGrow: False CanShrink: False
DisplayWhen: Always EventProcPrefix: FormHeader
ForceNewPage: None HasContinued: False
Height: 542 InSelection: False
KeepTogether: False Name: FormHeader
NewRowOrCol: None SpecialEffect: Flat
Visible: True WillContinue: False
Text Box: Address
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: 2520
ControlSource: Address ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Address
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 Format: @
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left IMEHold: False
IMEMode: 0 IMESentenceMode: 3
IsHyperlink: False KeyboardLanguage: 0
Layout: 2 LayoutID: 1
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 32
Left: 1710 LeftMargin: 44
LeftPadding: 30 LineSpacing: 0
Locked: False Name: Address
NumeralShapes: System OldBorderStyle: 1
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 6
RowStart: 6 ScrollBarAlign: System
ScrollBars: Neither Section: 0
ShowDatePicker: For dates SpecialEffect: Flat
TabIndex: 6 TabStop: True
TextAlign: 0 TextFontCharSet: 0
TextFormat: Plain Text ThemeFontIndex: 1
Top: 4500 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 11640
Label: Auto_Header0
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 6968388
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 2
ndex:
BorderTint: 100 BorderWidth: Hairline
BottomMargin: 0 BottomPadding: 30
Caption: NSAI Employees Request for Security ColumnEnd: 1
Access Form
ColumnStart: 1 ControlType: 100
DisplayWhen: Always EventProcPrefix: Auto_Header0
FontBold: No FontItalic: False
FontName: Calibri Light FontSize: 18
FontUnderline: False FontWeight: Normal
ForeColor: 6968388 ForeShade: 100
ForeThemeColorInd 2 ForeTint: 100
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 460 HelpContextId: 0
HorizontalAnchor: Both Layout: 2
LayoutID: 2 Left: 1050
LeftMargin: 0 LeftPadding: 30
LineSpacing: 0 Name: Auto_Header0
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 0
RightPadding: 30 RowEnd: 0
RowStart: 0 Section: 1
SpecialEffect: Flat TextAlign: 0
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 33
TextFontCharSet: 0 ThemeFontIndex: 0
Top: 60 TopMargin: 0
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 12308
Image: Auto_Logo0
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 10921638
BorderLineStyle: Solid BorderShade: 65
BorderStyle: Transparent BorderThemeColorI 1
ndex:
BorderTint: 100 BorderWidth: Hairline
BottomPadding: 30 ColumnEnd: 0
ColumnStart: 0 ControlType: 103
DisplayWhen: Always EventProcPrefix: Auto_Logo0
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 460 HelpContextId: 0
HorizontalAnchor: Left ImageData: Long binary data
ImageHeight: 480 ImageWidth: 480
Layout: 2 LayoutID: 2
Left: 300 LeftPadding: 30
Name: Auto_Logo0 OldBorderStyle: 0
Picture: (image) PictureAlignment: Top Right
PictureData: Long binary data PictureTiling: False
PictureType: 0 RightPadding: 30
RowEnd: 0 RowStart: 0
Section: 1 SizeMode: Clip
SpecialEffect: Flat Top: 60
TopPadding: 30 VerticalAnchor: Top
Visible: True Width: 690
Text Box: BadgeID
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 34
ColumnStart: 1 ColumnWidth: Default
ControlSource: BadgeID ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: BadgeID
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 359
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: BadgeID NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 0 RowStart: 0
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 0
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 360
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Subform/Subreport: Child48
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomPadding: 150
CanGrow: True CanShrink: False
ColumnEnd: 1 ColumnStart: 0
ControlType: 112 DisplayWhen: Always
Enabled: True EventProcPrefix: Child48
FilterOnEmptyMast True
er:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 35
GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 3360
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftPadding: 30 LinkChildFields: BadgeID
LinkMasterFields: BadgeID Locked: False
Name: Child48 OldBorderStyle: 1
RightPadding: 30 RowEnd: 16
RowStart: 16 Section: 0
ShowPageHeaderAn True SourceObject: Table.CLEARANCE
dPageFooter:
SpecialEffect: Flat TabIndex: 15
TabStop: True Top: 11340
TopPadding: 30 VerticalAnchor: Top
Visible: True Width: 12990
Text Box: City
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: 1605
ControlSource: City ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: City
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 Format: @
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 36
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left IMEHold: False
IMEMode: 0 IMESentenceMode: 3
IsHyperlink: False KeyboardLanguage: 0
Layout: 2 LayoutID: 1
Left: 1710 LeftMargin: 44
LeftPadding: 30 LineSpacing: 0
Locked: False Name: City
NumeralShapes: System OldBorderStyle: 1
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 7
RowStart: 7 ScrollBarAlign: System
ScrollBars: Neither Section: 0
ShowDatePicker: For dates SpecialEffect: Flat
TabIndex: 7 TabStop: True
TextAlign: 0 TextFontCharSet: 0
TextFormat: Plain Text ThemeFontIndex: 1
Top: 5265 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 11640
Text Box: Date
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: Default
ControlSource: Date ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Date
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 37
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 360
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: Date NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 1 RowStart: 1
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 1
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 900
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Text Box: Department
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: 2700
ControlSource: Department ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Department
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 38
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 585
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: Department NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 3 RowStart: 3
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 3
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 2205
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
EmptyCell52
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd -1
ex:
BackTint: 100 BottomPadding: 150
ColumnEnd: 0 ColumnStart: 0
ControlType: 127 EventProcPrefix: EmptyCell52
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 0 HorizontalAnchor: Left
Layout: 2 LayoutID: 1
Left: 360 LeftPadding: 30
Name: EmptyCell52 RightPadding: 30
RowEnd: 15 RowStart: 15
Section: 0 Top: 11160
TopPadding: 30 VerticalAnchor: Top
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 39
Width: 1288
EmptyCell53
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd -1
ex:
BackTint: 100 BottomPadding: 150
ColumnEnd: 1 ColumnStart: 1
ControlType: 127 EventProcPrefix: EmptyCell53
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 0 HorizontalAnchor: Left
Layout: 2 LayoutID: 1
Left: 1710 LeftPadding: 30
Name: EmptyCell53 RightPadding: 30
RowEnd: 15 RowStart: 15
Section: 0 Top: 11160
TopPadding: 30 VerticalAnchor: Top
Width: 11640
Text Box: Eye Color
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: Default
ControlSource: Eye Color ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Eye_Color
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 40
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 585
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: Eye Color NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 12 RowStart: 12
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 12
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 9090
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Text Box: FirstName
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: 1605
ControlSource: FirstName ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: FirstName
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 41
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 585
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: FirstName NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 5 RowStart: 5
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 5
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 3735
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Text Box: Gender
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: Default
ControlSource: Gender ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Gender
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 42
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 585
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: Gender NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 11 RowStart: 11
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 11
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 8325
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Text Box: Hair Color
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: Default
ControlSource: Hair Color ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Hair_Color
FilterLookup: Database Default FontBold: No
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 43
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 585
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: Hair Color NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 13 RowStart: 13
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 13
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 9855
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Label: Label0
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: BadgeID ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label0
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0
ex:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 44
ForeTint: 50
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 359 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label0
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 0
RowStart: 0 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 360 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label12
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: LastName ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label12
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 45
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label12
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 4
RowStart: 4 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 2970 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label15
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: FirstName ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label15
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label15
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 5
RowStart: 5 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 3735 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 46
Width: 1288
Label: Label18
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Address ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label18
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label18
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 6
RowStart: 6 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 4500 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label21
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 47
Caption: City ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label21
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label21
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 7
RowStart: 7 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 5265 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label24
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: State ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label24
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 48
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label24
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 8
RowStart: 8 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 6030 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label27
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: ZipCode ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label27
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label27
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 49
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 9
RowStart: 9 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 6795 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label3
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Date ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label3
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 360 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label3
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 1
RowStart: 1 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 900 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label30
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 50
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Phone ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label30
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label30
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 10
RowStart: 10 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 7560 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label33
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Gender ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label33
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 51
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label33
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 11
RowStart: 11 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 8325 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label36
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Eye Color ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label36
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 52
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label36
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 12
RowStart: 12 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 9090 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label39
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Hair Color ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label39
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label39
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 13
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 53
RowStart: 13 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 9855 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label42
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Pin ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label42
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 360 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label42
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 14
RowStart: 14 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 10620 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label6
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 54
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: TITLE ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label6
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label6
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 2
RowStart: 2 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 1440 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Label: Label9
BackColor: 16777215 BackShade: 100
BackStyle: Transparent BackThemeColorInd 1
ex:
BackTint: 100 BorderColor: 8355711
BorderLineStyle: Solid BorderShade: 100
BorderStyle: Transparent BorderThemeColorI 0
ndex:
BorderTint: 50 BorderWidth: Hairline
BottomMargin: 22 BottomPadding: 150
Caption: Department ColumnEnd: 0
ColumnStart: 0 ControlType: 100
DisplayWhen: Always EventProcPrefix: Label9
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 55
ForeColor: 8355711 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 50
ex:
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left Layout: 2
LayoutID: 1 Left: 360
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Name: Label9
NumeralShapes: System OldBorderStyle: 0
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 3
RowStart: 3 Section: 0
SpecialEffect: Flat TextAlign: 0
TextFontCharSet: 0 ThemeFontIndex: 1
Top: 2205 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 1288
Text Box: LastName
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: 1770
ControlSource: LastName ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: LastName
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 Format: @
GridlineColor: 10921638 GridlineShade: 65
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 56
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left IMEHold: False
IMEMode: 0 IMESentenceMode: 3
IsHyperlink: False KeyboardLanguage: 0
Layout: 2 LayoutID: 1
Left: 1710 LeftMargin: 44
LeftPadding: 30 LineSpacing: 0
Locked: False Name: LastName
NumeralShapes: System OldBorderStyle: 1
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 4
RowStart: 4 ScrollBarAlign: System
ScrollBars: Neither Section: 0
ShowDatePicker: For dates SpecialEffect: Flat
TabIndex: 4 TabStop: True
TextAlign: 0 TextFontCharSet: 0
TextFormat: Plain Text ThemeFontIndex: 1
Top: 2970 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 11640
Text Box: Phone
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: 1560
ControlSource: Phone ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Phone
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 57
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 Format: @
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left IMEHold: False
IMEMode: 0 IMESentenceMode: 3
IsHyperlink: False KeyboardLanguage: 0
Layout: 2 LayoutID: 1
Left: 1710 LeftMargin: 44
LeftPadding: 30 LineSpacing: 0
Locked: False Name: Phone
NumeralShapes: System OldBorderStyle: 1
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 10
RowStart: 10 ScrollBarAlign: System
ScrollBars: Neither Section: 0
ShowDatePicker: For dates SpecialEffect: Flat
TabIndex: 10 TabStop: True
TextAlign: 0 TextFontCharSet: 0
TextFormat: Plain Text ThemeFontIndex: 1
Top: 7560 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 11640
Text Box: Pin
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: Default
ControlSource: Pin ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: Pin
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 58
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 360
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: Pin NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 14 RowStart: 14
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 14
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 10620
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Text Box: State
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: 750
ControlSource: State ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 59
DisplayWhen: Always
Enabled: True EnterKeyBehavior: False
EventProcPrefix: State FilterLookup: Database Default
FontBold: No FontItalic: False
FontName: Calibri FontSize: 11
FontUnderline: False FontWeight: Normal
ForeColor: 4210752 ForeShade: 100
ForeThemeColorInd 0 ForeTint: 75
ex:
Format: @ GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 585
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: State NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 8 RowStart: 8
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 8
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 6030
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Text Box: TITLE
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 60
ColumnStart: 1 ColumnWidth: 4305
ControlSource: TITLE ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: TITLE
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 GridlineColor: 10921638
GridlineShade: 65 GridlineStyleBottom Transparent
:
GridlineStyleLeft: Transparent GridlineStyleRight: Transparent
GridlineStyleTop: Transparent GridlineThemeColor 1
Index:
GridlineTint: 100 GridlineWidthBotto 1
m:
GridlineWidthLeft: 1 GridlineWidthRight: 1
GridlineWidthTop: 1 Height: 585
HelpContextId: 0 HorizontalAnchor: Left
IMEHold: False IMEMode: 0
IMESentenceMode: 3 IsHyperlink: False
KeyboardLanguage: 0 Layout: 2
LayoutID: 1 Left: 1710
LeftMargin: 44 LeftPadding: 30
LineSpacing: 0 Locked: False
Name: TITLE NumeralShapes: System
OldBorderStyle: 1 ReadingOrder: Context
RightMargin: 44 RightPadding: 30
RowEnd: 2 RowStart: 2
ScrollBarAlign: System ScrollBars: Neither
Section: 0 ShowDatePicker: For dates
SpecialEffect: Flat TabIndex: 2
TabStop: True TextAlign: 0
TextFontCharSet: 0 TextFormat: Plain Text
ThemeFontIndex: 1 Top: 1440
TopMargin: 22 TopPadding: 30
Vertical: False VerticalAnchor: Top
Visible: True Width: 11640
Text Box: ZipCode
AggregateType: -1 AllowAutoCorrect: True
AutoTab: False BackColor: 16777215
BackShade: 100 BackStyle: Normal
BackThemeColorInd 1 BackTint: 100
ex:
BorderColor: 10921638 BorderLineStyle: Solid
BorderShade: 65 BorderStyle: 0
BorderThemeColorI 1 BorderTint: 100
ndex:
BorderWidth: Hairline BottomMargin: 22
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES Page: 61
BottomPadding: 150 CanGrow: False
CanShrink: False ColumnEnd: 1
ColumnHidden: False ColumnOrder: Default
ColumnStart: 1 ColumnWidth: Default
ControlSource: ZipCode ControlType: 109
DecimalPlaces: Auto DisplayAsHyperlink: If Hyperlink
DisplayWhen: Always Enabled: True
EnterKeyBehavior: False EventProcPrefix: ZipCode
FilterLookup: Database Default FontBold: No
FontItalic: False FontName: Calibri
FontSize: 11 FontUnderline: False
FontWeight: Normal ForeColor: 4210752
ForeShade: 100 ForeThemeColorInd 0
ex:
ForeTint: 75 Format: 00000
GridlineColor: 10921638 GridlineShade: 65
GridlineStyleBottom Transparent GridlineStyleLeft: Transparent
:
GridlineStyleRight: Transparent GridlineStyleTop: Transparent
GridlineThemeColor 1 GridlineTint: 100
Index:
GridlineWidthBotto 1 GridlineWidthLeft: 1
m:
GridlineWidthRight: 1 GridlineWidthTop: 1
Height: 585 HelpContextId: 0
HorizontalAnchor: Left IMEHold: False
IMEMode: 0 IMESentenceMode: 3
IsHyperlink: False KeyboardLanguage: 0
Layout: 2 LayoutID: 1
Left: 1710 LeftMargin: 44
LeftPadding: 30 LineSpacing: 0
Locked: False Name: ZipCode
NumeralShapes: System OldBorderStyle: 1
ReadingOrder: Context RightMargin: 44
RightPadding: 30 RowEnd: 9
RowStart: 9 ScrollBarAlign: System
ScrollBars: Neither Section: 0
ShowDatePicker: For dates SpecialEffect: Flat
TabIndex: 9 TabStop: True
TextAlign: 0 TextFontCharSet: 0
TextFormat: Plain Text ThemeFontIndex: 1
Top: 6795 TopMargin: 22
TopPadding: 30 Vertical: False
VerticalAnchor: Top Visible: True
Width: 11640
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Modify Definition, Execute
C:\Users\stroudc\Desktop\ITS 465\Control Access Information Systems Thursday, November 13, 2014
Management Database.accdb
Form: EMPLOYEES
Page: 62
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Modify Definition, Execute
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,
Modify Definition, Execute
|
Field |
Definition |
|
First Name |
The first name of the badge bearer |
|
Last Name |
The last name of the badge bearer |
|
Middle Initial |
The middle name of the badge bearer |
|
Address |
The current physical address of the badge bearer |
|
City |
The city where the badge bearer lives |
|
State |
The state where the badge bearer lives |
|
Zip Code |
The zipcode where the badge bearer lives |
|
Phone |
The home phone number of the badge bearer |
|
Employee |
A person who works for the NSAI |
|
Visitor |
A person who is a guest of the NSAI |
|
Title |
The employee’s official position title |
|
Department |
The department the employee will work |
|
Gender |
The gender of the badge bearer |
|
Eye Color |
The eye color of the badge bearer |
|
Hair Color |
The hair color of the badge bearer |
|
Access |
The places in the facilities the bearer of the badge has access to. |
|
Clearance Type |
The type of access granted |
|
Photo |
A picture of the badge bearer |
|
Date |
The requested date of the employee badge |
|
Date of Request |
The requested date of the visitor badge |
|
Public Trust |
A cleareance that is granted to a federal employee that requires access to public financial records and sensitive information. |
|
NAC |
Entrance National Agency Check. A background check that determines if a visitor or an employee has any criminal record across the United States (including Hawaii and Alaska). |
|
Background |
A 5 year investigation conducted on an employee to determine if they have a suitable character to be trusted with classified information |
|
Special Background |
A 10 year investigation conducted on an employee to determine if they have a suitable character to be trusted with classified information |
|
SCI |
A government access to classified information that involves intelligence sources. One of the authorized access for Employees only. |
|
Local Background Check |
Current state local criminal background report of person who will wear the ID Badge and access the facility. |
EmployeeCurrent SystemVisitorSecurity ManagerRequest Employee Security BadgeShow Badge and enter NSAIRequest Visitor Access BadgeEmployeeVisitorTour the National Security Archive MuseumGo to the OfficeAccepts RequestSecurity ManagerPerforms Background and Records Check Issue BadgeProcess BadgeApprove or Disapprove RequestReturn Badge to Security Manager
Employee Current System Visitor Security Manager Request Employee Security Badge Show Badge and enter NSAI Request Visitor Access Badge M1 M2 M3 M4 Employee Visitor Tour the National Security Archive Museum Go to the Office Accepts Request Security Manager Performs Background and Records Check Issue Badge Process Badge Approve or Disapprove Request M1 M2 M3 M4 Return Badge to Security Manager
Brief Statement of Problem, Opportunty, or DirectiveUrgencyVisabilityAnnual BenefitsPriority Proposed Solution
AuditingASAPHigh$47,0001New Development
1. Log source fails to keep access records on grant and
denied access control decisions.
2. Log source fails to keep access records on
suspended, terminated and reinstated access control
records.
3. Log source fails to keep records on lost and stolen
access control badges
4. Customize audit information-providing capabilities
does not exist.
Privilege capabilitiesASAPHigh$47,0001New Development
1. System provide query/display for human decision
variables discovery for subject/subject groups
assigned privileges or constraints.
2. System provide query/display for control access
areas for subject/subject groups assigned privileges or
constraints.
Privilege assignments2 daysMed$175,0002After Development
1. Steps required for assigning, changing, and
removing subjects, privileges, or capabilities timeline is
excessive. Too many steps are required to perform
these updates, more mistakes can be made due to either
human or vendor errors.
Automate a two step process :
verification and authorization
2. Steps required for assigning, changing, and
removing subject groups relation privileges, or
capabilities timeline is excessive. Too many steps are
required to perform these updates, more mistakes can
be made due to either human or vendor errors.
Automate a two step process :
verification and authorization
Policy management1 monthMed$90,0003After Development
1. Policy enforcement is incapable of keeping a 100%
accountability and disclosure of controlled access
badges.
Provide program manager(s) and clerks
with automated accountability and
report tools. Install security
1. Policy enforcement is incapable of keeping a 0%
incident and violation rate.
Provide users with a control access
security program, policy and training.
2. Current control access system life cycle policy
management expires upon retiring, resignation or
termination of project manager.
Automate life cycle policy and assign to
Deputy and assign new project
manager.
3. Current control access system source policy
authorization expires upon retiring, resignation or
termination of project manager.
Automate life cycle policy and assign to
Deputy and assign new project
manager.
3. Delegation of administrative capabilities are not
authorized.
Allow policy administration delegation
Flexibilities of system1 monthMed$200,0002After Development
1. Controlled access mechanism suffers from lack of
reliability because it can be compromised by theft and
duplication.
Assign a primary and alternate program
manager, grant administrative
permissions and provide security tools.
1. Controlled access mechanism suffers from lack of
legal consequences of damage or negligence.
Order monitoring service and hire one
security admin clerk and one physical
security guard.
2. Hardware, software and accessories costs require
more overhead between organization and vendor.
Provide program manager(s) and clerks
with automated supply control system
tools and budget.
Project Manager: Charlene Stroud
Last updated by: Charlene Stroud
Date last update: 7 November 2014
Project: Controlled Access Management Information Systems
Created by: Charlene Stroud
Date created: 6 November 2014
`Development Cost
Personnel Man hoursCost per hour Total
1Database Designer20070.00$ 14,000.00$
1System Architect5075.00$ 3,750.00$
1Data Entry Clerk15035.00$ 5,250.00$
23,000.00$
New Hardware & Software
Total
1Server2,500.00$
1Server software (Server 2008) 1,000.00$
1Database software (Microsoft Access) 299.00$
1Database software (Microsoft Access) Client install750.00$
1Client workstation (Windows 7)2,500.00$
7,049.00$
Total Projected Development Cost30,049.00$
Projected Annual Operating Costs
Personnel
1Data Entry Clerk4035.00$ 1,400.00$
1Hosting cost for TB Database1,500.00$
Total Projected Annual Operating Costs2,900.00$
Minimum Computer Requirements To Access the Database
Processor: 1 gigahertz (GHz) or faaster x86 orx64-processor
Memory (Ram)1 gigabyte (GB) RAM (32-bit); 2 gigabytes (GB) RAM (64-bit)
Hard Drive Space:3.0 gigabytes (GB) available
Display:Graphics hardware accelerations requires a DirectX 10 graphics card
Monitor: 1024 x 56 or higher resolution
Operating System:Windows Server 2008 R2 (64-bit) Windows 7 (32-bit or 64-bit)
Windows Server 2012 (64-bit) Windows 8 (32-bit or 64-bit)
.NET Version: 3.5, 4.0 or 4.5
ModuleDescription
ProcessorIntel® Xeon® processor E3-1200 product family
Intel® Xeon® processor E3-1200 V2 product family
Intel® Pentium® G600 and G800 series
Intel® Celeron® G400 and G500 series
Operating SystemMicrosoft® Windows Server® 2012
Microsoft Windows Server 2012 Essentials
Microsoft Windows Server 2008 R2 SP1, x64 (includes Hyper-V®)
Novell® SUSE® Linux Enterprise Server
Red Hat® Enterprise Linux®
ChipsetIntel® C202
Virtualization options:Citrix® XenServer®
VMware® vSphere® ESXi™
Red Hat Enterprise Virtualization®
Storage
Cabled hard drive options:
Memory1Up to 32GB (4 DIMM slots): 1GB/2GB/4GB/8GB DDR3 up to 1600MHz
3.5" SAS (15K, 10K), nearline SAS (7.2K), SATA (7.2K)
Maximum Internal Storage:Up to 12TB2
Drive BaysCabled options available:
Up to six 2.5" SATA SSD or SAS drives or
Up to four 3.5" SAS, nearline SAS, or SATA drives
Slots4 PCIe G2 slots:
Two x8 slots (one with x16 connectors)
One x4 slot (with x8 connector)
One x1 slot
RAID ControllersInternal Controllers:
PERC H200 (6Gb/s)
PERC S100 (software based)
PERC S300 (software based)
External HBAs (non-RAID):
6GB/s SAS HBA
Network ControllerOne single port Broadcom BCM 5722
CommunicationsBroadcom® NetXtreme® 5709 Dual Port Gigabit Ethernet NIC, Copper,
w/TOE PCIe x4
Broadcom® NetXtreme® 5709 Dual Port Gigabit Ethernet NIC, Copper,
TOE/iSCI PCIe x4
Broadcom® NetXtreme® II 5722 Single Port Gigabit Ethernet NIC
Intel® PRO/1000PT Single Port Adapter, Gigabit Ethernet NIC, PCIe x1
PowerSingle cabled power supply (305W)
AvailabilityQuad-pack LED diagnostics, ECC Memory, add-in RAID, TPM/TCM
Graphics CardMatrox G200eW w/8MB memory
Chassis
463.82 H x 189.35 W x 420.3 D (mm)
18.26 H x 7.45” W x 16.55” D (in)
Management
BMC, IPMI 2.0 compliant
Dell OpenManage
Unified Server Configurator
Environmental Operating Conditions
Acoustics:
Typically configured3 3.5" cable chassis in 23 ± 2 °C ambient
Idle: LwA-UL4 = 5.0 bels; LpA5 = 35 dBA
Regulatory
Regulatory Model: E11S
Regulatory Type: E11S002
Personnel Management Development
Function of UsagePMDSecurity
View Personal DataYESYES
View ReportsYESYES
Create/Edit Employee and Visitor InformationYESYES
Create/Edit ReportsYESYES
Create/Edit Queries YESYES
View Tracking DataYESYES
View Background Check InformationYESYES
View Security Clearance InformationYESYES
View Controlled Access InformationNONO
Automate (import and export Excel and Word)NONO
User Account
SECURITY OFFICE PEOPLE MANAGEMENT AND DEVELOPMENT OFFICEVISITOR ENTRANCEEMPLOYEE ENTRANCEVIRTUAL SERVERLOGICAL ACCESSAPPLICATION & STORAGECERIFICATE AUTHORITDIRECTORY SERVICESPHYSICAL ACCESS CONTROL SERVERFIREWALLFIREWALLLOCAL AREA NETWORKVIRTUAL ACCESSDIGITAL CAMERA & BARCODE SMARTCARD SYSTEM W/PRINTER
SECURITY OFFICE PEOPLE MANAGEMENT AND DEVELOPMENT OFFICE VISITOR ENTRANCE EMPLOYEE ENTRANCE VIRTUAL SERVER LOGICAL ACCESS APPLICATION & STORAGE CERIFICATE AUTHORIT DIRECTORY SERVICES PHYSICAL ACCESS CONTROL SERVER FIREWALL FIREWALL LOCAL AREA NETWORK VIRTUAL ACCESS DIGITAL CAMERA & BARCODE SMARTCARD SYSTEM W/PRINTER
PLANPLANACTUALACTUALPERCENT
TASK NAMESTARTDURATIONSTARTDURATIONCOMPLETEWEEKS
Period Highlight:
1
1234567
Activity 01
Project Management
1535
90%
Plan
Problem Analysis
1545
33%
Feasible Study
1555
33%
Actual
System Requirements
1565
33%
Activity 02
Define Phases
2545
85%
%
Complete
Design
2545
100%
Installation Details
2545
75%
Actual (beyond plan
)
Testing
2535
80%
Training Support
2535
20%
%
Complete (beyond plan)
Implementation
2535
0%
Activity 03
Design
3535
100%
Logical
3555
33%
Physical
3555
33%
Functional
3555
33%
Activity 04
Installation Details
4555
100%
Hardware
4565
50%
Software
4565
20%
Security Configuration
4565
5%
Activity 05
Testing
5545
100%
System Testing
5545
40%
System Review
5545
40%
Activity 06
Integration Testing
6575
100%
Training Support
6545
20%
Operations and Support
6535
20%
Activity 07
Implementation
7557
100%
Controlled Access Management Information Systems Security
Database Administrators
Data and Tracking Information
Update and Changes
Database
Upate and Maintenance
Approve or Reject Confirmation
Generate Report
Approve or Reject ID Badge Request
Request Background CheckPMD Staff
Request Access Badge
Monitor Personnel ActivityControlled Access
SecurityManagement Information System
Receive Request
Report Backgroundf Check Information
Receive Background Check Information
Process Access Badge
Receive Backgroud Check RequestArchive Records
Receive Access Report
Request Badge Materials
Employee/Visitor
DatabasePersonnel Management DevelopmentSecurityReceive Employee Request Form Receive Visitor Request Form Disapprove RequestSend Request to JPASSend Request to SecurityReceive Request from PMDConduct Background CheckReturn request to PMD with background checkApprove RequestJPASProcess BadgeIssue BadgefGenerate Access RosterSend Disapproval Notification to Employee Agencyh/VicitorSend Access Roster To SecurityConfirm Security Clearance Return Results to PMDMonitor Personnel
Database Personnel Management Development Security Receive Employee Request Form Receive Visitor Request Form Disapprove Request Send Request to JPAS Send Request to Security Receive Request from PMD Conduct Background Check Return request to PMD with background check Approve Request JPAS Process Badge Issue Badgef Generate Access Roster Send Disapproval Notification to Employee Agencyh/Vicitor Send Access Roster To Security Confirm Security Clearance Return Results to PMD Monitor Personnel M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4
