Course work - work with data in MS Access

Sold 1
Refunds 0
Good feedbacks 0
Bad feedbacks 0

INTRODUCTION 5

1 Working with data in Table 7

1.1 Data entry and validation 7

1.2 sorting, searching and filtering data 12

2 USING EXTERNAL DATA 22

2.1 formats are available to import, export, linking 22

2.2 IMPORT AND ACCESSION tables from the database ACCESS, spreadsheets, text files 24

2.3 RENEWAL OF RELATIONSHIPS WITH attached Table 34

2.4 to export data to other applications MS OFFICE 37

3 selection of records using queries 39

3.1 query Select: JOB selection criteria CREATING calculated fields, group operations 39

3.2 action request: SPECIES RULES creation and use 46

3.3 Cross-INQUIRIES 47

4 USE OF FORMS AND REPORTS TO WORK WITH DANNYMMI 50

4.1 APPOINTMENT OF FORMS OF CALCULATING in the form of 50

4.2 GENERAL INFORMATION ON THE REPORT, sorting and data grouping, summarizing 51

CONCLUSION 54

REFERENCES 55

APPENDIX 1 56

APPENDIX 2 61

ANNEX 3 71
INTRODUCTION 5

1 Working with data in Table 7

1.1 Data entry and validation 7

1.2 sorting, searching and filtering data 12

2 USING EXTERNAL DATA 22

2.1 formats are available to import, export, linking 22

2.2 IMPORT AND ACCESSION tables from the database ACCESS, spreadsheets, text files 24

2.3 RENEWAL OF RELATIONSHIPS WITH attached Table 34

2.4 to export data to other applications MS OFFICE 37

3 selection of records using queries 39

3.1 query Select: JOB selection criteria CREATING calculated fields, group operations 39

3.2 action request: SPECIES RULES creation and use 46

3.3 Cross-INQUIRIES 47

4 USE OF FORMS AND REPORTS TO WORK WITH DANNYMMI 50

4.1 APPOINTMENT OF FORMS OF CALCULATING in the form of 50

4.2 GENERAL INFORMATION ON THE REPORT, sorting and data grouping, summarizing 51

CONCLUSION 54

REFERENCES 55

APPENDIX 1 56

APPENDIX 2 61

ANNEX 3 71