Question

1. Write the various steps for opening a database when you have just started Access.
2. Write the various steps to insert a field in a table.
3. Write the various steps to delete a record in a table.

​

Answer 1

Answer:

Although every database follows the same two-step process: first somebody creates it and then people fill it with information, the same person doesn’t need to perform both jobs. In fact, in the business world, different people often work separately on these two tasks.

For example, a summer student whiz-kid at a beer store may build a database for tracking orders (task #1). The sales department can then use the database to enter new orders (task #2), while other employees look up orders and fill them (also task #2). Warehouse staff can make sure stock levels are OK (again, task #2), and the resident accountant can keep an eye on total sales (task #2).

If task #1 (creating the database) is done well, task #2 (using the database) can be extremely easy. In fact, if the database is well designed, people who have little understanding of Access can still use it to enter, update, and look up information. Amazingly, they don’t even need to know they’re running Access at all!

Answer 2

Answer:

1.1 click more under the open options

2.if necessary open the look in drop-down list box to select another drive or directory

3.click to select the file name of the database you want to open

4.click open .access opens the data base

2.1. select the form layout tools design tab then locate the tools Group on the right side of the ribbon.

2.click the add existing Flields command.

3.the flied list pane will appear select the field or fields to add to your form.

4. the new field will be added