We then describe a business example and give an outline for the database and applications we wish to develop. In the sections that follow, we give step-by-step instructions for creating the tables, data entry forms, reports and queries for the application. This tutorial is intended for students just getting started with the MS Access database management system. This tutorial assumes the student is familiar with the basic operation of a personal computer and Windows , Windows XP, Windows Vista or Windows 7.
Specific skills required for this tutorial are:. The student should have a USB memory stick thumb drive or other portable memory device available to store their files that will be created during this tutorial.
Note that you will need a legally licensed copy of Windows operating system to do this. There are two main ways to accomplish this:. Specific skills required for this tutorial are: Use of the mouse and keyboard Opening and saving files on the hard disk and on USB memory stick thumb drive for example Managing files in general including the difference between drive letters, hard disk, etc.
Running programs from the Windows Start menu Minimizing, maximizing and resizing windows The student should have a USB memory stick thumb drive or other portable memory device available to store their files that will be created during this tutorial. Lesson 3: Working with Microsoft Access Tables. After you create an Access table, you can modify it, enter data into it manually or import data from somewhere else, such as Excel.
This lesson teaches you how to modify a table and enter data. Lesson 4: Sorting, Filtering, and Creating Relationships.
You can sort Access data so you can view records in the order you want to view them, and you can filter data so you only see the records you want to see. This lesson teaches you how to sort and filter an Access table. Access data is stored in multiple tables. Relationships join tables together so you can work with the data from multiple tables. This lesson also teaches you how to create relationships. You can use a query to view a subset of your data or to answer questions about your data.
Alternatively, if you want to know which students live in DE, you can restrict your list to those students. This lesson teaches you how to create a query. Access forms are much like paper forms: you can use them to enter, edit, or display data. They are based on tables. When using a form, you can choose the format, the arrangement, and which fields you want to display.
This lesson teaches you how to create forms. Reports organize and summarize data for viewing online or for printing.
0コメント