Access 2010 실무 따라하기 > 데이터베이스

Chapter 1 ACCESS의 시작
1.1 책 구성에 대하여 3
1.1.1 주소록 프로그램 ············································3
1.1.2 학생카드 프로그램 ··········································4
1.1.3 성적관리 프로그램 ··········································5
1.1.4 판매관리 프로그램 ··········································7
1.1.5 MS-SQL 서버 연결 ········································10
1.2 ACCESS 설치 및 기초사용법 12
1.2.1 ACCESS 2010 ············································12
1.2.2 ACCESS 설치 ············································12
1.2.3 ACCESS 시작하기 ········································14
1.2.4 ACCDB 만들기 ···········································15
1.2.5 기존의 ACCDB 파일 열기 ··································18
Chapter 2 ACCESS의 구성
2.1 ACCESS 지름길 21
2.2 ACCESS의 구성 22
2.3 ACCESS 오브젝트 23
2.3.1 테이블의 개념 ············································24
2.3.2 쿼리의 개념 ·············································28
2.3.3 폼의 개념 ···············································30
2.3.4 보고서의 개념 ············································33
2.3.5 매크로의 개념 ············································36
2.3.6 모듈의 개념 ·············································38
Chapter 3 ACCESS의 활용법
3.1 프로그램 작성요령 43
3.1.1 업무 분석 및 설계 ········································43
3.1.2 프로그램 작성요령 ········································44
3.1.3 ACCESS 작성요령 ········································49
v
ACCESS 2010 실무 따라하기
Chapter 4 주소록 관리
4.1 주소록 프로그램 설계 53
4.1.1 주소록 분석 ··············································53
4.1.2 주소록 테이블 설계 ·······································54
4.1.3 주소록 폼 및 보고서 화면설계 ······························57
4.2 주소록 ACCDB 파일 만들기 58
4.3 주소록 테이블 60
4.3.1 주소록 테이블 만들기 ·····································60
4.3.2 테이블 구조 변경할 때 주의사항 ····························69
4.4 주소록 메인 화면 만들기 69
4.4.1 폼 오브젝트 기초 사용법 ···································69
4.4.2 주소록 폼 디자인하기 ·····································87
4.4.3 매크로 오브젝트 기초사용법 ·······························106
4.4.4 주소록 매크로 작업하기 ···································117
4.4.5 폼과 매크로 연결하기 ·····································121
4.5 주소록 보고서 만들기 124
4.5.1 보고서 기초 사용법 ·······································124
4.5.2 레이블 보고서 만들기 ····································130
4.5.3 주소록대장 보고서 만들기 ·································139
4.5.4 문서창 모양 변경하기 ····································155
4.5.5 주소록 마무리하기 ·······································159
Chapter 5 학생카드
5.1 학생카드 설계 169
5.1.1 학생카드 프로그램 미리보기 ································169
5.1.2 학생카드 프로그램 분석 ···································171
5.2 학생카드 테이블 만들기 176
5.2.1 주소록 테이블 수정 및 가족 테이블 만들기 ···················176
5.3 학생카드 폼 만들기 183
5.3.1 가족 정보를 위한 개인서브 하위 폼 만들기 ···················184
5.3.2 가족 정보를 위한 개인 상위 폼 만들기 ······················190
vi
차례
Chapter 6 성적관리
6.1 성적관리 설계 209
6.1.1 성적관리 프로그램 분석 ···································209
6.1.2 성적관리 부메뉴 화면 구성 ································215
6.2 성적관리 ACCDB와 테이블 만들기 217
6.2.1 성적관리 ACCDB와 테이블 만들기 ··························217
6.2.2 테이블간의 관계 등록하기 ·································226
6.3 학과등록 폼 만들기 231
6.3.1 과목 폼 만들기 ··········································232
6.3.2 과목 폼 수정하기 ········································233
6.3.3 학과 폼 만들기 ··········································237
6.4 성적 입력 폼 만들기 237
6.4.1 성적입력 폼 만들기 ······································238
6.4.2 이벤트와 모듈프로그래밍 ··································249
6.4.3 입력 폼 이벤트 프로그램 작성하기 ·························252
6.5 학번조회 폼 만들기 261
6.5.1 쿼리 오브젝트 기초사용법 ·································261
6.5.2 조회 폼 작업순서 ········································276
6.5.3 학번조회쿼리, 이름조회쿼리 만들기 ·························277
6.5.4 학번조회 하위 폼 만들기 ·································283
6.5.5 조회 상위 폼 만들기 ·····································286
6.5.6 조회 폼 이벤트 프로그램하기 ······························295
6.6 석차 폼 만들기 299
6.6.1 석차 폼 ················································299
6.6.2 석차쿼리 만들기 ········································300
6.6.3 석차서브 폼 만들기 ······································302
6.6.4 석차 상위 폼 만들기 ·····································314
6.6.5 이벤트 프로그램 작성하기 ·································326
6.6.6 성적대장 보고서 만들기 ··································332
6.6.7 보고서를 석차폼에 연결하기 ·······························338
6.7 스위치보드를 이용한 메인화면 만들기 340
6.8 마무리하기 349
vii
ACCESS 2010 실무 따라하기
Chapter 7 판매관리
7.1 판매관리 설계 및 분석 355
7.1.1 테이블 설계 ·············································355
7.1.2 메뉴 설계 ···············································361
7.2 테이블 생성 및 관계 설정하기 365
7.3 기초등록 폼 만들기 380
7.3.1 종류 등록 폼 만들기 ·····································380
7.3.2 제품 등록 폼 만들기 ·····································388
7.4 판매 폼 만들기 399
7.4.1 판매 폼의 구성 ··········································399
7.4.2 판매서브 폼 만들기 ······································401
7.4.3 판매 폼 만들기 ··········································409
7.4.4 판매영수증 보고서 만들기 ·································421
7.5 장부 폼 만들기 431
7.5.1 장부 폼의 구성 ··········································431
7.5.2 장부서브 폼 만들기 ······································432
7.5.3 장부 폼 만들기 ··········································436
7.5.4 장부 폼에 판매 폼 연결하기 ·······························442
7.6 수입 폼 만들기 452
7.6.1 수입서브1 폼 만들기 ······································453
7.6.2 수입서브2 폼 만들기 ·····································458
7.6.3 수입 폼 만들기 ··········································462
7.7 통계 폼 만들기 473
7.7.1 통계서브1 폼 만들기 ······································474
7.7.2 통계서브2 폼 만들기 ·····································478
7.7.3 통계 폼 만들기 ··········································486
7.8 삭제 폼 만들기 500
7.9 리본메뉴 만들기 508
7.9.1 메뉴실행을 위한 매크로 만들기 ····························509
7.9.2 판매 리본메뉴 만들기 ·····································513
7.9.3 메인화면 만들기 ·········································522
7.10 마무리하기 ··············································528
Chapter 8 MS-SQL 서버연결