Databases and tables In MS-ACESS

Sponsored Links

Databases and tables

Avoid multiple fields that contain similar data    

When you are creating a table of your choice, please make a note that there are no repeated columns in it, if there are any columns so, and then it becomes a huge problem to sort the data.

Sponsored Links

 For example, When you are designing a database for questionnaire, then it will definitely cause a problem.

Respondent ID Question no1 Question no 2 Question no 3
100 Yes Yes No
101 No Yes No

 

Here is the solution as shown below:

Respondent Questionnaire Response
100 1 Yes
100 2 Yes
100 3 No
101 1 No
101 2 Yes
101 3 No
102 1 Yes
102 2 No
102 3 Yes

Because each type of information is contained in only one field, searching, sorting, and calculating data are much easier.

Sponsored Links

Access specifications    

  • What could be the no of concurrent users at the max? 255
  • What could be the width of report? 22 inches
  • How many no of fields can they contain in a table? 255

Forms and reports

Add of vertical and horizontal lines to  report:    

Hence in Microsoft Access, using the Line Control you can add up as many rows or columns you need.

 

Here we can observe that the different horizontal and vertical lines placed among them.

For example, you have made certain changes to the data and you don’t want to keep those changes, then here is the procedure to be followed:

To revert back to the last saved versions, then  

  1. Click directly on the “Revert button on the File menu.
  2. The Revert command is unavailable until and unless when we opened a form or some other reports in the “Design view” and have made certain changes to it.

Move a form or report control to another section    

In a access form or report, moving a present or else existing system control to that of another section:

  1. First open the form or report in Design view.
  2. Then Click the control button.
  3. The pointer moves over control until and unless it provides some changes.
  4. Helps to drag the control from/to the other section.

Keyboard shortcuts Used For MS-Access:

Useful shortcut keys in Access    

Description Shortcut Keys
Helps to Insert today’s date CTRL+;
Helps us to Insert the current time CTRL+:
Used to Insert a carriage return in a memo or text field CTRL+ENTER
Helps to Insert the data from the same field in the previous record CTRL+’
Allows us to Undo the changes made to the current field ESC
In order to Undo the changes you made to the current record ESC (press ESC twice)
Helps to Display the database window F11
Mainly allows us to Open a new database CTRL+N
Provide  an existing database CTRL+O
It allows to Switch between the Visual Basic and the  Editor ,the previous active window ALT+F11
Find and replace methods CTRL+F
Copy method CTRL+C
Paste method CTRL+V
Undo method CTRL+Z
Save CTRL+S
Print CTRL+P